[TYPO3-english] error in SQL syntax

Peder Høy Kristensen phiskit at gmail.com
Wed Jun 19 23:27:10 CEST 2013


phpinfo() shows mysql version 5.1.69

Venlig hilsen / Best Regards
Peder Høy Kristensen

Den 19/06/2013 kl. 22.39 skrev "d.ros" <projects at r-system.de>:

> 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
>> 
> 
> _______________________________________________
> 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