[Koha] Re: error 1064 at the installation

[Kochin Chang]

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