升级Discuz! 5后论坛后台检测不到SupeSite的用户进（更新11/30）

:) :) :)

之前我问的问题找到解决办法了。
升级
CREATE TABLE userspaces (
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  catid smallint(6) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  spacename char(50) NOT NULL default '',
  viewnum int(10) unsigned NOT NULL default '0',
  spaceallnum mediumint(8) unsigned NOT NULL default '0',
  spaceblognum mediumint(8) unsigned NOT NULL default '0',
  spaceimagenum mediumint(8) unsigned NOT NULL default '0',
  spacefilenum mediumint(8) unsigned NOT NULL default '0',
  spacegoodsnum mediumint(8) unsigned NOT NULL default '0',
  spacelinknum mediumint(8) unsigned NOT NULL default '0',
  province char(15) NOT NULL default '',
  city char(25) NOT NULL default '',
  domain char(20) NOT NULL default '',
  islock tinyint(1) NOT NULL default '0',
  isstar tinyint(1) NOT NULL default '0',
  photo char(3) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY islock (islock,lastpost),
  KEY catid (catid,islock,lastpost)
) TYPE=MyISAM;
就可以了。望后来者看见

我放在ＳＳ目录下修复了，也更新了缓存，论坛找到了ＳＳ，但是还是收录不了新的帖子

xiexie a

检测到了，倒是继续 更新缓存时发生如下事故！！

Discuz! info: MySQL Query Error

User: admin
Time: 2006-12-6 12:02pm
Script: /forum/admincp.php

SQL: SELECT uid, username FROM userspaces WHERE islock=0 ORDER BY lastpost DESC LIMIT 100
Error: Table 'bt_msnpub_com.userspaces' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

我的问题和楼上的一样。Discuz! info: MySQL Query Error

User: tiggor
Time: 2006-12-10 12:06am
Script: /bbs/admincp.php

SQL: SELECT uid, username FROM userspaces WHERE islock=0 ORDER BY lastpost DESC LIMIT 10
Error: Table 'sq_sq_tztiggor.userspaces' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

重复了几次都不行啊。

[ 本帖最后由 tiggor 于 2006-12-10 00:14 编辑 ]

我用72楼的朋友的方法，升级数据库。然后再进行修复。问题解决了。

同样的问题 升级了 然后去论坛更新缓存 出现
我是PHPW5转dz5然后装了最新SS
Discuz! info: MySQL Query Error

User: admin
Time: 2006-12-13 1:02pm
Script: /bbs/admincp.php

SQL: SELECT uid, username FROM userspaces WHERE islock=0 ORDER BY lastpost DESC LIMIT 100
Error: Table 'dzbb.userspaces' doesn't exist
数据表缺失,请恢复备份数据


然后用了 72楼的方法升级数据库OK了

CREATE TABLE userspaces (
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  catid smallint(6) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  spacename char(50) NOT NULL default '',
  viewnum int(10) unsigned NOT NULL default '0',
  spaceallnum mediumint(8) unsigned NOT NULL default '0',
  spaceblognum mediumint(8) unsigned NOT NULL default '0',
  spaceimagenum mediumint(8) unsigned NOT NULL default '0',
  spacefilenum mediumint(8) unsigned NOT NULL default '0',
  spacegoodsnum mediumint(8) unsigned NOT NULL default '0',
  spacelinknum mediumint(8) unsigned NOT NULL default '0',
  province char(15) NOT NULL default '',
  city char(25) NOT NULL default '',
  domain char(20) NOT NULL default '',
  islock tinyint(1) NOT NULL default '0',
  isstar tinyint(1) NOT NULL default '0',
  photo char(3) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY islock (islock,lastpost),
  KEY catid (catid,islock,lastpost)
) TYPE=MyISAM;

[ 本帖最后由 zadai 于 2006-12-13 13:24 编辑 ]

我的能看到，只是不能同时登陆