Bug #67459
closed
sys_refindex has unknown column id / uid in field list
0%
Description
TYPO3 6.2.13:
When I save the content "text/image" in the backend TCE, then I debug the following error output:
*caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column 'uid' in 'field list'
lastBuiltQuery SELECT uid FROM sys_refindex WHERE uid=LAST_INSERT_ID() LIMIT 1
debug_backtrace TYPO3\CMS\Backend\Controller\EditDocumentController->processData#35 // TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap#512 // TYPO3\CMS\Core\DataHandling\DataHandler->processRemapStack#1264 // TYPO3\CMS\Core\DataHandling\DataHandler->updateDB#5315 // TYPO3\CMS\Core\DataHandling\DataHandler->updateRefIndex#6027 // TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable#6187 // Geithware\DebugMysqlDb\Database\DatabaseConnection->exec_INSERTquery#219 // Geithware\DebugMysqlDb\Database\DatabaseConnection->myDebug#154 // Geithware\DebugMysqlDb\Database\DatabaseConnection->getLastInsertId#723 // Geithware\DebugMysqlDb\Database\DatabaseConnection->exec_SELECTgetRows#617 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#359
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR Unknown column 'id' in 'field list'
lastBuiltQuery SELECT id FROM sys_refindex WHERE id=LAST_INSERT_ID() LIMIT 1
debug_backtrace TYPO3\CMS\Backend\Controller\EditDocumentController->processData#35 // TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap#512 // TYPO3\CMS\Core\DataHandling\DataHandler->processRemapStack#1264 // TYPO3\CMS\Core\DataHandling\DataHandler->updateDB#5315 // TYPO3\CMS\Core\DataHandling\DataHandler->updateRefIndex#6027 // TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable#6187 // Geithware\DebugMysqlDb\Database\DatabaseConnection->exec_INSERTquery#219 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#158
*
Updated by Christian Kuhn over 9 years ago
Don't fully understand this by looking at the core source ... is this maybe a side effect of "Geithware\DebugMysqlDb" ?
Updated by Franz Holzinger over 9 years ago
Yes, this failure is inside of the extension debug_mysql_db.
Do you know which TYPO3 tables are also missing the field 'uid'?
Updated by Christian Kuhn over 9 years ago
- Status changed from New to Closed
Afaik the cache tables miss a uid, too.
Closing this issue, not a core problem.