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.
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.
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
I believe that is not the only thing needs to be fixed. There are other places have to be changed in order for Koha to work with MySQL 5.x. Some SQL syntax have been changed from MySQL 4.x to 5.x, so SQL codes must be re-examined and modified accordingly. It can be done, but also create problems when updates to new release. (Personally tried that with Koha 2.2.5.) There are some documents on the Web and posts on this group about this. Kochin Robert Lyon wrote:
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
Yes, I'm using mysql Ver 14.12 Distrib 5.0.30, for pc-linux-gnu (i486) using readline 5.2 Can I use mysql 4 and 5 ? Or must I uninstall mysql5 and install mysql 4 ? Kochin Chang a écrit :
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
participants (3)
-
Kochin Chang -
Robert Lyon -
Thibaud Hulin