数据库常见错误信息和解决方法集中讨论贴

Discuz! info: MySQL Query Error

Time: 2007-10-27 10:10am
Script: /register.php

SQL: INSERT INTO [Table]members (username, password, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset)
VALUES ('aitro', 'fa8dcd3a177ce510d2e4e98497b53cf5', '', '0', '0', '10', '123.115.143.64', '1193451047', '1193451047', '1193451047', '0', Array, 'cctv6768@sina.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Column count doesn't match value count at row 1
Errno.: 1136

Similar error report has beed dispatched to administrator before.

Can not write to cache files, please check directory ./forumdata/ and ./forumdata/cache/ .

我换了一个服务器，上传论坛，在MYSQL里面导入原来的数据库出现这样的提示，请问是什么意思呢！

我的论坛广告全部不显示了，重新做也没用，还有帖置顶，高亮，等 整个管理选项都没用了？这是为什么啊？那个老大帮我看看？可以加我QQ19342750

Cannot find table mtvktv/cdb_clubcaichang from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/ ... roubleshooting.html
how you can resolve the problem.


Cannot find table mtvktv/cdb_clubsellmian from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you




现在连空间的页面都访问不了。请问怎么样解决。

可以幫幫我嗎....
到處問都得不到解答~"~
照著安裝教程做
到安裝dz的畫面後
停在正在安裝就沒動作了

版本:
dz-big-5
當前服務器
操作系統 FreeBSD
PHP 版本 4.4.7
MySQL 客戶端版本: 4.1.22

以下是錯誤訊息:

Discuz! info: MySQL Query Error

Time: 2007-11-3 2:48am
Script: /install.php

SQL: INSERT INTO [Table]faqs VALUES ('27','7','4','','','我如何使用RSS訂閱\','在論壇的

首頁和進入版塊的頁面的右上角就會出現一個rss訂閱\的小圖標<img

src="images/common/xml.gif" border="0">，鼠標點擊之後將出現本站點的rss地址，你可以將此

rss地址放入到你的rss閱\讀器中進行訂閱\。')
Error: You have an error in your SQL syntax near '在論壇的首頁和進入版塊的頁面的右上角

就會出現一個rss訂閱\的小圖標<img src="images' at line 1
Errno.: 1064

[Table]! info: MySQL Query Error

User: 克莱思
Time: 2007-11-6 9:13am
Script: /forum/admincp.php

SQL: ALTER TABLE [Table]sessions MAX_ROWS=5000
Error: ALTER command denied to user 'tooth'@'localhost' for table 'discuzsessions'
Errno.: 1142

Similar error report has beed dispatched to administrator before.

请问如何解决，万分感激！

原帖由 Cnlecher 于 2007-11-6 10:04 发表
! info: MySQL Query Error

User: 克莱思
Time: 2007-11-6 9:13am
Script: /forum/admincp.php

SQL: ALTER TABLE sessions MAX_ROWS=5000
Error: ALTER command denied to user 'tooth'@'localhost' for ta ...

没人帮忙看下吗?

如果大家还有问题，请集中到这个帖子讨论，不要再开新帖子了，谢谢合作

另外想请教　　论坛查看帖子　　出现白屏
是不是因为插件的原因出现此现象
事情原因是因为viewthread.php文件丢失
然后上传此文件
但帖子出现白屏了
帖子地址可参考 http://www.2500wt.com/bbs/viewth ... &extra=page%3D1

到现在一直没解决
头很大


求解
谢谢

资料恢复时  SS 的表前缀修改为 supe_     会改成以前的  (户名).supe_
然后出现

Discuz! info: MySQL Query Error

User: admin
Time: 2007-11-7 8:31pm
Script: /bbs/admincp.php

SQL: DROP TABLE IF EXISTS chenrong673.supe_ads
Error: DROP command denied to user 'chenrong67'@'localhost' for table 'supe_ads'
Errno.: 1142

怎么解决