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) Wersja LMSDB: 1.10.0rc3 Urgo (1.42.2.1/1.48.2.1) Wersja MySQL: 5.0.22-Debian_0ubuntu6.06.3-log Wersja PHP: 5.1.2 Wersja Smarty: 2.6.18
Z góry dziękuję za pomoc. Krzysztof
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms