[Koha] Koha 2.2.7 in Mysql 5

[arnab]

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");
warn "Q2 : 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 term is 
@$value";
} else {
$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_where1 order by $orderby $desc_or_asc");
warn "Q : 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_where1 order by $orderby $desc_or_asc";
}
$sth->execute();
my @result = ();
...........

whenever the script is running its giving error "warn Q.....". I couldn't
figure out why this particular SQL statement is not running using MySql 5. 


With Regards,

Arnab,

CDAC Kolkata,
India
-- 
View this message in context: http://www.nabble.com/Koha-2.2.7-in-Mysql-5-tp17398079p17398079.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.