Project

General

Profile

Actions

Bug #52008

closed

SQL error in install tool if no root page available

Added by Steffen Müller over 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
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 #1

Updated by Steffen Müller over 10 years ago

  • Subject changed from SQL error in install tool if no root page to SQL error in install tool if no root page available
Actions #2

Updated by Gerrit Code Review over 10 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/23833

Actions #3

Updated by Steffen Müller over 10 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF