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?