【向版主及高手求助】PhpWind4.3.2 → Discuz 4.1 【MySQL Latin1→Big5】

alain · 发表于 2006-5-19 01:41:22

我將PHPWind 4.3.2 的數據庫載入到全新安裝的Discuz 4.1內，然後進行數據轉換，不過，在轉換數據後，論壇內容出現亂碼。請問應如何解決？

謝謝！

所使用的轉換程序：
https://discuz.dismall.com/attachment.php?aid=43545
見：
https://discuz.dismall.com/viewthread.php?tid=290743

修改該檔案如下：

方法一：
將$mysqlcharset 設定為 'big5';

結果：出現亂碼，在Internet Explorer 中無論使用什麼編碼，也不能看到正常的字。

########### 系統配置 #########################################################
$dbhost = 'localhost'; //mysql主機地址
$dbuser = 'discuz'; //mysql用戶名
$dbpwd = ''; //mysql密碼
$discuz_dbname = 'discuz; //Discuz!所在數據庫 discuz數據庫名
$discuz_tablepre = 'cdb_'; //Discuz!所在數據庫 discuz數據表前綴默認為:cdb_
$source_dbname = 'discuz'; //源數據庫數據庫名
$source_tablepre = 'pw_'; //源數據庫數據表前綴默認為:pw_
$many = '3000'; //每次轉換的數據量
$mysqlcharset = 'big5'; //如果您的MySQL為4.1以上版本請根據您的數據字符集進行設置
//gbk、big5、utf8,latin1
$forumlinknum = 5; // 設置存在超過多少個列表顯示的聯盟論壇則不顯示聯盟論壇描述(精簡顯示),默認:5
$maxretries = 10; //設置最大嘗試次數，用戶解決uid，tid,pid突增的現象

复制代码

方法二：
將$mysqlcharset 設定為 'latin1';
結果：出現以下訊息：

當前操作第 3 / 10 步 => 轉換版區數據

正在轉換:第 0 —— 3000 行數據.

[中止操作並返回程序首頁]

1, 論壇站務區
2, 版主評定和論壇建議區
3, 回收站

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/public_html/forum/pw432tod41.php on line 355
4, 學習領域 (Key Learning Areas)

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/public_html/forum/pw432tod41.php on line 355

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/public_html/forum/pw432tod41.php on line 355
5, 中國語文教育（Chinese Language Education）

伺服器資料：
Apache 1.3.34 Running
DirectAdmin 1.26.6  Running
Exim 4.50 Running
MySQL 4.1.10a Running
Named 9.2.4  Running
ProFTPd 1.2.10  Running
sshd  Running
vm-Pop3d 1.1.7f-T6-DA  Running

以下為MySQL資料表的結構：

  資料表執行記錄型態校對大小多餘
cdb_access             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_adminactions             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_admingroups             3 MyISAM big5_chinese_ci    2.1 KB    -
cdb_adminnotes             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_adminsessions             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_advertisements             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_announcements             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_attachments             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_attachtypes             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_banned             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_bbcodes             7 MyISAM big5_chinese_ci    7.1 KB    -
cdb_blogcaches             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_buddys             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_creditslog             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_crons             8 MyISAM big5_chinese_ci    5.3 KB    -
cdb_dropitem             48 MyISAM latin1_swedish_ci    3.5 KB    -
cdb_failedlogins             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_favorites             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_forumfields             67 MyISAM big5_chinese_ci    11.7 KB    -
cdb_forumlinks             1 MyISAM big5_chinese_ci    2.1 KB    -
cdb_forums             67 MyISAM big5_chinese_ci    27.2 KB    -
cdb_itemmarket             8 MyISAM latin1_swedish_ci    2.2 KB    -
cdb_medals             10 MyISAM big5_chinese_ci    2.3 KB    -
cdb_memberfields             1 MyISAM big5_chinese_ci    2.0 KB    -
cdb_members             1 MyISAM big5_chinese_ci    4.5 KB    -
cdb_moderators             67 MyISAM big5_chinese_ci    2.5 KB    -
cdb_modworks             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_mypetatk             1,738 MyISAM latin1_swedish_ci    76.5 KB    -
cdb_mypetdata             155 MyISAM latin1_swedish_ci    29.9 KB    -
cdb_npcdata             233 MyISAM latin1_swedish_ci    15.8 KB    -
cdb_onlinelist             4 MyISAM big5_chinese_ci    1.1 KB    -
cdb_onlinetime             1 MyISAM big5_chinese_ci    2.0 KB    -
cdb_orders             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_paymentlog             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_petconfig             1 MyISAM latin1_swedish_ci    3.3 KB    -
cdb_petdeldata             43 MyISAM latin1_swedish_ci    9.2 KB    -
cdb_pethecheng             0 MyISAM latin1_swedish_ci    1.0 KB    -
cdb_petjobdata             7 MyISAM latin1_swedish_ci    2.8 KB    -
cdb_petshopdata             20 MyISAM latin1_swedish_ci    4.3 KB    -
cdb_pluginhooks             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_plugins             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_pluginvars             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_pms             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_pmsearchindex             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_polls             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_posts             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_profilefields             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_promotions             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_ranks             5 MyISAM big5_chinese_ci    2.1 KB    -
cdb_ratelog             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_regips             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_relatedthreads             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_rsscaches             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_searchindex             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_sessions             1 HEAP big5_chinese_ci    1.6 MB    -
cdb_settings             159 MyISAM big5_chinese_ci    8.9 KB    -
cdb_smilies             27 MyISAM big5_chinese_ci    2.6 KB    -
cdb_stats             50 MyISAM big5_chinese_ci    4.2 KB    -
cdb_statvars             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_styles             1 MyISAM big5_chinese_ci    2.0 KB    -
cdb_stylevars             27 MyISAM big5_chinese_ci    3.8 KB    -
cdb_subscriptions             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_teammate             1,284 MyISAM latin1_swedish_ci    54.0 KB    -
cdb_templates             1 MyISAM big5_chinese_ci    2.1 KB    -
cdb_threads             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_threadsmod             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_threadtypes             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_usergroups             15 MyISAM big5_chinese_ci    14.2 KB    -
cdb_validating             0 MyISAM big5_chinese_ci    1.0 KB    -
cdb_words             0 MyISAM big5_chinese_ci    1.0 KB    -
ms_ai             3 MyISAM latin1_swedish_ci    2.1 KB    -
ms_analyse             1 MyISAM latin1_swedish_ci    2.1 KB    -
ms_announcement             14 MyISAM latin1_swedish_ci    3.2 KB    -
ms_config             1 MyISAM latin1_swedish_ci    2.4 KB    -
ms_customer             171 MyISAM latin1_swedish_ci    14.3 KB    -
ms_log             728 MyISAM latin1_swedish_ci    113.0 KB    -
ms_news             101 MyISAM latin1_swedish_ci    13.0 KB    -
ms_oneselfstock             0 MyISAM latin1_swedish_ci    1.0 KB    -
ms_stock             20 MyISAM latin1_swedish_ci    10.8 KB    -
ms_user             34 MyISAM latin1_swedish_ci    5.0 KB    -
pw_actions             5 MyISAM latin1_swedish_ci    2.7 KB    -
pw_adminlog             4,890 MyISAM latin1_swedish_ci    1.2 MB    -
pw_adminset             3 MyISAM latin1_swedish_ci    3.9 KB    -
pw_album             1 MyISAM latin1_swedish_ci    3.1 KB    -
pw_alex_hack             17 MyISAM latin1_swedish_ci    2.4 KB    -
pw_announce             3 MyISAM latin1_swedish_ci    6.2 KB    -
pw_argument             1 MyISAM latin1_swedish_ci    2.1 KB    -
pw_attachs             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_banuser             1 MyISAM latin1_swedish_ci    2.1 KB    -
pw_bbsinfo             1 MyISAM latin1_swedish_ci    2.0 KB    -
pw_blog             2 MyISAM latin1_swedish_ci    6.6 KB    -
pw_bloginfo             1 MyISAM latin1_swedish_ci    2.0 KB    -
pw_bmsg             2 MyISAM latin1_swedish_ci    2.7 KB    -
pw_class             3 MyISAM latin1_swedish_ci    6.6 KB    -
pw_clientorder             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_cmembers             8 MyISAM latin1_swedish_ci    5.3 KB    -
pw_cnclass             1 MyISAM latin1_swedish_ci    3.0 KB    -
pw_colonys             1 MyISAM latin1_swedish_ci    4.0 KB    -
pw_comment             2 MyISAM latin1_swedish_ci    5.3 KB    -
pw_config             198 MyISAM latin1_swedish_ci    14.5 KB    -
pw_credits             2 MyISAM latin1_swedish_ci    2.6 KB    -
pw_domain             12 MyISAM latin1_swedish_ci    5.3 KB    -
pw_favors             19 MyISAM latin1_swedish_ci    2.5 KB    -
pw_forumdata             67 MyISAM latin1_swedish_ci    12.1 KB    -
pw_forumlog             3,825 MyISAM latin1_swedish_ci    554.7 KB    -
pw_forums             67 MyISAM latin1_swedish_ci    108.3 KB    -
pw_forumsextra             61 MyISAM latin1_swedish_ci    16.9 KB    -
pw_gbook             3 MyISAM latin1_swedish_ci    3.2 KB    -
pw_group             16 MyISAM latin1_swedish_ci    11.6 KB    -
pw_guess             19 MyISAM latin1_swedish_ci    2.6 KB    -
pw_hack             48 MyISAM latin1_swedish_ci    3.2 KB    -
pw_ipstates             142 MyISAM latin1_swedish_ci    5.1 KB    -
pw_keyword             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_ks             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_medalinfo             18 MyISAM latin1_swedish_ci    3.2 KB    -
pw_medalslogs             44 MyISAM latin1_swedish_ci    5.0 KB    -
pw_membercredit             137 MyISAM latin1_swedish_ci    4.1 KB    -
pw_memberdata             362 MyISAM latin1_swedish_ci    37.9 KB    -
pw_memberinfo             231 MyISAM latin1_swedish_ci    11.4 KB    -
pw_members             360 MyISAM latin1_swedish_ci    71.7 KB    -
pw_modules             15 MyISAM latin1_swedish_ci    15.3 KB    -
pw_msg             1,397 MyISAM latin1_swedish_ci    360.6 KB    -
pw_notice             1 MyISAM latin1_swedish_ci    2.1 KB    -
pw_photo             5 MyISAM latin1_swedish_ci    5.6 KB    -
pw_polls             86 MyISAM latin1_swedish_ci    41.5 KB    -
pw_posts             19,836 MyISAM latin1_swedish_ci    6.0 MB    -
pw_recycle             5 MyISAM latin1_swedish_ci    4.1 KB    -
pw_replace             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_report             115 MyISAM latin1_swedish_ci    33.4 KB    -
pw_rightset             4 MyISAM latin1_swedish_ci    4.6 KB    -
pw_schcache             1 MyISAM latin1_swedish_ci    2.1 KB    -
pw_schindex             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_setting             81 MyISAM latin1_swedish_ci    7.0 KB    -
pw_share             1 MyISAM latin1_swedish_ci    3.0 KB    -
pw_sharelinks             15 MyISAM latin1_swedish_ci    9.4 KB    -
pw_skinconfig             7 MyISAM latin1_swedish_ci    26.6 KB    -
pw_smiles             8 MyISAM latin1_swedish_ci    2.2 KB    -
pw_style             1 MyISAM latin1_swedish_ci    2.4 KB    -
pw_styles             1 MyISAM latin1_swedish_ci    2.2 KB    -
pw_tblog             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_team             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_threads             3,962 MyISAM latin1_swedish_ci    1.0 MB    -
pw_tmsgs             3,962 MyISAM latin1_swedish_ci    4.6 MB    -
pw_toollog             630 MyISAM latin1_swedish_ci    92.6 KB    -
pw_tools             12 MyISAM latin1_swedish_ci    4.3 KB    -
pw_tuser             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_upload             0 MyISAM latin1_swedish_ci    1.0 KB    -
pw_user             10 MyISAM latin1_swedish_ci    24.2 KB    -
pw_usergroups             18 MyISAM latin1_swedish_ci    8.4 KB    -
pw_userinfo             2 MyISAM latin1_swedish_ci    2.6 KB    -
pw_usertool             4 MyISAM latin1_swedish_ci    2.1 KB    -
pw_wordfb             8 MyISAM latin1_swedish_ci    2.2 KB    -
ts_fingerguess             17 MyISAM latin1_swedish_ci    3.0 KB    -
wxd_invite             0 MyISAM latin1_swedish_ci    1.0 KB    -
wxd_invite_config             1 MyISAM latin1_swedish_ci    2.1 KB    -
  155 資料表總計  45,911  -- latin1_swedish_ci    16.4 MB 0 Bytes

[ 本帖最后由 alain 于 2006-5-21 02:45 编辑 ]

gldxsw · 发表于 2006-5-19 12:54:27

不清楚的话为什么不让官方的数据转换人员帮忙?俺没有技术,也是从PHPWIND转过来的,好在有官方的热心人帮忙!

freddy · 发表于 2006-5-19 13:31:35

我好像帮过楼上的...

alain · 发表于 2006-5-19 19:42:12

原帖由 freddy 于 2006-5-19 13:31 发表
我好像帮过楼上的...

請問如何求救？

xixitj · 发表于 2006-5-19 20:47:26

用方法1转换

修改config.inc.php

alain · 发表于 2006-5-19 21:42:01

原帖由 xixitj 于 2006-5-19 20:47 发表
用方法1转换

修改config.inc.php

但數據表中混集了latin1_swedish_ci 及 big5_chinese_ci ，方法1可行嗎？

[ 本帖最后由 alain 于 2006-5-19 21:54 编辑 ]

wendycupid · 发表于 2006-5-19 22:50:27

没人帮我-。-！

alain · 发表于 2006-5-20 09:12:19

原帖由 wendycupid 于 2006-5-19 22:50 发表
没人帮我-。-！

希望版主可以提供專業意見!
謝謝!

alain · 发表于 2006-5-21 02:44:38

原帖由 wendycupid 于 2006-5-19 22:50 发表
没人帮我-。-！

請問有那位高手可以施予援手？

luowumayi · 发表于 2008-6-27 23:11:36

看到官方论坛出也有朋友遇到这个问题我也是一样
搞了半天都没有解决
后来发现这个方法
========================================================
进phpmyadmin，进入bbs数据库删除该表
然后创建它，sql语句如下
CREATE TABLE `bbs_banuser` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `startdate` int(10) NOT NULL default '0',
  `days` int(4) NOT NULL default '0',
  `admin` char(15) NOT NULL default '',
  `reason` char(80) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
注意编码，我用的是gbk
===========================================================
但是提示错误
Copy code#1064 - 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 'DEFAULT CHARSET=gbk' at line 9

不能成功第九行错误

后来突然想到一个办法终于搞定特意发出来给大家分享
先在空间重新安装一套论坛在别的目录数据库表名默认的是hnr_的
你安装一个跟这个不一样的我的是hnr_ 这个的
安装好后进入 phpmyadmin 然后点右边上部的操作
然后将新建的论坛表的hnr_banuser 这个复制到hnr_banuser 里边然后论坛后台修复下数据库就可以了嘿嘿不明白的在问啊！
本文来自: [河南人论坛]本文详细地址：http://www.hnr123.cn/read.php?tid=788

		自动登录	找回密码
密码			立即注册