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

我碰到拉 5555555555555       可是我不知道怎么解决啊  

Discuz! info: MySQL Query Error

Time: 2006-7-18 7:56pm
Script: /admincp.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='EGSoAN' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='60.178.128.127' AND m.uid='1'
AND m.password='debad1eb27354674418b128b013c3bcd' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.
有好多跟贴是这样的  那些帖子上有红红的  

程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

我是菜鸟一只，根本看不懂，请好心人帮帮忙啊  救急，非常感谢！！！

强烈建议:
强烈建议 茄子 ,将3楼所说的对DZ数据库的添加的内容加到1楼删除的具体过程里,否则会出错,

Discuz! info: MySQL Query Error

Time: 2006-7-18 7:56pm
Script: /admincp.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='EGSoAN' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='60.178.128.127' AND m.uid='1'
AND m.password='debad1eb27354674418b128b013c3bcd' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'


我时菜鸟,我也是搞了好久才搞好的,呵呵,只要按3楼做就可以!!!

虽说删除你们的supesite/space你们肯定有点不舍,但对于用户,希望可以谅解,比较,用户的选择才是发展的动力,如果用户改投其他阵营,是你们不想看到的

互联网的精神:开放/自由/互助

感谢你们的辛勤劳动!!!

[ 本帖最后由 liushiwei315 于 2006-7-26 23:22 编辑 ]

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

不完整  不能更新缓存

凡按照这个操作出现错误的都是没有认真按照这个帖子 操作的用户
请仔细看红字部分！

看了收藏

升级错误，MySQL 提示: 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 '; DELETE FROM `cdb_settings` WHERE `variable` = 'supe_tablepre'

Discuz! info: MySQL Query Error

Time: 2006-8-14 5:46pm
Script: /xyshi/admincp.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, m.editormode, m.customshow
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='0fbf6J' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='219.144.109.6' AND m.uid='1'
AND m.password='f3e4175f05c6a20b406fbd26efd6ff13' AND m.secques=''
Error: Unknown column 'm.xspacestatus' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

顶一下

原帖由 茄子 于 2006-4-3 16:03 发表

3，将您X-Space程序文件删除即可

x-space程序文件在哪个文件夹里面，sytle/space/?