提供一个BUG:
数据库升级问题,默认的如果不是GBK将会显示:
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267
解决方法:
升级数据库语句:
drop table if exists cdb_postmach;
create table cdb_postmach (
style varchar(20) not null default '',
sside varchar(254) not null default '',
cdate int(18) not null default '0',
value text not null
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
insert into cdb_postmach values ('set', '0', 0, 'thison');
insert into cdb_postmach values ('set', '0', 0, 'other');
insert into cdb_postmach values ('set', '18', 0, 'reftime');
insert into cdb_postmach values ('set', '5', 0, 'whatis');
insert into cdb_postmach values ('set', '15', 0, 'usertime');
insert into cdb_postmach values ('set', '0', '0', 'posttid');
insert into cdb_postmach values ('set', '18', 0, 'posttime');
insert into cdb_postmach values ('set', '2', '0', 'moneys');
insert into cdb_postmach values ('set', '3', 0, 'replytime');
insert into cdb_postmach values ('set', '0', 0, 'fids');
insert into cdb_postmach values ('set', '2', 0, 'ext_type');
insert into cdb_postmach values('set', '1', 0, 'closetopic');
insert into cdb_postmach values ('set', '0', 0, 'moderatedstatus'); |