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

我也第一次，搞不好啊，高手指点哈

原帖由 web-cy44 于 2005-5-20 23:46 发表
我的只要一有20个人左右就出现下面的这个，空间商说他赶担保不是他的问题~
我也搜索了一下，好像出现这个问题的人不少~
有时人在后台设置时就很爱出现，

Discuz! info: Can not connect to MySQL server
...

我昨天也遇到,是同一服务器的一个客户MySQL server的问题

Discuz! info: MySQL Query Error

User: calmh
Time: 2007-2-11 10:29am
Script: /bbs/index.php

SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM cdb_sessions ORDER BY uid DESC
Error: Record has changed since last read in table 'cdb_sessions'
Errno.: 1020

Similar error report has beed dispatched to administrator before.



按前面说的后台升级了,但是问题依然有.
谢谢了.

紧急求救各位大哥了，这个问题是什么原因？怎么解决啊？

Discuz! info: Can not connect to MySQL server

Time: 2007-3-10 2:38am
Script:

Error: Unknown MySQL server host 'sql1.xlphp.net ' (1)
Errno.: 2005


这是什么问题

Discuz! info: MySQL Query Error

User: admin
Time: 2007-3-10 6:51pm
Script: /bbs/admincp.php

SQL: CREATE TABLE `cdb_access` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', `allowpostattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=gbk' at line 1
Errno.: 1064

请问童虎大大 如何解决这一问题

Discuz! info: MySQL Query Error

User: 催化
Time: 2007-3-13 11:44pm
Script: /ps/post.php

SQL: SELECT m.adminid, p.first, p.authorid, p.author, p.dateline, u.allowhtml, p.anonymous, p.invisible FROM [Table]posts p
LEFT JOIN [Table]members m ON m.uid=p.authorid
LEFT JOIN [Table]usergroups u USING(groupid)
WHERE pid='8651' AND tid='1572' AND fid='2'
Error: Lost connection to MySQL server during query
Errno.: 2013

Similar error report has beed dispatched to administrator before.


5.5的

后台错误:
Fatal error: Call to undefined function: writelog() in /home/roctian/public_html/bbs/admincp.php on line 95

不能打开帖子:
Fatal error: Call to undefined function: supe_dbconnect() in /home/roctian/public_html/bbs/viewthread.php on line 17


哪位高手能帮忙.

问题出在我改了这个后 :https://discuz.dismall.com/thread-389680-1-5.html

哪位帮忙啊!!!

可以加我QQ48628810

[ 本帖最后由 深の灰 于 2007-3-15 22:26 编辑 ]

Discuz! info: MySQL Query Error

Time: 2007-3-19 9:38am
Script: /bbs/index.php

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

An error report has been dispatched to our administrator.

SQL: CREATE DATABASE IF NOT EXISTS DEFAULT CHARACTER SET gbk
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET gbk' at line 1
Errno.: 1064

[ 本帖最后由 350514 于 2007-3-22 22:53 编辑 ]