Re: [Koha] issue between koha 2.5 and mysql 5.0

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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com