原帖由 macleo 于 2006-4-22 00:12 发表
参数设置演示
这个插件,oytktk,做的很奇怪!思路很特别!
报错情况汇总166楼报错:
爲什麽????
Discuz! info: MySQL Query Error
User:ap866
Time: 2006-4-24 7:17pm
Script: /bbs/postmach.php
SQL: SELECT * FROM cdb_postmach WHERE style='post' and sside='0' and value='路過.,順便飄進來看看~~~ 繼續飄走... '
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267
An error report has been dispatched to our administrator.
我刚才发的方法被删了,没办法重发一次,这样升级数据库(强制编码):
1.从后台数据库升级
第一步(GBK使用)
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;
第一步(BIG5使用)
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=BIG5;
第二步
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');
[ 本帖最后由 hfl 于 2006-8-25 19:27 编辑 ] |