A.L.E.C pisze:
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;
mysql> show create table rtmessages; +------------+--------------------| Table | Create | +------------+------------------------------------------------------------------
| rtmessages | CREATE TABLE `rtmessages` ( `id` int(11) NOT NULL auto_increment, `ticketid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `customerid` int(11) NOT NULL default '0', `mailfrom` varchar(255) NOT NULL default '', `subject` varchar(255) NOT NULL default '', `messageid` varchar(255) NOT NULL default '', `inreplyto` int(11) NOT NULL default '0', `replyto` text NOT NULL, `headers` text NOT NULL, `body` mediumtext NOT NULL, `createtime` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `ticketid` (`ticketid`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 | +------------+------------------------------------------------------------------
1 row in set (0.00 sec)
mysql> show create table rtnotes; +---------+---------------------------------------------------------------------- | Table | Create Table | +---------+----------------------------------------------------------------------+ | rtnotes | CREATE TABLE `rtnotes` ( `id` int(11) NOT NULL auto_increment, `ticketid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `body` text collate utf8_polish_ci NOT NULL, `createtime` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `ticketid` (`ticketid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci | +---------+-----------------------------------------------------------------------+ 1 row in set (0.00 sec)
mysql> show create table customers; +-----------+---------------------------------------------------------------------+ | Table | Create Table | +-----------+---------------------------------------------------------------------+ | customers | CREATE TABLE `customers` ( `id` int(11) NOT NULL auto_increment, `lastname` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `status` int(11) NOT NULL default '0', `email` varchar(255) NOT NULL default '', `address` varchar(255) NOT NULL default '', `zip` varchar(10) NOT NULL default '', `city` varchar(32) NOT NULL default '', `ten` varchar(16) NOT NULL default '', `ssn` varchar(11) NOT NULL default '', `info` text NOT NULL, `serviceaddr` text NOT NULL, `creationdate` int(11) NOT NULL default '0', `moddate` int(11) NOT NULL default '0', `creatorid` int(11) NOT NULL default '0', `modid` int(11) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `message` text NOT NULL, `pin` int(6) NOT NULL default '0', `regon` varchar(255) NOT NULL default '', `rbe` varchar(255) NOT NULL default '', `icn` varchar(255) NOT NULL default '', `notes` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=511 DEFAULT CHARSET=utf8 | +-----------+---------------------------------------------------------------------+ 1 row in set (0.00 sec)
czy zgłoszenia dodane w LMSie są wyświetlane prawidłowo?
Niestety jest to samo czyli z błędem. Tutaj foto jak to wygląda: http://slave.ticom.pl/lms.jpg
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms