arnab a écrit :
Dear All,
I'm trying to run Koha 2.2.7 using MySql 5.0. I could issue/return books. But the problem is regarding searching of books. Error is due to a SQL Script in the file SearchMarc.pm
Extract of the code.... my $sth; if ($sql_where2) { $sth = $dbh->prepare("select distinct m1.bibid from biblio,biblioitems,marc_biblio,$sql_tables where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and $sql_where2 and ($sql_where1) order by $orderby $desc_or_asc");
change for FROM $sql_tables, (biblio JOIN biblioitems USING (biblionumber) ) JOIN marc_biblio USING (biblionumber) WHERE m1.bibid=marc_biblio.bibid may work better. This is owed to the fact that implicit join are not managed the same in mysql5.0 HTH -- Henri-Damien LAURENT