[Koha-bugs] [Bug 727] [rel_2_0 branch] Cannot edit information attached to an order

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=727

a.c.li at ieee.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         OS/Version|                            |All



------- Additional Comments From a.c.li at 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.