[TYPO3-english] error in SQL syntax

bernd wilke t3ng at bernd-wilke.net
Thu Jun 20 08:53:00 CEST 2013


Am 19.06.13 19:54, schrieb Peder Høy Kristensen:
> Hi,
>
> when I create a new website (TYPO3 ver 6.1.1), I run the update wizard an finally run a database compare using Install tool / Database Analyser
>
> Result of database com are is the following error message:
>
> CREATE TABLE (( categories (int(11) NOT NULL default '0')
> 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 '( ( categories int(11) NOT NULL default '0' )' at line 1
>
> Could someone please tell me how to solve that problem?
>
> Venlig hilsen / Best Regards
> Peder Høy Kristensen
>

it's a missing default configuration for
$GLOBALS['TYPO3_CONF_VARS']['SYS']['defaultCategorizedTables']
which results in invalid SQL:

http://forge.typo3.org/issues/48381

bernd
-- 
http://www.pi-phi.de/cheatsheet.html


More information about the TYPO3-english mailing list