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

因为换了新空间.今天从旧论坛导入数据的时候一直出现个别分卷导入不成功.比如我导入36分卷的时候会出现这样的情况

Discuz! info: MySQL Query Error

User: 非鱼
Time: 2008-2-13 9:10pm
Script: /admincp.php

SQL: INSERT INTO [Table]posts VALUES

这里中间有好大一段数字.乱码.复制不过来,一复制就死浏览器- -

Error: MySQL server has gone away
Errno.: 2006

Similar error report has beed dispatched to administrator before.

请问下如何处理....

急急急啊。。。。。。。

#1364 - Field 'bio' doesn't have a default value

Discuz! info: Can not connect to MySQL server

Time: 2008-3-7 10:38pm
Script: /index.php

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

Similar error report has beed dispatched to administrator before.

SupeSite info: MySQL Query Error

User: Guest
Time: 2008-3-8 2:47pm
Script: /index.php

SQL: SELECT t.tid, t.author, t.readperm, t.subject, t.fid, t.views, t.replies, t.dateline, t.lastpost, p.message FROM `lanegao`.`[Table]mythreads` m, `lanegao`.`[Table]threads` t, `lanegao`.`[Table]posts` p WHERE m.uid='2' AND m.tid=t.tid AND t.displayorder>=0 AND t.author!='' AND p.tid=t.tid AND p.first=1 ORDER BY t.tid DESC LIMIT 0,10
Error: Can't create/write to file '#sql_77c_0.MYD' (Errcode: 17)
Errno.: 1


我的是管理员账号。在打开个人空间的时候显示这个。其他会员还游管理员账号的空间都可以正常打开、。。

怎麼改頭上的banner
點改..........
helphelp

我原本用的是Discuz5.0 UTF-8 TC, 昨天進行升級, 先把齊個論壇拷貝了一個, 用拷貝那個做升級。

先由5.0 升至5.5, 升級過程順利, 但升級完成後, 所有中文字(除預設外)全都變成亂碼

我查看過數據庫, 肯定設定無錯。我也曾問我的空間商查看, 他們也說兩個 MySQL(一個是原有的5.0, 另一個是新升級的5.5)的設定都是一樣, 問題該出自論壇的語法, 但我對這個不懂。

我想反正問題不是出自數據庫, 所以我沒理會那些亂碼, 再由5.5 升至6.0, 但仍是出現亂碼。(看附件)

請問各位大大, 到底我是那裏出錯? 有什么方法可以修正?

[ 本帖最后由 MHL 于 2008-3-10 09:52 编辑 ]

Discuz! info: MySQL Query Error

User: 浪子
Time: 2008-2-12 11:10pm
Script: /admincp.php

SQL: SHOW TABLE STATUS FROM 00103002001 LIKE 'supe_%'
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 '00103002001 LIKE 'supe_%'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: justy2003
Time: 2008-5-11 10:21am
Script: /forum/index.php

SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM [Table]sessions WHERE uid <> 0 ORDER BY uid DESC LIMIT 500
Error: Record has changed since last read in table '[Table]sessions'
Errno.: 1020

Similar error report has beed dispatched to administrator before.

do not know how to fix it

我论坛注册时提示以下信息,根据提示我把提示的UID删除后,系统就会继续提示下一个UID,请问怎么解决,一定要删除提示的UID吗？有没有其它办法？
Discuz! info: MySQL Query Error

Time: 2008-6-6 11:50am
Script: /general/bbs2/register.php

SQL: INSERT INTO [Table]members (uid, 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 ('7', 'wxj', 'a0d4c956b6eadaff8ffb212148c90c96', '', '0', '0', '10', '116.17.123.117', '1212724242', '1212724242', '1212724242', '0', 0,0,0,0,0,0,0,0,0, 'zk@wanxinjia.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '7' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.