actually, i edited the koha.mysql and put the back quote on the return field. any suggestions on my error sir? tnx in advance!<br><br>eric<br><br><div><span class="gmail_quote">On 5/25/06, <b class="gmail_sendername">Stephen Hedges
</b> <<a href="mailto:shedges@skemotah.com">shedges@skemotah.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Eric, did your install actually complete? Usually there's a problem with
<br>MySQL 5 because "return" is both a reserved word and the name of a Koha<br>column, so the install aborts.<br><br>Stephen<br><br>eric salayon wrote:<br>> is there an issue between koha 2.5 and mysql 5.0? my logs have this:
<br>><br>> [Mon May 22 14:35:21 2006] [error] [client <a href="http://10.0.0.9">10.0.0.9</a>] DBD::mysql::st<br>> fetchrow_hashref failed: fetch() without execute() at<br>> /www/Koha/Librarian/modules/C4/SearchMarc.pm line 366., referer:
<br>> <a href="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">
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
</a><br>> [Mon May 22 14:35:21 2006] [error] [client <a href="http://10.0.0.9">10.0.0.9</a>] DBD::mysql::st<br>> execute<br>> failed: Unknown column 'biblio.biblionumber' in 'on clause' at<br>> /www/Koha/Librarian/modules/C4/SearchMarc.pm line 364., referer:
<br>> <a href="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">
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
</a><br>><br>><br>> any idea?<br>> _______________________________________________<br>> Koha mailing list<br>> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha">
http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>><br><br><br>--<br>Stephen Hedges<br>Skemotah Solutions, USA<br><a href="http://www.skemotah.com">www.skemotah.com</a> -- <a href="mailto:shedges@skemotah.com">shedges@skemotah.com
</a><br><br></blockquote></div><br>