社区监狱插件问题集[06/12/30](有关此插件的问题全部在此)

逮捕后的会员,点击逃狱后显示的界面为如下提示:小F看一下是什么原因
Discuz! info: MySQL Query Error

User: 3
Time: 2006-12-31 11:10am
Script: /plugin.php

SQL: SELECT COUNT(*) FROM cdb_postban_escapelog WHERE prison='3'
Error: Table 'wfddc.cdb_postban_escapelog' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

升级错误，MySQL 提示: Table 'cdb_postban' already exists

没事了～嘿嘿～不好意思～看错了～^_^～谢谢LZ～

[ 本帖最后由 bellrain 于 2006-12-31 11:59 编辑 ]

进入监狱……


Discuz! info: MySQL Query Error

User: 子夜冷风
Time: 2006-12-31 12:08pm
Script: /zc/bbs/plugin.php

SQL: SELECT COUNT(*) FROM zcbbs_cdb_postban
Error: Table 'fzasus_asus.zcbbs_cdb_postban' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

原帖由 小铭铭 于 2006-12-31 11:18 发表
逮捕后的会员,点击逃狱后显示的界面为如下提示:小F看一下是什么原因
Discuz! info: MySQL Query Error

User: 3
Time: 2006-12-31 11:10am
Script: /plugin.php

SQL: SELECT COUNT(*) FROM cdb_postban ...

数据库升级了吗?

原帖由 bellrain 于 2006-12-31 12:12 发表
进入监狱……


Discuz! info: MySQL Query Error

User: 子夜冷风
Time: 2006-12-31 12:08pm
Script: /zc/bbs/plugin.php

SQL: SELECT COUNT(*) FROM zcbbs_cdb_postban
Error: Table 'fzasus_asus ...

升级数据库

MJJ的~

支持freddy！俺的站用了！谢谢！

小F帮看一下什么原因

全新安装升级第一个升级语句,

1. 
   
2. CREATE TABLE `cdb_postban` (
   
3.   `pb_id` int(10) unsigned NOT NULL auto_increment,
   
4.   `username` varchar(15) NOT NULL default '',
   
5.   `opername` varchar(15) NOT NULL default '',
   
6.   `fid` smallint(6) unsigned NOT NULL default '0',
   
7.   `timelimit` int(10) unsigned NOT NULL default '0',
   
8.   `starttime` int(10) unsigned NOT NULL default '0',
   
9.   `pbmoney` int(10) NOT NULL default '0',
   
10.   `reason` text NOT NULL,
    
11.   PRIMARY KEY  (`pb_id`),
    
12.   KEY `fid` (`fid`)
    
13. ) TYPE=MyISAM DEFAULT CHARSET=gbk ;
    
14. 
    
15. CREATE TABLE `cdb_postban_escapelog` (
    
16.   `pb_id` int(10) unsigned NOT NULL auto_increment,
    
17.   `prison` varchar(15) NOT NULL default '',
    
18.   `starttime` int(10) unsigned NOT NULL default '0',
    
19.   PRIMARY KEY  (`pb_id`)
    
20. ) ENGINE=MyISAM DEFAULT CHARSET=gbk ;
    

复制代码

最后点击逮捕会员时提示以下错误

1. 
   
2. Discuz! info: MySQL Query Error
   
3. 
   
4. User: admin
   
5. Time: 2006-12-31 12:38pm
   
6. Script: /plugin.php
   
7. 
   
8. SQL: select count(*) FROM cdb_postban WHERE username='小鱼' AND fid='65535'
   
9. Error: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
   
10. Errno.: 1267
    
11. 
    
12. Similar error report has beed dispatched to administrator before.
    

复制代码

[ 本帖最后由 小铭铭 于 2007-1-1 12:58 编辑 ]

....

原先升级过一次，我是5.0，错将第二个语句升级了……结果错误，现在再升级第一个……

升级错误，MySQL 提示: Table 'cdb_postban' already exists

老大～接下来该怎么办啊？