Bug #53650
closedUpgrade Wizard for FAL references SQL error on missing tables
100%
Description
If you have some sys_file_references pointing to tables that no longer exist in your installation (some extension that was deleted and the tables also deleted), you end up with SQL errors in the Install Tool when calling the Upgrade Wizards:
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Table 'typo3.buggy_table' doesn't exist
lastBuiltQuery SELECT uid, pid FROM buggy_table WHERE uid=0 AND pid<>0 LIMIT 1
So the proposal is to use the same upgrade wizard which is already cleaning sys_file_reference to get rid of these buggy entries, while also fixing this SQL error bug.
How to reproduce?
Simply add a row to sys_file_reference with "pid=0" and "tablenames" pointing to some tablename that doesn't exist.
Updated by Gerrit Code Review almost 11 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25414
Updated by Gerrit Code Review almost 11 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25414
Updated by Gerrit Code Review over 10 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25414
Updated by Gerrit Code Review over 10 years ago
Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25414
Updated by Gerrit Code Review over 10 years ago
Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25414
Updated by Ernesto Baschny over 10 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset b2c79153286d1732f837d6a13cc1295585a208dc.
Updated by Riccardo De Contardi almost 7 years ago
- Status changed from Resolved to Closed