Krzysztof Szwaba wrote:
Nie działa mi filtrowanie po dacie listy FV Po zdefiniowaniu np: 2007/09/01 otrzymuję komunikat błędu:
Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT d.id AS id, number, cdate, type, customerid, name, address, zip, city, template, closed, CASE reference WHEN 0 THEN SUM(a.value*a.count) ELSE SUM((a.value+b.value)*(a.count+b.count)) - SUM(b.value*b.count) END AS value, COUNT(a.docid) AS count FROM documents d LEFT JOIN invoicecontents a ON (a.docid = d.id) LEFT JOIN invoicecontents b ON (d.reference = b.docid AND a.itemid = b.itemid) LEFT JOIN numberplans ON (d.numberplanid = numberplans.id) WHERE (type = 3 OR type = 1) AND cdate >= 1188597600 AND cdate < 1188684000AND NOT EXISTS ( SELECT 1 FROM customerassignments a JOIN excludedgroups e ON (a.customergroupid = e.customergroupid) WHERE e.userid = lms_current_user() AND a.customerid = d.customerid) GROUP BY d.id, number, cdate, customerid, name, address, zip, city, template, closed, type, reference ORDER BY d.id asc Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS ( SELECT 1 FROM customerassignments a JOIN excludedgroups ' at line 13
Czy to jakiś bug ?
Konfiguracja:
Wersja LMS: 1.10.0rc3 Urgo (1.868.2.7/1.19.2.1)
widzę, że w cvsie jest to poprawione, myślę że w tym tygodniu jakaś nowa paczka 1.10 się pojawi.