[Koha] Re: error 1064 at the installation

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