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

Script: /itpubs/post.php

SQL: INSERT INTO cdb_posts (fid, tid, aid, author, authorid, subject, dateline, message, useip, usesig, bbcodeoff, smileyoff, parseurloff, parseimgoff)
VALUES ('5', '11', '', 'wr820728', '1', '版主申请', '1117118472', '版主申请。', '221.198.173.114', '1', '1', '1', '1', '1')
Error: Unknown column 'parseimgoff' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.
这是什么问题？

什么正确的文件？在哪有，怎么弄？

Discuz! info: Can not connect to MySQL server

Time: 2005-5-26 9:20pm
Script: /bbs/index.php

Error: Can't connect to MySQL server on 'localhost' (10061)

Similar error report has beed dispatched to administrator before.


求助童虎大哥了，我的论坛的这个空间商也搞了，他把和我在一起的大用户也移走了，数据库优化过了，还是出现这个问题。
但我主要发现一点，就是进后台打开[展开]那个按键就爱出现，好像很多次都出现在那里。请帮助一下，谢了

我问过电脑服黑客营版块的班主，他说是程序问题，不关空间商的事。

Originally posted by web-cy44 at 2005-5-27 09:40
Discuz! info: Can not connect to MySQL server

Time: 2005-5-26 9:20pm
Script: /bbs/index.php

Error: Can't connect to MySQL server on 'localhost' (10061)

Similar error report has beed dispa ...

这个提示是连接不上MYSQL数据库啊，绝对是空间的问题啊

还有一点，打开论坛的在线列表有时也要出现，
哎~真没办法，会不会是我的数据库导入过才这样？？
有一次我用后台上面的数据库恢复功能，但很正常呀，

Discuz! info: MySQL Query Error

Time: 2005-5-26 5:58pm
Script: /Discuz!/index.php

SQL: UPDATE cdb_sessions SET status='Guest', lastactivity='1117101480', groupid='1', username='', styleid='5', action='1', fid='', tid='' invisible='0'WHERE sid='qp9X0vXW'
Error: You have an error in your SQL syntax near 'invisible='0'WHERE sid='qp9X0vXW'' at line 1
Errno.: 1064

An error report has been dispatched

Discuz! info: Can not connect to MySQL server

Time: 2005-5-30 11:01am
Script: /forum/index.php

Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
服务器端口不对，请咨询空间商正确的端口

Similar error report has beed dispatched to administrator before.


是不是意味着空间商暂时拔掉我们的连接端口呢...?

Discuz! info: MySQL Query Error

Time: 2006-5-8 11:37am
Script: /index.php

SQL: SELECT * FROM cdb_settings WHERE variable NOT IN ('bbrules', 'bbrulestxt', 'maxonlines', 'welcomemsg', 'welcomemsgtxt', 'newsletter', 'creditsnotify', 'custombackup')
Error: No Database Selected
Errno.: 1046

An error report has been dispatched to our administrator.


什么问题！

刚刚是权限没有设置好！现在又有新的问题！：
Discuz! info: MySQL Query Error

Time: 2006-5-8 12:25pm
Script: /install.php

SQL: CREATE DATABASE 0577vip_com
Error: Access denied for user: '0577vip.com@localhost' to database '0577vip_com'
数据库用户权限不足，请联系空间商解决

An error report has been dispatched to our administrator.

Discuz! info: MySQL Query Error

Time: 2006-5-8 1:28pm
Script: /bbs/index.php

SQL: SELECT * FROM cdb_settings WHERE variable NOT IN ('bbrules', 'bbrulestxt', 'maxonlines', 'welcomemsg', 'welcomemsgtxt', 'newsletter', 'creditsnotify', 'custombackup')
Error: Table 'sq_free0759.cdb_settings' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.