Issue Bug Closed

#52008SQL error in install tool if no root page available

Steffen Müller 09/14/13, 17:52 updated 10/23/17, 21:48

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().

Reviews 1