Re: [lms] Błąd w helpdesku

14 Gru 2007


      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

Maxwel

Błąd: Illegal mix of collations for operation 'UNION'

znaczniki (0)

uczestnicy (1)