[Koha] issue between koha 2.5 and mysql 5.0

[eric salayon]

actually, i edited the koha.mysql and put the back quote on the return
field. any suggestions on my error sir? tnx in advance!

eric

On 5/25/06, Stephen Hedges <shedges at skemotah.com> wrote:
>
> Eric, did your install actually complete?  Usually there's a problem with
> MySQL 5 because "return" is both a reserved word and the name of a Koha
> column, so the install aborts.
>
> Stephen
>
> eric salayon wrote:
> > is there an issue between koha 2.5 and mysql 5.0? my logs have this:
> >
> > [Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st
> > fetchrow_hashref failed: fetch() without execute() at
> > /www/Koha/Librarian/modules/C4/SearchMarc.pm line 366., referer:
> >
> http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search
> > [Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st
> > execute
> > failed: Unknown column 'biblio.biblionumber' in 'on clause' at
> > /www/Koha/Librarian/modules/C4/SearchMarc.pm line 364., referer:
> >
> http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search
> >
> >
> > any idea?
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> --
> Stephen Hedges
> Skemotah Solutions, USA
> www.skemotah.com  --  shedges at skemotah.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20060526/3ce2f8df/attachment.htm