[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 727] [rel_2_0 branch] Cannot edit information attached
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 727] [rel_2_0 branch] Cannot edit information attached to an order |
Date: |
6 Mar 2004 20:13:37 -0000 |
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=727
address@hidden changed:
What |Removed |Added
----------------------------------------------------------------------------
OS/Version| |All
------- Additional Comments From address@hidden 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.
- [Koha-bugs] [Bug 727] [rel_2_0 branch] Cannot edit information attached to an order,
bugzilla-daemon <=