Wystąpiły błędy w obsłudze bazy danych!
Zapytanie: SELECT a.id AS id, a.tariffid, a.customerid, a.period, a.at, a.suspended, a.invoice, a.settlement, a.datefrom, a.dateto, a.pdiscount, a.vdiscount, a.liabilityid, t.uprate, t.upceil, t.downceil, t.downrate, (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) AS value, (CASE WHEN t.name IS NULL THEN l.name ELSE t.name END) AS name FROM assignments a LEFT JOIN tariffs t ON (a.tariffid = t.id) LEFT JOIN liabilities l ON (a.liabilityid = l.id) WHERE a.customerid='102' AND (a.dateto > 1322953200 OR a.dateto = 0) AND (a.liabilityid = 0 OR (a.liabilityid != 0 AND (a.at >= 1322953200 OR a.at < 531))) ORDER BY a.datefrom, value
Błąd: Unknown column 'a.pdiscount' in 'field list'