插件作者的标准出来了!Manyou诚邀开发者加盟!
“互联网平台开发者”特刊 有奖征集开发者
立即免费下载 Discuz!6.1.0正式版
Discuz! 6.1.0 使用说明
Discuz!NT2.5正式版发布
开放源码下载
UCenter Home 1.2 正式版发布
官方站 | 帮助文档
基于ECShop的网店托管-卖否
PHP就业培训直通车 | LAMP培训大连
Discuz!收费服务内容及价格
“感谢有你同行”手握手2008年数万元重奖志愿者
Discuz!/ECShop 专用官方虚拟主机
亿声传媒(Insenz)中秋祝福发送中
Comsenz 招聘信息
网店系统ECShop v2.6.0正式版火热发布
基于Discuz!的免费论坛空间5D6D
参与有奖社区调查 赢取台湾5日游
发新话题
打印

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

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

附件

Bigfish61.jpg (182.65 KB)

2007-1-31 01:44

Bigfish61.jpg

引用:
原帖由 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.



按前面说的后台升级了,但是问题依然有.
谢谢了.
紧急求救各位大哥了,这个问题是什么原因?怎么解决啊?

附件

1.jpg (23.15 KB)

2007-3-3 16:06

1.jpg

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


哪位高手能帮忙.

问题出在我改了这个后 :http://www.discuz.net/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 编辑 ]
发新话题
版块跳转