[TYPO3-english] error in SQL syntax

d.ros projects at r-system.de
Wed Jun 19 22:39:12 CEST 2013


What is you actual mysql Version ?



Am 19.06.2013 21:19, schrieb Peder Høy Kristensen:
> One point more: My web hotel tells me, that the name of the table is missing in the sql. Does that make any sense to you?
>
> Venlig hilsen / Best Regards
> Peder Høy Kristensen
>
> Den 19/06/2013 kl. 20.50 skrev Peder Høy Kristensen <phiskit at gmail.com>:
>
>> Well, my web hotel tells me, that is has to be an error in the SQL script … and that their mysql is updated to the latest version for the server platform they are running (CloudLinux 6.4).
>>
>> Could I possibly change the sql script – and which file should I change?
>>
>> Venlig hilsen / Best Regards
>> Peder Høy Kristensen
>>
>> Den 19/06/2013 kl. 20.19 skrev "d.ros" <projects at r-system.de>:
>>
>>> Am 19.06.2013 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
>>>>
>>>
>>> could be something like this -> http://forge.typo3.org/issues/47770
>>>
>>> Upgrade your mysql Server
>>>
>>> cheers David
>>>
>>> _______________________________________________
>>> TYPO3-english mailing list
>>> TYPO3-english at lists.typo3.org
>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>>
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>



More information about the TYPO3-english mailing list