解答：如何删除SupeSite/X-Space?

原帖由 popolice 于 2006-5-25 23:52 发表
Discuz! info: MySQL Query Error

Time: 2006-5-25 11:47pm
Script: /forumdisplay.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccod ...

这个你得用phpmyadmin执行这四条语句了
ALTER TABLE cdb_threads ADD `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0';

ALTER TABLE cdb_members ADD `xspacestatus` tinyint(1) NOT NULL DEFAULT '0';

INSERT INTO cdb_settings VALUES ('supe_siteurl', '$siteurl');
INSERT INTO cdb_settings VALUES ('supe_tablepre', '$stablepre');

测试哈合。来了一个个

我删除时出现了以下错误，怎么解决啊？？急！！！

Discuz! info: MySQL Query Error

Time: 2006-6-23 11:05pm
Script: /bbs/index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='X9fwHk' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='61.236.49.74' AND m.uid='2'
AND m.password='2c48fa2ed3ea8732c3828c749766ce78' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

事实上不行:
Discuz! info: MySQL Query Error

Time: 2006-6-27 10:34am
Script: /bbs/index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='P41mKP' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='61.140.32.99' AND m.uid='260'
AND m.password='f45423fa4c98cbb70ad0f25e68ea1529' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

出现楼上这种现象的你们查一下cdb_member里面有没有xspacestatus这个字段，我是打死都添加不进去。

找到解决方法了,看这里https://discuz.dismall.com/viewthread.php?tid=298170

[ 本帖最后由 akoo 于 2006-6-27 20:05 编辑 ]

晕，被楼主害死了，崩溃

请问：删除supesite也是这样操作吗？

原帖由 uusz 于 2006-7-6 17:50 发表请问：删除supesite也是这样操作吗？

原帖由 茄子 于 2006-4-3 16:03 发表
只需要
1，论坛后台升级数据库
DELETE FROM `cdb_settings` WHERE `variable` = 'supe_siteurl' limit 1;
DELETE FROM `cdb_settings` WHERE `variable` = 'supe_tablepre' limit 1;
ALTER TABLE `cdb_threads` ...

升级完这个以后，论坛打不开了，提示

Discuz! info: MySQL Query Error

Time: 2006-7-17 12:10pm
Script: /bbs/Index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='PXJawg' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='60.213.221.47' AND m.uid='3'
AND m.password='05913f15d9eb08ab03baa36d26599c03' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.


急求救

抱歉，已解决