[Koha-devel] 2.2.7-installer problems

[Chris Cormack]

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 at katipo.co.nz                                          www.katipo.co.nz