插件作者的标准出来了!Manyou诚邀开发者加盟!
“互联网平台开发者”特刊 有奖征集开发者
立即免费下载 Discuz!6.1.0正式版
Discuz! 6.1.0 使用说明
Discuz!NT2.5正式版发布
开放源码下载
UCenter Home 1.2 正式版发布
官方站 | 帮助文档
基于ECShop的网店托管-卖否
PHP就业培训直通车 | LAMP培训大连
Discuz!收费服务内容及价格
“感谢有你同行”手握手2008年数万元重奖志愿者
Discuz!/ECShop 专用官方虚拟主机
亿声传媒(Insenz)中秋祝福发送中
Comsenz 招聘信息
网店系统ECShop v2.6.0正式版火热发布
基于Discuz!的免费论坛空间5D6D
参与有奖社区调查 赢取台湾5日游
发新话题
打印

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

因为换了新空间.今天从旧论坛导入数据的时候一直出现个别分卷导入不成功.比如我导入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! Support Team   QQ:228998683     MSN(MAIL):sq#live.cn (将#换成@即可)
一心玩户外
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 编辑 ]

附件

error page.JPG (162.06 KB)

2008-3-10 09:52

error page.JPG

我和非鱼一个错误,请问是什么意思啊

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.
发新话题
版块跳转