Issue Bug Closed

#91358Analyze Database | Deletion of unused fields or tables impacts TYPO3 installation

Aristeidis Karavas 05/11/20, 13:02 updated 03/11/21, 20:29

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

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.