Hello, I`ve been trying to install Koha 2.2.4 for several days. I succeeded without big problems with installing it with Mysql 4.0.20, however it appeared that I need 5.0.21 because of UTF-8 and polish charset support. I reinstalled Linux (Arch)(screwed up a few things and wanted a clean install) and put Mysql 5.0.21 in with all Perl things and so on. Mysql server seems to work fine, phpMyAdmin connects to it without problems, mysqladmin from command line also does. Koha installs without problems until database creation - then it stops and displays this message: 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 followed with a whole bunch of DBD::mysql errors. What did I do wrong? Does anyone have any idea how to fix that? Please help. Regards, T. Holdowanski. mailto:mordazy@friko2.onet.pl ZAWSZE JEST JESZCZE NADZIEJA NA OGOLNOSWIATOWY KATAKLIZM.
On Tue, Jul 25, 2006 at 09:25:50AM +0200, Tomasz Holdowanski said:
Hello,
I`ve been trying to install Koha 2.2.4 for several days. I succeeded without big problems with installing it with Mysql 4.0.20, however it appeared that I need 5.0.21 because of UTF-8 and polish charset support. I reinstalled Linux (Arch)(screwed up a few things and wanted a clean install) and put Mysql 5.0.21 in with all Perl things and so on. Mysql server seems to work fine, phpMyAdmin connects to it without problems, mysqladmin from command line also does. Koha installs without problems until database creation - then it stops and displays this message:
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
followed with a whole bunch of DBD::mysql errors.
What did I do wrong? Does anyone have any idea how to fix that? Please help.
Hi Tomasz For a start is there a reason you choose to install 2.2.4 not 2.2.5 (thats the latest stable release). You can get it from savannah at http://download.savannah.nongnu.org/releases/koha/koha-2.2.5.tar.gz (Its linked to on the http://www.koha.org site) Now as to your error, its to do with the fact that there are some more reserved words in MySQL 5 than there were in versions 4 and 3. One of the words in one of the tables is one of the new reserved words. This may be fixed in 2.2.5 (if its not it will definitely be for 2.2.6), if not the fix for it is to edit the koha.mysql file find the line that is return char(4) default NULL, and make it `return` char(4) default NULL, Hope this helps Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
At 09:43 2006-07-25, you wrote:
For a start is there a reason you choose to install 2.2.4 not 2.2.5 (thats the latest stable release).
You can get it from savannah at http://download.savannah.nongnu.org/releases/koha/koha-2.2.5.tar.gz
(Its linked to on the http://www.koha.org site)
Thanks, but for now I have to hold on the 2.2.4 release. The Polish localization files are for 2.2.4... I don`t know if it would make any difference, but the 2.2.4 has been recommended to me.
Now as to your error, its to do with the fact that there are some more reserved words in MySQL 5 than there were in versions 4 and 3. One of the words in one of the tables is one of the new reserved words.
Thanks a lot! Haven`t tried the solution because just copied whole db structure from a working Polish Koha. Still, good to know the cause of the error. Cheers, Tomasz.
participants (2)
-
Chris Cormack -
Tomasz Holdowanski