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

Discuz! info: Can not connect to MySQL server

Time: 2007-3-10 2:04pm
Script: /install.php

Error: Unknown MySQL Server Host 'sq_huochaitiantang' (11004)
Errno.: 2005

Similar error report has beed dispatched to administrator before.
怎么办啊！~~~~ 求救！

Discuz! info: MySQL Query Error

User:
Time: 2007-3-25 11:55am
Script: /bbs/Index.php

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

Similar error report has beed dispatched to administrator before.

恢复论坛数据库后报这个错误~~整个论坛全部阵亡.......

好复杂啊      看来真的要多花些时间了

Discuz! info: MySQL Query Error

User: openge
Time: 2007-4-1 10:30pm
Script: /viewthread.php

SQL: SELECT s.*, a.tid, a. subject, a.fid, a.author, a.dateline, a.replies, a.views, a.lastpost, f.fid, f.name
FROM cdb_similarthreads s LEFT JOIN cdb_threads a ON s.aimtid=a.tid LEFT JOIN cdb_forums f ON a.fid=f.fid
WHERE s.oritid='2828' ORDER BY rand() LIMIT 0, 5
Error: Can't open file: 'cdb_similarthreads.ibd' (errno: 1)
文件无法打开，请修复数据表

Similar error report has beed dispatched to administrator before.

Discuz! info: Can not connect to MySQL server

Time: 2007-4-6 7:51pm
Script: /frame.php

Error: Can't connect to MySQL server on 'localhost' (10057)
MySQL服务没有启动，请启动该服务

Similar error report has beed dispatched to administrator before.

我现在的服务器配置是2003系统, PHP:php-5.1.2-Win32.zip   mysql-5.0.37-win32.zip    phpMyAdmin-2.10.0-beta1-all-languages  
现在的问题是经常出现上面的错误，一般十几分钟或者不定。Script: /frame.php 这里会跟你你浏览的页面不同而改动。 我后来研究了很多次发现不是MYSQL没启动的原因，MY一直是启动着的。很多次出现这种问题后我远程登录服务器后打开IIS动一下就又OK了，什么都不用改动什么。真是郁闷死我了 现在不知道问题出在哪，请帮助解决。是 MY工作不稳定的原因还是兼容性问题它们！

Discuz! info: Can not connect to MySQL server

Time: 2007-4-7 10:28am
Script: /bbs/index.php

Error: Access denied for user: 'sq_cnaicql@f-kv3fb7o4kjlmf' (Using password: YES)
数据库帐户密码不对，请联系空间商

Similar error report has beed dispatched to administrator before.


诸位，这是什么意思啊

无法连接数据库，请检查数据库用户名或者密码是否正确

我的数据库是MYSQL的 请问是怎么回事？

帐号密码直接 在FTP config.inc.php 设置的 也没错啊

就是说无法连接数据库

[ 本帖最后由 小狼猫吖 于 2007-4-21 12:08 编辑 ]

论坛突然注册不了，一注册就变成下面那样的，到底是怎么回事，望童虎老大帮我解决下好吗？拜托了！！



Discuz! info: MySQL Query Error

Time: 2007-4-24 11:13pm
Script: /bbs/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 ('zzz', 'f3abb86bd34cf4d52698f14c0da1dc60', '', '0', '0', '10', '124.147.137.192', '1177427603', '1177427603', '1177427603', '0', Array, 'zzz@163.com', '0000-00-00', '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.

Discuz! info: Can not connect to MySQL server

Time: 2007-5-14 10:16pm
Script: /logging.php

Error: Can't connect to MySQL server on '60.172.163.102' (10065)
MySQL服务没有启动，请启动该服务

Similar error report has beed dispatched to administrator before.