Project

General

Profile

Actions
Copy link

Bug #53650

closed

Upgrade Wizard for FAL references SQL error on missing tables

Added by Ernesto Baschny about 11 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Ernesto Baschny
Category:
Install Tool
Target version:
6.2.0
Start date:
2013-11-14
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

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.

Actions
Copy link

Also available in: Atom PDF