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

mysql 5.0数据库安装的时候字符集的latin1
用论坛里提到的方法：
1.强制以GBK字符集导出数据：
mysqldump -uroot -p --default-character-set=gbk --set-charset=true --skip-opt test01 >
test01.sql

2.然后新建GBK字符集的数据库：
CREATE DATABASE `test` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

3.再导入到新库里，中文都是乱码：
mysql -u root -p --default-character-set=gbk -f test<test01.sql

到底应该用什么办法才能安全有效的把其他字符集的数据库转化成GBK版本的数据库啊？
郁闷死了~`

暂时没问题  

Discuz! info: MySQL Query Error

User: epirate
Time: 2007-7-11 9:26am
Script: /bbs/index.php

SQL: SELECT t.*, f.name FROM [Table]threads t, [Table]forums f WHERE t.fid<>'0' AND f.fid=t.fid AND f.fid NOT IN () AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10
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 ') AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: admin
Time: 2007-7-29 1:41pm
Script: /discuz/index.php

SQL: UPDATE [Table]onlinetime SET total=total+'10', thismonth=thismonth+'10', lastupdate='1185687664' WHERE uid='1' AND lastupdate<='1185687064'
Error: Table '[Table]onlinetime' is read only
Errno.: 1036

請問童虎大哥&#172; 我的這是怎麼回事啊&#172;
我剛把論壇移到 我新安裝的 Fedora 7 上&#172;

有些會員進不了論壇...請幫忙解決..謝謝
板本是4.1.0

Discuz! info: MySQL Query Error

User: gwenzai
Time: 2007-7-28 1:52pm
Script: /forum/index.php

SQL: SELECT pmid, msgfrom, msgfromid, subject, message FROM cdb_pms WHERE msgtoid='714' AND folder='inbox' AND new='1'
Error: Table './wuchun-hk/cdb_pms' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.




短消息跟控制面板都出現問題..請幫忙解決

板本是4.1.0


Discuz! info: MySQL Query Error

User: 珊
Time: 2007-7-31 5:37pm
Script: /forum/pm.php

SQL: SELECT COUNT(*) FROM cdb_pms WHERE msgfromid='126' AND folder='outbox'
Error: Table './wuchun-hk/cdb_pms' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: 珊
Time: 2007-7-31 5:38pm
Script: /forum/memcp.php

SQL: SELECT * FROM cdb_pms WHERE msgtoid='126' AND folder='inbox' ORDER BY dateline DESC LIMIT 0, 5
Error: Table './wuchun-hk/cdb_pms' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

Time: 2007-7-31 10:32am
Script: /dz6/install.php

SQL: INSERT INTO [Table]faqs VALUES ('27','7','4','','','我如何使用RSS訂閱\','在論壇的首頁和進入版塊的頁面的右上角就會出現一個rss訂閱\的小圖標<img src="images/common/xml.gif" border="0">，鼠標點擊之後將出現本站點的rss地址，你可以將此rss地址放入到你的rss閱\讀器中進行訂閱\。')
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 '在論壇的首頁和進入版塊的頁面的右上角就會出現一個rss訂閱\的小圖?br /> Errno.: 1064

Similar error report has beed dispatched to administrator before.

出左數十次了!大家可以救救我嗎?我是第一次裝6.0的!

我的出現以下的問題,不能注冊...請幫忙!!謝謝!
好像給人攻擊了.


Discuz! info: MySQL Query Error

Time: 2007-7-31 7:54pm
Script: /register.php

SQL: INSERT INTO [Table]members (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 ('haiseng123', '7364892a274ddc06b065679cfedc9615', '', '0', '0', '8', '124.82.110.191', '1185882879', '1185882879', '1185882879', '0', 0,0,0,0,0,0,0,0,0, 'haiseng123@yahoo.com.hk', '0000-00-00', '0', '0', '0', '', '', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '0' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

Time: 2007-7-31 4:19pm
Script: /test/install.php

SQL: INSERT INTO [Table]faqs VALUES ('27','7','4','','','我如何使用RSS訂閱\','在論壇的首頁和進入版塊的頁面的右上角就會出現一個rss訂閱\的小圖標<img src="images/common/xml.gif" border="0">，鼠標點擊之後將出現本站點的rss地址，你可以將此rss地址放入到你的rss閱\讀器中進行訂閱\。')
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 '在論壇的首頁和進入版塊的頁面的右上角就會出現一個rss訂閱\的小圖?br /> Errno.: 1064

楼主看的不是很明白也````````