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

我在第240楼提出的问题怎么没人解答呀？？？紧急求救中……

请问下技术人员：

  最近网站速度变得很慢。找空间服务商，说可能是数据库的原因。

请官方的技术帮忙看看吧！

谢谢！

www.negmat.com/bbs

老大求助啊！我在后台一设置板块内容，再去前台打开该板块的网页就无法访问了！！！ :'( :'(
www.wlsnsn.cn
能帮我解决吗！！？？？

在进行论坛版块设置提交后出现下列文字。

Discuz! info: MySQL Query Error

User: admin
Time: 2008-9-30 5:02pm
Script: /bbs/admincp.php

SQL: UPDATE [Table]forums SET status='1', name='广告栏', styleid='0', allowshare='1', alloweditpost='0',
allowpostspecial='1', allowspecialonly='0', allowpaytoauthor='0', allowhtml='0', allowbbcode='1', allowimgcode='1', allowmediacode='0',
allowsmilies='1', alloweditrules='0', modnewposts='0',
recyclebin='1', jammer='0', allowanonymous='0', forumcolumns='0', threadcaches='0',
simple='16', disablewatermark='0', autoclose='0'
WHERE fid='0'
Error: Unknown column 'allowpaytoauthor' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

我两个论坛都中招了- -

Discuz! info: MySQL Query Error

Time: 2008-10-6 8:03pm
Script: /index.php

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

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: AnN
Time: 2008-10-6 8:06pm
Script: /forum/index.php

SQL: SELECT * FROM [Table]xn_song WHERE stime>='1222690001' ORDER BY stime DESC
Error: Table 'happy888.[Table]xn_song' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

希望大大帮我解决看看

Discuz! info: MySQL Query Error

Time: 2008-10-21 10:09am
Script: /bbs/index.php

SQL: SELECT type FROM [Table]usergroups WHERE groupid='7'
Error: No database selected
Errno.: 1046

Similar error report has beed dispatched to administrator before.
这个如何办理
数据库检查正确的

我论坛今天进不去了，提示下面这个，是怎么回事啊？

Forbidden
You don't have permission to access / on this server.


--------------------------------------------------------------------------------

Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8b DAV/2 PHP/5.2.6 Server at as1980.cn Port 80

很不错啊，挺好的帖子啊！！！！！

Discuz! info: MySQL Query Error

Time: 2008-11-25 5:55pm
Script: /register.php

SQL: INSERT INTO [Table]members (uid, 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 ('16', '006', '4f124c6054cab87a66a5e751ea0b3483', '', '0', '0', '10', '218.17.9.155', '1227606901', '1227606901', '1227606901', '0', 0,0,0,0,0,0,0,0,0, 'wujianxin05@sohu.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '16' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案
一注册就这样?怎么办?

我  的问题是    在后台 升级数据库  都是显示 无法显示网页 是怎么 回事 我不输入任何东西 直接点升级 后又正常出现  Discuz! 数据结构成功升级，影响的记录行数 0，请返回。是空间商 问题 还是我的？ 早几天我装 个插件时还升级  成功了的