Actions
Bug #52008
closedSQL error in install tool if no root page available
Start date:
2013-09-14
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
Steps to reproduce:
- Setup a plain new dummy installation
- Login to backend
- Go to install tool
- Go to Configuration presets, Development / Production settings and select "Development".
- Go to Update Wizard.
ExtJS console shows the following error:
DB error exec_SELECTquery caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 lastBuiltQuery SELECT uid,pid FROM sys_template WHERE deleted=0 AND root=1 AND pid IN () debug_backtrace TYPO3\CMS\Install\Controller\ToolController->execute#129 // TYPO3\CMS\Install\Controller\ToolController->dispatchAuthenticationActions#74 // TYPO3\CMS\Install\Controller\Action\Tool\UpdateWizard->handle#176 // TYPO3\CMS\Install\Controller\Action\Tool\UpdateWizard->listUpdates#58 // TYPO3\CMS\Install\Updates\AbstractUpdate->shouldRenderNextButton#94 // TYPO3\CMS\Install\Updates\RootTemplateUpdate->checkForUpdate#142 // TYPO3\CMS\Install\Updates\RootTemplateUpdate->findRootTemplates#50 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTgetRows#155 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#366
This is caused by TYPO3\CMS\Install\Updates\RootTemplateUpdate::findRootLevelPages() which should return NULL for empty root level pages, but returns array().
Actions