庆(7-1)新概念插件 PPview(贴图中心) 1.0 By Oytktk(靖飒) 08-14更新

ls还没睡啊

原帖由 oytktk 于 2007-7-10 00:12 发表


是吗? FF不用啊, 截个图来看看吧?~P

:) :) :)

原来是MAXSPEED风格问题 其他的风格没问题

指定主题或版块已成功添加到收藏夹中。:)

我的论坛是GBK的，我按照楼主说的办法升级数据库，可是提示说最后一行CHARSET=gbk处有错误..

于是我尝试了一下用您说的第二种方法.结果安装正确.

可能是我没设置好吧。本来有好多符合条件的图都没显示出来...于是我就准备先不装了，反正也有记号了，以后在说.
我在升级数据库之前做了备分，于是就直接用后台的数据恢复功能进行恢复...反正大晚上的也没几个人......

结果......就出现了大问题了...无法恢复数据...一直提示说

1. 
   
2. There seems to have been a problem with the database of your Discuz! Board
   
3. 
   
4. Discuz! info: MySQL Query Error
   
5. 
   
6. User:*******
   
7. Time: 2007-7-11 2:46am
   
8. Script: /admincp.php
   
9. 
   
10. SQL: CREATE TABLE cdb_payset (  groupid int(5) unsigned NOT NULL default '0',  type tinyint(1) NOT NULL default '1',  enable tinyint(1) NOT NULL default '0',  allowrank tinyint(1) NOT NULL default '0',  allowcheck tinyint(1) NOT NULL default '0',  allowview tinyint(1) NOT NULL default '0',  allowforum tinyint(1) NOT NULL default '0',  forum varchar(255) NOT NULL default '0,0,0,0,0,0,0,0',  leaveday mediumint(8) NOT NULL default '0',  group mediumint(8) NOT NULL default '0',  getprice mediumint(8) NOT NULL default '0',  tax mediumint(8) NOT NULL default '0',  up mediumint(8) NOT NULL default '0',  down mediumint(8) NOT NULL default '0',  rank varchar(255) NOT NULL default '0,0,0,0,0',  check varchar(255) NOT NULL default '0,0,0,0,0',  well varchar(255) NOT NULL default '0,0,0,0,0',  top varchar(255) NOT NULL default '0,0,0,0,0',  admin varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',  post varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',  digest varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',  online varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',  pageview varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',  KEY groupid (groupid)) TYPE=MyISAM
    
11. Error:  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group mediumint(8) NOT NULL default '0',  getprice mediumint(8)
    
12. Errno.:  1064
    
13. 
    
14. Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
    
15. If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net

复制代码

然后我去看数据库发现payset表已经丢失了......
这个应该是版主工资的东西....https://discuz.dismall.com/thread-538883-1-1.html

这个时候我在访问版主工资的时候显示：

1. 
   
2. Script: /plugin.php
   
3. 
   
4. SQL: SELECT * FROM cdb_payset WHERE type='1' AND groupid='1' LIMIT 1
   
5. Error:  Table 'hrbuupbbs.cdb_payset' doesn't exist
   
6. Errno.:  1146
   
7. 
   
8. Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
   
9. If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.  

复制代码

我删除了贴图中心、版主工资的表，然后进行资料恢复依然不行.

后来再尝试进行备份资料的时候显示：

1. 
   
2. Script: /redirect.php
   
3. 
   
4. SQL: SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
   
5.           m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
   
6.           m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.hw, m.invisible, m.xspacestatus, mf.nickname, mf.site,
   
7.           mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
   
8.           mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_4
   
9.           FROM cdb_posts p
   
10.           LEFT JOIN cdb_members m ON m.uid=p.authorid
    
11.           LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
    
12. WHERE p.tid='49' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10
    
13. Error:  Unknown column 'm.hw' in 'field list'
    
14. Errno.:  1054
    
15. 
    
16. Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
    
17. If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.  

复制代码

之后进行数据库校验的时候显示：

khtime int(11) NOT NULL	用户新增字段[/td]
cdb_members
字段	状态
dateformat varchar(10) NOT NULL >>> char(10) NOT NULL	字段被修改
email varchar(50) NOT NULL >>> char(50) NOT NULL	字段被修改
extgroupids varchar(60) NOT NULL >>> char(60) NOT NULL	字段被修改
lastip varchar(15) NOT NULL >>> char(15) NOT NULL	字段被修改
password varchar(32) NOT NULL >>> char(32) NOT NULL	字段被修改
regip varchar(15) NOT NULL >>> char(15) NOT NULL	字段被修改
secques varchar(8) NOT NULL >>> char(8) NOT NULL	字段被修改
timeoffset varchar(4) NOT NULL >>> char(4) NOT NULL	字段被修改
username varchar(15) NOT NULL >>> char(15) NOT NULL	字段被修改
hw varchar(15)	用户新增字段

尝试修复这9个字段的时候，提示成功，可再次检验的时候依然这样显示.

请问各位大虾，这是什么原因引起的？
应该怎么才能恢复？
现在的论坛不能备份资料和恢复资料，非常不稳定，希望各位能帮我想点办法

[ 本帖最后由 LoneDisc 于 2007-7-11 05:10 编辑 ]

哎....完全无法采集图片~晕.....

感谢分享,很实用的插件啊

安装是成功的!很高兴!但是收集不到图片,显示"本次的收集程序执行了 500 个帖子, 共收集了 0 张贴图, 现在转入后 500 个贴子..."
...........
LZ什么时候才能解决这个问题啊?拜托啦!!~~~~~~~~~

另外...我太喜欢你演示里的天气预报了....什么时候能SHARE一下啊?哈哈~