出现下面错误的解决办法:
Discuz! info: MySQL Query Error
User: 123123
Time: 2007-4-11 11:12pm
Script: /plugin.php
SQL: SELECT * from [Table]qiuhun where dlg='0' and (username='naoki or tousername='孤单水瓶男)
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267
在后台升级数据库:
DROP TABLE IF EXISTS cdb_jhzhufu;
CREATE TABLE `cdb_jhzhufu` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`jhid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`lmoney` int(10) unsigned default NULL,
`message` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_jie;
CREATE TABLE `cdb_jie` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`thename` varchar(15) NOT NULL default '',
`year` int(10) unsigned default NULL,
`longs` int(10) unsigned default NULL,
`addtime` int(10) unsigned default NULL,
`TYPE` tinyint(3) unsigned NOT NULL default '0',
`content` text,
`jiehun` tinyint(1) unsigned NOT NULL default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=10 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_lihun;
CREATE TABLE `cdb_lihun` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`reason` text,
`indict` smallint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_qiuhun;
CREATE TABLE `cdb_qiuhun` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`message` text,
`dlg` tinyint(1) unsigned NOT NULL default '0',
`jiehun` tinyint(1) unsigned NOT NULL default '0',
`content` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=10 CHARSET=gbk; |