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

原帖由 liaoch20 于 2005-10-7 12:03 发表
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
服务器端口不对，请咨询空间商正确的端口
请问这个是怎么一回事啊

我也出现这个提示，请问服务器正确的端口应该是多少？我有服务器权限，如何查看MYSQL现在的端口？如何更改DISCUZ配置来解决这个问题？
着急啊。。。多谢！

SQL: REPLACE INTO cdb_statvars (type, variable, value)
VALUES ('main', 'bestmem', '<a href="viewpro.php?username=%27.%A6%B1ucca.%21"><span class="bold">'.Ρucca.!</span></a>')
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 '.Ρucca.!')' at line 2
Errno.: 1064

Similar error report has beed dispatched to administrator before.

导入备份好的数据库报错,真是晕啊,详情如下:

错误信息如下:


Discuz! info: MySQL Query Error

Time: 2005-10-23 11:46am
Script: /bbs/restore.php

SQL: CREATE TABLE cdb_sessions ( sid char(6) character set latin1 collate latin1_bin NOT NULL default '', ip1 tinyint(3) unsigned NOT NULL default '0', ip2 tinyint(3) unsigned NOT NULL default '0', ip3 tinyint(3) unsigned NOT NULL default '0', ip4 tinyint(3) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', groupid smallint(6) unsigned NOT NULL default '0', styleid smallint(6) unsigned NOT NULL default '0', invisible tinyint(1) NOT NULL default '0', `action` tinyint(1) unsigned NOT NULL default '0', lastactivity int(10) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', KEY sid (sid)) TYPE=HEAP MAX_ROWS=50000
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 'collate latin1_bin NOT NULL default '', ip1 tinyint(3) unsigne
Errno.: 1064

An error report has been dispatched to our administrator.

我一共备份了30卷,导入最后一卷报错,555555555

lp622_com.cdb_sessions
check
error
The handler for the table doesn't support check

看过，顶过。不能放过。

1062和1064错误：

                ALTER TABLE cdb_usergroups CHANGE attachextensions attachextensions CHAR( 255 ) NOT NULL;
                ALTER TABLE cdb_members CHANGE timeoffset timeoffset CHAR( 4 ) NOT NULL;
                ALTER TABLE cdb_forums CHANGE name name CHAR( 255 ) NOT NULL;
                ALTER TABLE cdb_attachtypes CHANGE extension extension CHAR( 10 ) NOT NULL;
                INSERT INTO cdb_settings VALUES ('delayreply', 0);
                INSERT INTO cdb_settings VALUES ('announcements_num', 1);
大家先把服务器跟目录的config文件打开，如下数据：
                $dbhost = 'cctv01';
                $dbuser = 'abcdef_f';
                $dbpw = 'ccccc';
                $dbname = 'ssiloveyou';
                $adminemail = '100541010@qq.com';
                $dbreport = 0;
那么你的升级码就是：
                ALTER TABLE cdb_members CHANGE timeoffset timeoffset CHAR( 4 ) NOT NULL;
                ALTER TABLE cdb_forums CHANGE name name CHAR( 255 ) NOT NULL;
                ALTER TABLE cdb_attachtypes CHANGE extension extension CHAR( 10 ) NOT NULL;
                INSERT INTO cdb_settings VALUES ('cctv01', 0);
                INSERT INTO cdb_settings VALUES ('abcdef_f', 1);
欢迎大家来街足联盟！

[ 本帖最后由 黑羽の庆 于 2005-11-22 23:05 编辑 ]

如何解决这个问题,我看了一下,前面也有几位朋友有类似问题,好像都没有解决,哪位朋友帮忙看看.

Discuz! info: Can not connect to MySQL server

Time: 2005-11-12 3:55pm
Script: /php/install.php?language=chinese_gb2312

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

Similar error report has beed dispatched to administrator before.

如何解决这个问题

Discuz! info: Can not connect to MySQL server

Time: 2005-11-19 9:40pm
Script: /install.php?language=chinese_gb2312

Error: Access denied for user: 'connsynn.6te.net @localhost' (Using password: YES)
数据库帐户密码不对，请联系空间商

An error report has been dispatched to our administrator


确保不是空间及密码问题

Discuz! info: Can not connect to MySQL server

Time: 2005-11-22 11:37am
Script: /upload/install.php?language=chinese_big5

Error: Lost connection to MySQL server during query
Errno.: 2013

An error report has been dispatched to our administrator.

這是什麼問題...

我弄了三次都一樣....