Maxwel wrote:
--- Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* (SELECT rtmessages.id AS id, mailfrom, subject, body, createtime, CONCAT(UPPER(customers.lastname), ' ', customers.name) AS customername, userid, users.name AS username, customerid FROM rtmessages LEFT JOIN customers ON (customers.id = customerid) LEFT JOIN users ON (users.id = userid) WHERE ticketid = '17') UNION (SELECT rtnotes.id AS id, NULL, NULL, body, createtime, NULL, userid, users.name AS username, NULL FROM rtnotes LEFT JOIN users ON (users.id = userid) WHERE ticketid = '17') ORDER BY createtime ASC *Błąd:* Illegal mix of collations for operation 'UNION' ---
mi to wygląda na błąd w konfiguracji mysqla, lub błąd samego mysqla, pokaż: show create table rtmessages; show create table rtnotes; show create table customers; czy zgłoszenia dodane w LMSie są wyświetlane prawidłowo? -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms