数据库常见错误信息和解决方法

终于找以原因啦...

SupeSite info: MySQL Query Error

Time: 2007-1-18 3:11pm
Script: /install.php

SQL: UPDATE cdb_settings SET `value`='1' WHERE `variable`='supe_status'
Error: Table 'shawtsai10186_.cdb_settings' doesn't exist
数据表缺失,请恢复备份数据

我安装时出现这样的提示就不动了!高手请我看看是什么问题!

Discuz! info: Can not connect to MySQL server

Time: 2007-4-19 11:56am
Script: /viewthread.php

Error:  Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Errno.:  2002

Johnny from Hawaii

好东西   收藏恶劣:)

Discuz! info: Can not connect to MySQL server

Time: 2007-4-21 7:32am
Script: /zzlm/index.php

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

Similar error report has beed dispatched to administrator before

我用2003的系统

Discuz! info: Can not connect to MySQL server

Time: 2007-4-21 7:32am
Script: /zzlm/index.php

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

Similar error report has beed dispatched to administrator before

我用2003的系统

Discuz! info: Can not connect to MySQL server

Time: 2007-4-21 7:32am
Script: /zzlm/index.php

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

Similar error report has beed dispatched to administrator before

我用2003的系统

Discuz! info: MySQL Query Error

Time: 2007-4-23 9:04pm
Script: /index.php

SQL: SELECT id, subject, redirect, starttime, endtime, message FROM cdb_announcements WHERE starttime<='1177333492' AND (endtime>='1177333492' OR endtime='0') ORDER BY displayorder, starttime DESC, id DESC
Error: Unknown column 'redirect' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

这是什么情况

恭喜您论坛数据升级成功，接下来请您：
必删除本程序
使用管理员身份登录论坛，进入后台，更新缓存
由于 Discuz! 5.5.0 将原 config.inc.php 当中关于附件的设置改为数据库存储，所以如果您的附件目录如果不是默认设置，请进入后台－基本设置－附件设置，进行更改。否则论坛旧贴可能无法找到原有的附件
进行论坛注册、登录、发贴等常规测试，看看运行是否正常
如果您的论坛开启了 URL 静态化功能，您需要阅读《用户使用说明书》当中的高级应用，调整服务器 rewrite 设置， 否则论坛部分页面会出现无法访问的错误。
如果您希望启用 Discuz! 5.5.0 提供的新功能，你还需要对于论坛基本设置、栏目、会员组等等进行重新设置

感谢您选用我们的产品！您现在可以访问论坛，查看升级情况

  
我再登陆我论坛就提示

Discuz! info: MySQL Query Error

Time: 2007-4-23 9:10pm
Script: /index.php

SQL: SELECT id, subject, redirect, starttime, endtime, message FROM cdb_announcements WHERE starttime<='1177333807' AND (endtime>='1177333807' OR endtime='0') ORDER BY displayorder, starttime DESC, id DESC
Error: Unknown column 'redirect' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.