［已经解决］RMB有偿请人修复数据库

suyuan269 · 发表于 2006-9-12 10:55:23

数据库出现问题，又没有备份文件。所以在这有偿寻求谁能帮我修复数据库。奖金是200元。
Discuz! info: MySQL Query Error

Time: 2006-9-12 2:52am
Script: /bbs/index.php

SQL: SELECT sid, uid AS sessionuid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode
FROM cdb_sessions WHERE sid='B0ezgM' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='218.71.48.73'
Error: Table 'sq_suyuan.cdb_sessions' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

[ 本帖最后由 suyuan269 于 2006-9-13 13:17 编辑 ]

Arice · 发表于 2006-9-12 12:50:37

执行

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 smallint(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;

复制代码

suyuan269 · 发表于 2006-9-13 01:05:32

现在变成
Discuz! info: MySQL Query Error

Time: 2006-9-12 5:05pm
Script: /bbs/index.php

SQL: SELECT type FROM cdb_usergroups WHERE groupid='7'
Error: Table 'sq_suyuan.cdb_usergroups' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.
接下来要怎么操作？

suyuan269 · 发表于 2006-9-13 01:21:43

汗，现在打开是这个了。怎么随时变的啊
Discuz! info: MySQL Query Error

Time: 2006-9-13 1:21am
Script: /bbs/index.php

SQL: UPDATE cdb_forums SET todayposts='0'
Error: Table 'sq_suyuan.cdb_forums' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

suyuan269 · 发表于 2006-9-13 06:54:22

表检查信息
Table                      Op    Msg_type  Msg_text
---------------------------  ------  --------  -----------------------------------------------
sq_suyuan.yn_words          check status OK
sq_suyuan.yn_validating    check status OK
sq_suyuan.yn_usergroups    check status OK
sq_suyuan.yn_threadtypes    check status OK
sq_suyuan.yn_threadsmod    check status OK
sq_suyuan.yn_threads       check status OK
sq_suyuan.yn_templates    check status OK
sq_suyuan.yn_subscriptions check status OK
sq_suyuan.yn_stylevars    check status OK
sq_suyuan.yn_styles       check status OK
sq_suyuan.yn_statvars       check status OK
sq_suyuan.yn_stats          check status OK
sq_suyuan.yn_smilies       check status OK
sq_suyuan.yn_settings       check status OK
sq_suyuan.yn_sessions       check error    The handler for the table doesn't support check
sq_suyuan.yn_searchindex    check status OK
sq_suyuan.yn_rsscaches    check status OK
sq_suyuan.yn_relatedthreads  check status OK
sq_suyuan.yn_regips       check status OK
sq_suyuan.yn_ratelog       check status OK
sq_suyuan.yn_ranks          check status OK
sq_suyuan.yn_race          check status OK
sq_suyuan.yn_qiuhun       check status OK
sq_suyuan.yn_promotions    check status OK
sq_suyuan.yn_profilefields check status OK
sq_suyuan.yn_posts          check status OK
sq_suyuan.yn_polls          check status OK
sq_suyuan.yn_pmsearchindex check status OK
sq_suyuan.yn_pms          check status OK
sq_suyuan.yn_pluginvars    check status OK
sq_suyuan.yn_plugins       check status OK
sq_suyuan.yn_pluginhooks    check status OK
sq_suyuan.yn_paymentlog    check status OK
sq_suyuan.yn_p_diceblague check status OK
sq_suyuan.yn_p_boxguess    check status OK
sq_suyuan.yn_orders       check status OK
sq_suyuan.yn_onlinetime    check status OK
sq_suyuan.yn_onlinelist    check status OK
sq_suyuan.yn_modworks       check status OK
sq_suyuan.yn_moderators    check status OK
sq_suyuan.yn_members       check status OK
sq_suyuan.yn_memberfields check status OK
sq_suyuan.yn_medals       check status OK
sq_suyuan.yn_links          check status OK
sq_suyuan.yn_lihun          check status OK
sq_suyuan.yn_jie          check status OK
sq_suyuan.yn_jhzhufu       check status OK
sq_suyuan.yn_gameplanapply check status OK
sq_suyuan.yn_gameplan       check status OK
sq_suyuan.yn_forums       check status OK
sq_suyuan.yn_forumlinks    check status OK
sq_suyuan.yn_forumfields    check status OK
sq_suyuan.yn_favorites    check status OK
sq_suyuan.yn_failedlogins check status OK
sq_suyuan.yn_crons          check status OK
sq_suyuan.yn_creditslog    check status OK
sq_suyuan.yn_cardlog       check status OK
sq_suyuan.yn_card          check status OK
sq_suyuan.yn_buddys       check status OK
sq_suyuan.yn_blogcaches    check status OK
sq_suyuan.yn_bbcodes       check status OK
sq_suyuan.yn_banned       check status OK
sq_suyuan.yn_bankstatus    check status OK
sq_suyuan.yn_banklog       check status OK
sq_suyuan.yn_attachtypes    check status OK
sq_suyuan.yn_attachments    check status OK
sq_suyuan.yn_announcements check status OK
sq_suyuan.yn_advertisements  check status OK
sq_suyuan.yn_adminsessions check status OK
sq_suyuan.yn_adminnotes    check status OK
sq_suyuan.yn_admingroups    check status OK
sq_suyuan.yn_adminactions check status OK
sq_suyuan.yn_access       check status OK
sq_suyuan.cdb_sessions    check error    The handler for the table doesn't support check
sq_suyuan.cdb_qiuhun       check status OK
sq_suyuan.cdb_links       check status OK
sq_suyuan.cdb_lihun       check status OK
sq_suyuan.cdb_jie          check status OK
sq_suyuan.cdb_jhzhufu       check status OK
sq_suyuan.cdb_changename    check status OK

Arice · 发表于 2006-9-13 10:07:30

打开config.inc.php

查找 $tablepre = 'cdb_';

修改成: $tablepre = 'yn_';

		自动登录	找回密码
密码			立即注册