原帖由 plboy 于 2006-4-27 13:32 发表
Discuz! info: MySQL Query Error
User: admin
Time: 2006-4-27 1:30pm
Script: /bbs/plugin.php
SQL: SELECT * FROM cdb_flashdiy WHERE xltype='综合系列'
Error: Illegal mix of collations (latin1_ ...
数据升级输这个:
DROP TABLE IF EXISTS cdb_flashdiy;
CREATE TABLE cdb_flashdiy (
id int(10) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL,
flashname varchar(20) NOT NULL,
flashpic varchar(100) NOT NULL,
flashadd varchar(100) NOT NULL,
flashinfo text NOT NULL,
uptime int(10) unsigned NOT NULL default '0',
xltype varchar(20) NOT NULL,
fdgrade int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; |