Łukasz Rostalski wrote:
Witam jak wchodzę w Helpdesk to dostaję taki komunikat:
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 = '7') 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 = '7') ORDER BY createtime ASC Błąd: Illegal mix of collations for operation 'UNION'
Wersja MySQL: 5.0.32-Debian_7etch1-log
u mnie to zapytanie się wykonuje bez błędu, zaktualizuj mysqla (u mnie 5.0.45), albo masz coś innego w bazie skopane