Bug #91358
closedAnalyze Database | Deletion of unused fields or tables impacts TYPO3 installation
0%
Description
The Analyze Database module SHOULD only delete fields or tables that are absolutely not used to any query.
Example 1:
The module wanted me to delete the table sys_domain because i had no use of it. Which makes sense since i do not use it. I deleted
the table via the module and then i got the following in the FrontEnd:
An exception occurred while executing 'SELECT * FROM `sys_domain` WHERE `sys_domain`.`hidden` = 0 ORDER BY `sorting` ASC': Table 'database_name.sys_domain' doesn't exist
At this point, the Analyze Database module should not have suggested and delete the table because clearly without it, FrontEnd won't work.
Possible solution:
Before the request is sent, check if the table exists
Updated by Oliver Hader almost 4 years ago
- Status changed from New to Needs Feedback
Does that happen in TYPO3 v10.4.2? Could you please provide a stack-trace of the error? I was not able to find `sys_domain` occurrences in the front-end rendering process of recent Git version for TYPO3 v10. Thx in advance for your feedback!
Updated by Georg Ringer about 3 years ago
closing the issue because lack of feedback. sys_domains are not in use by the core but might have been used by an extension
Updated by Riccardo De Contardi about 3 years ago
- Status changed from Needs Feedback to Closed