Project

General

Profile

Actions

Bug #91358

closed

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

Added by Aristeidis Karavas almost 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2020-05-11
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
database, frontend, analyze
Complexity:
Is Regression:
Sprint Focus:

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

Actions #1

Updated by Aristeidis Karavas almost 4 years ago

  • Description updated (diff)
Actions #2

Updated by Aristeidis Karavas almost 4 years ago

  • Description updated (diff)
Actions #3

Updated by Aristeidis Karavas almost 4 years ago

  • Description updated (diff)
Actions #4

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!

Actions #5

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

Actions #6

Updated by Riccardo De Contardi about 3 years ago

  • Status changed from Needs Feedback to Closed
Actions

Also available in: Atom PDF