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

 找回密码
 立即注册
搜索

[疑问] 今天想恢复之前论坛的数据MySQL Query Error

[复制链接]
terry3 发表于 2008-1-7 20:44:04 | 显示全部楼层 |阅读模式
大家帮我看看 今天想恢复之前论坛的数据
重开论坛.
www.ls37.cn/old/mobgra

显示:

Discuz! info: MySQL Query Error

Time: 2008-1-7 8:13pm
Script: /old/MobGra/index.php

SQL: UPDATE [Table]stats SET count=count+1 WHERE (type='total' AND variable='hits') OR (type='browser' AND variable='MSIE') OR (type='os' AND variable='Windows') OR (type='total' AND variable='guests') OR (type='month' AND variable='200801') OR (type='week' AND variable='1') OR (type='hour' AND variable='20')
Error: Table 'terry_terry.[Table]stats' doesn't exist
数据表缺失,请恢复备份数据

现在我找不到数据表/可能已经被删了
回复

使用道具 举报

 楼主| terry3 发表于 2008-1-7 20:45:42 | 显示全部楼层
另外 怎么知道我的论坛用的是哪个数据表?
回复

使用道具 举报

白乐天 发表于 2008-1-7 20:54:46 | 显示全部楼层

在phpmyadmin或者数据库升级里执行这个

DROP TABLE IF EXISTS cdb_stats;
CREATE TABLE cdb_stats (
  `type` char(10) NOT NULL DEFAULT '',
  variable char(10) NOT NULL DEFAULT '',
  count int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`type`,variable)
) TYPE=MyISAM;

INSERT INTO cdb_stats VALUES ('total','hits','1');
INSERT INTO cdb_stats VALUES ('total','members','0');
INSERT INTO cdb_stats VALUES ('total','guests','1');
INSERT INTO cdb_stats VALUES ('os','Windows','1');
INSERT INTO cdb_stats VALUES ('os','Mac','0');
INSERT INTO cdb_stats VALUES ('os','Linux','0');
INSERT INTO cdb_stats VALUES ('os','FreeBSD','0');
INSERT INTO cdb_stats VALUES ('os','SunOS','0');
INSERT INTO cdb_stats VALUES ('os','OS/2','0');
INSERT INTO cdb_stats VALUES ('os','AIX','0');
INSERT INTO cdb_stats VALUES ('os','Spiders','0');
INSERT INTO cdb_stats VALUES ('os','Other','0');
INSERT INTO cdb_stats VALUES ('browser','MSIE','1');
INSERT INTO cdb_stats VALUES ('browser','Netscape','0');
INSERT INTO cdb_stats VALUES ('browser','Mozilla','0');
INSERT INTO cdb_stats VALUES ('browser','Lynx','0');
INSERT INTO cdb_stats VALUES ('browser','Opera','0');
INSERT INTO cdb_stats VALUES ('browser','Konqueror','0');
INSERT INTO cdb_stats VALUES ('browser','Other','0');
INSERT INTO cdb_stats VALUES ('week','0','0');
INSERT INTO cdb_stats VALUES ('week','1','1');
INSERT INTO cdb_stats VALUES ('week','2','0');
INSERT INTO cdb_stats VALUES ('week','3','0');
INSERT INTO cdb_stats VALUES ('week','4','0');
INSERT INTO cdb_stats VALUES ('week','5','0');
INSERT INTO cdb_stats VALUES ('week','6','0');
INSERT INTO cdb_stats VALUES ('hour','00','0');
INSERT INTO cdb_stats VALUES ('hour','01','0');
INSERT INTO cdb_stats VALUES ('hour','02','0');
INSERT INTO cdb_stats VALUES ('hour','03','0');
INSERT INTO cdb_stats VALUES ('hour','04','0');
INSERT INTO cdb_stats VALUES ('hour','05','0');
INSERT INTO cdb_stats VALUES ('hour','06','0');
INSERT INTO cdb_stats VALUES ('hour','07','0');
INSERT INTO cdb_stats VALUES ('hour','08','0');
INSERT INTO cdb_stats VALUES ('hour','09','0');
INSERT INTO cdb_stats VALUES ('hour','10','1');
INSERT INTO cdb_stats VALUES ('hour','11','0');
INSERT INTO cdb_stats VALUES ('hour','12','0');
INSERT INTO cdb_stats VALUES ('hour','13','0');
INSERT INTO cdb_stats VALUES ('hour','14','0');
INSERT INTO cdb_stats VALUES ('hour','15','0');
INSERT INTO cdb_stats VALUES ('hour','16','0');
INSERT INTO cdb_stats VALUES ('hour','17','0');
INSERT INTO cdb_stats VALUES ('hour','18','0');
INSERT INTO cdb_stats VALUES ('hour','19','0');
INSERT INTO cdb_stats VALUES ('hour','20','0');
INSERT INTO cdb_stats VALUES ('hour','21','0');
INSERT INTO cdb_stats VALUES ('hour','22','0');
INSERT INTO cdb_stats VALUES ('hour','23','0');
回复

使用道具 举报

 楼主| terry3 发表于 2008-1-7 21:27:41 | 显示全部楼层
谢谢你的解答

但是 phpmyadmin 里没有升级噢
回复

使用道具 举报

kook12368 发表于 2008-1-7 21:32:30 | 显示全部楼层
点SQL,,按纽
回复

使用道具 举报

 楼主| terry3 发表于 2008-1-7 21:47:19 | 显示全部楼层
噢  谢谢
我已经成功运行了
但是还是显示:

Discuz! info: MySQL Query Error

Time: 2008-1-7 9:48pm
Script: /old/MobGra/index.php

SQL: UPDATE [Table]stats SET count=count+1 WHERE (type='total' AND variable='hits') OR (type='browser' AND variable='MSIE') OR (type='os' AND variable='Windows') OR (type='total' AND variable='guests') OR (type='month' AND variable='200801') OR (type='week' AND variable='1') OR (type='hour' AND variable='21')
Error: Table 'terry_terry.[Table]stats' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.
回复

使用道具 举报

桃子(小敏) 发表于 2008-1-8 09:07:07 | 显示全部楼层
使用tools修复下数据库:
https://discuz.dismall.com/thread-761181-1-1.html
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-9-14 05:02 , Processed in 0.100660 second(s), 14 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

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