[Koha] Re: error 1064 at the installation

[Robert Lyon]

It turns out that return is a reserved word for mysql 5
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

So the problem lies with a column called return

This needs to be fixed for it to work in mysql5
(how I'm not sure)

Bob


Kochin Chang wrote:
> Are you using MySQL 5.x? The current version of Koha is not compatible 
> with MySQL 5.x.
>
> Kochin
>
> Thibaud Hulin wrote:
>> Hi !
>> I'm trying Koha on a Debian sarge testing, but I have an error after
>> launching install.pl and enter my sql password. This is the error 
>> message :
>>  CREATING DATABASE
>>
>> Creating the MySQL database for Koha...
>> 0
>> ERROR 1064 (42000) at line 772: 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 'return char(4) default NULL,
>>   renewals tinyint(4) default NULL,
>>   timestamp tim' at line 9
>>
>> Start tag expected, '<' not found
>>  at /usr/lib/perl5/XML/LibXML/SAX.pm line 64
>>  at /usr/share/perl5/XML/Simple.pm line 287
>> BEGIN failed--compilation a
>>
>> I'm a beginner with sql.
>>
>> Thanks for help,
>> Thibaud.
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha


-- 
Robert Lyon
Katipo Communications