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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Robert Lyon Katipo Communications