Fehler #34
Bei Lieferanten Lieferungen anzeigen geht nicht
Status:
Erledigt
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
02/05/2015
Due date:
% Done:
0%
Estimated time:
Description
Es kommt folgende Meldung
{"error":"SELECT
s.shiptoname,
i.qty * -1 AS qty,
ap.id,
ap.transdate,
ap.invnumber,
ap.ordnumber,
i.description,
i.unit,
i.sellprice,
oe.id AS oe_id,
invoice
FROM ap
LEFT JOIN shipto s
ON (ap.id = s.trans_id)
LEFT JOIN invoice i
ON ap.id = i.trans_id
LEFT JOIN parts p
ON p.id = i.parts_id
LEFT JOIN oe
ON (oe.ordnumber = ap.ordnumber AND NOT ap.ordnumber = ''
AND oe_vendor_id IS NOT NULL )
WHERE 1=1 AND ap.vendor_id = ?
ORDER BY ap.transdate DESC LIMIT 15 (1397)
ERROR: column \"oe_vendor_id\" does not exist
LINE 26: AND oe_vendor_id IS NOT NULL )
^"}
History
Updated by G. Richardson almost 10 years ago
- Status changed from Neu to Erledigt
Behoben in Commit 3e0483ee5d