最新 Discuz！论坛常见数据库问题分析及解决方案

我的是MySQL 4.1.12版本


我的是MySQL 4.1.12版本。安装间，在选择database名字时显示以下问题:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/w0001/d18/s24/b028c4a2/www/myforum.com/forum/include/db_mysql.class.php on line 56

然后我再自己输入设在congif.inc里的database名称。再继续安装。结果出现以下问题。

Discuz! info: MySQL Query Error

Time: 2006-9-17 5:05pm
Script: /chinese/forum/install.php

SQL: CREATE DATABASE IF NOT EXISTS
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 '' at line 1
Errno.: 1064

把repair.php上传到根目录下，执行，然后点下面的那个连接修复。

修复后记得删除

Discuz! info: Can not connect to MySQL server

Time: 2006-9-21 12:04pm
Script: /fbsq/install.php

Error: Access denied for user 'a09121026014'@'localhost' (using password: YES)
数据库帐户密码不对，请联系空间商

An error report has been dispatched to our administrator.








Discuz! info: Can not connect to MySQL server

Time: 2006-9-21 12:06pm
Script: /fbsq/install.php

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

An error report has been dispatched to our administrator.

[ 本帖最后由 mykx 于 2006-9-21 20:06 编辑 ]

我晕 数据库帐户密码不对，请联系空间商
这个你问问空间商就知道了啊

我出现了类似于第9个的问题~

Discuz! info: MySQL Query Error

Time: 2006-10-11 4:02pm
Script: /bbs1/index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='59bfFb' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='163.180.194.16' AND m.uid='1'
AND m.password='40062477b4235d3de7778963071ed525' AND m.secques='290234c9'
Error: Unknown column 'm.pmsound' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

可能是我乱弄了数据库升级
请问有没有其他办法解决？？
谢谢楼主大哥啦~

一般数据库升级前最好先备份一份升级前的数据

  把repair.php上传到根目录下，执行修复下 试试

Discuz! info: MySQL Query Error

Time: 2006-10-13 4:34pm
Script: /index.php

SQL: SELECT COUNT(*) FROM cdb_forums WHERE status='1' AND threadcaches>0
Error: Unknown column 'threadcaches' in 'where clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before

斑竹我是菜鸟，上边是什么错误啊？

显示这个呢：
Discuz! info: Can not connect to MySQL server

Time: 2006-10-23 12:35pm
Script:

Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Errno.: 1251

这个问题帮帮忙！

没人可以帮忙吗？

請問
緩存更新時出現

Discuz! info: MySQL Query Error

User: alankao
Time: 2006-10-25 4:04pm
Script: /upload/admincp.php

SQL: SELECT * FROM cdb_
Error: Table 'alankao.cdb_' doesn't exist
数据表缺失,请恢复备份数据

該怎麼辦勒

救命啊