On Sat, Mar 03, 2007 at 02:03:05AM +0100, Dorian Meid said:
Am 03.03.2007 um 01:06 schrieb Dorian Meid:
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
Found the bug: It's in the koha.mysql, line 780
it is: return char(4) default NULL,
and should be: `return` char(4) default NULL,
Dorian, This is just one of the problems with 2.2.7 and mysql 5. There have been quite a few mails on the list about them. Heres a little write up http://blog.katipo.co.nz/?p=18 As far as I know they have all been fixed in cvs now. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz