[D4.1 & D.5.X]BBS2ME感謝卡V3.1(感謝作者,心心,THANK U功能)(簡繁體)

我装了～～不会用啊～～！！！！！！！！！！！！！

好东西，非常支持，来一张感谢卡支持你，呵呵～

我顶～！！！

Script: /plugin.php

SQL: SELECT * FROM cdb_thanklog WHERE asfe='thank' and fromuser='sexy99' and touser='隨風飄逝' and tid='594'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

简体呢？？

原帖由 talentz 于 2006-8-17 20:58 发表
简体呢？？

BBS2ME 感謝卡V3.0_big5+gb2312.rar
看不懂??

原帖由 chiaho 于 2006-8-17 20:15 发表
Script: /plugin.php

SQL: SELECT * FROM cdb_thanklog WHERE asfe='thank' and fromuser='sexy99' and touser='隨風飄逝' and tid='594'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) an ...

更改你的數據庫字符集 gbk
或是反安裝數據後重新升級數據庫


簡體

1. CREATE TABLE `cdb_thanklog` (
   
2. `id` mediumint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
   
3. `fromuser` varchar( 15 ) NOT NULL default '',
   
4. `fromuseruid` mediumint( 8 ) NOT NULL ,
   
5. `touser` varchar( 15 ) NOT NULL default '',
   
6. `asfe` varchar( 8 ) NOT NULL default '',
   
7. `score` int( 10 ) NOT NULL default '0',
   
8. `tid` varchar( 15 ) NOT NULL default '',
   
9. `aswhat` varchar( 100 ) NOT NULL default '',
   
10. `logdate` date NOT NULL ,
    
11. PRIMARY KEY ( `id` )
    
12. ) ENGINE = MYISAM CHARSET=gbk;

复制代码

繁體

1. CREATE TABLE `cdb_thanklog` (
   
2. `id` mediumint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
   
3. `fromuser` varchar( 15 ) NOT NULL default '',
   
4. `fromuseruid` mediumint( 8 ) NOT NULL ,
   
5. `touser` varchar( 15 ) NOT NULL default '',
   
6. `asfe` varchar( 8 ) NOT NULL default '',
   
7. `score` int( 10 ) NOT NULL default '0',
   
8. `tid` varchar( 15 ) NOT NULL default '',
   
9. `aswhat` varchar( 100 ) NOT NULL default '',
   
10. `logdate` date NOT NULL ,
    
11. PRIMARY KEY ( `id` )
    
12. ) ENGINE = MYISAM CHARSET=big5;

复制代码

[ 本帖最后由 阿狗狗 于 2006-8-18 00:06 编辑 ]

SQL: SELECT t.fromuser,t.fromuseruid, t.id, t.touser, t.asfe, t.score, t.tid, t.aswhat,t.logdate,t.touseruid,tt.subject,tt.tid FROM cdb_thanklog t LEFT JOIN cdb_threads tt ON tt.tid=t.tid WHERE t.tid='18154' ORDER BY logdate DESC LIMIT 0 , 30
Error: Unknown column 't.touseruid' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

沒有升級數據庫  請你注意看一下一樓 還有上面17樓說明

支持下