Discuz!官方免费开源建站系统

 找回密码
 立即注册
搜索

[疑问] cdb_sessions 数据表缺失,该如何重建?请求各位高手赐教!!

[复制链接]
hr169 发表于 2007-8-28 23:18:59 | 显示全部楼层 |阅读模式
cdb_sessions  数据表缺失,该如何重建

里面有18个字段,难道都要重建吗?论坛更换空间,用phpmyadmin导入到新数据库,就出现了这样的错误

Discuz! info: MySQL Query Error

Time: 2007-8-28 7:22pm
Script: /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, m.editormode, m.customshow
FROM [Table]sessions s, [Table]members m
WHERE m.uid=s.uid AND s.sid='1R4JuN' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='59.46.65.238' AND m.uid='1'
AND m.password='d9f6e636e369552839e7bb8057aeb8da' AND m.secques=''
Error: Table 'a8144098_qzwqlm.[Table]sessions' doesn't exist
数据表缺失,请恢复备份数据
回复

使用道具 举报

白乐天 发表于 2007-8-28 23:24:51 | 显示全部楼层
DROP TABLE IF EXISTS cdb_sessions;
CREATE TABLE cdb_sessions (
  sid char(6) binary NOT NULL DEFAULT '',
  ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  username char(15) NOT NULL DEFAULT '',
  groupid smallint(6) unsigned NOT NULL DEFAULT '0',
  styleid smallint(6) unsigned NOT NULL DEFAULT '0',
  invisible tinyint(1) NOT NULL DEFAULT '0',
  `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
  lastactivity int(10) unsigned NOT NULL DEFAULT '0',
  lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
  pageviews smallint(6) unsigned NOT NULL DEFAULT '0',
  seccode mediumint(6) unsigned NOT NULL DEFAULT '0',
  fid smallint(6) unsigned NOT NULL DEFAULT '0',
  tid mediumint(8) unsigned NOT NULL DEFAULT '0',
  bloguid mediumint(8) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY sid (sid),
  KEY uid (uid),
  KEY bloguid (bloguid)
) TYPE=HEAP;
回复

使用道具 举报

桃子(小敏) 发表于 2007-8-29 13:44:40 | 显示全部楼层
用tools先修复下数据表,可能是数据表损坏
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2025-9-13 10:04 , Processed in 0.108431 second(s), 14 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表