http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=727 a.c.li@ieee.org changed: What |Removed |Added ---------------------------------------------------------------------------- OS/Version| |All ------- Additional Comments From a.c.li@ieee.org 2004-03-07 09:13 ------- I have traced this to C4::Biblio::getsingleorder() returning undef for an existing order. The SQL statement is Select * from biblio,biblioitems,aqorders,aqorderbreakdown where aqorders.ordernumber=? and aqorders.ordernumber=aqorderbreakdown.ordernumber; and it seems that the aqorderbreakdown table is blank. It seems that the correct SQL statement should be Select * from biblio,biblioitems,aqorders left join aqorderbreakdown on aqorders.ordernumber=aqorderbreakdown.ordernumber where biblio.biblionumber=aqorders.biblionumber and biblio.biblionumber=biblioitems.biblionumber and aqorders.ordernumber=? ; ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.