猫小白(在路上)

@max
忘记说了，要将这个新增的字段改为主键！！ 切记～ 呵呵

出现了BIGQI Info: Duplicate entry ’14′ for key ‘PRIMARY’ 之类的数据错误是因为bo-blog中的字段主键与WP的主键不同，造成数据在转移的过程中有重复！
解决办法：
在wp_term_taxonomy 中增加一个aa或者是其他名字，属性为： int, 自动增加，然后再重新转移数据。

BIGQI Info: Duplicate entry ’9′ for key 1

Errno: 1062
Message: MySQL Query Error
Time: 2010-9-1 12:56pm
Script:
SQL: INSERT INTO wp_term_taxonomy (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`,`count`) VALUES (’4′, ’4′,’category’, ‘猫碌鈥灻劉’,42),(’7′, ’7′,’category’, ‘忙鈥斅睹┾€斅疵÷?,14),(’8′, ’8′,’category’, ‘忙鈥澛睹р€犆解€?,3),(’9′, ’9′,’category’, ‘茅垄鈥灻モ€樑犆р€扳€?,10),(’10′, ’10′,’post_tag’,”, 176),(’11′, ’11′,’post_tag’,”, 1),(’12′, ’12′,’post_tag’,”, 1),(’9′, ’9′,’category’,”, 16),(’13′, ’13′,’post_tag’,”, 1),(’14′, ’14′,’post_tag’,”, 1),(’15′, ’15′,’post_tag’,”, 1),(’16′, ’16′,’post_tag’,”, 1),(’17′, ’17′,’post_tag’,”, 1),(’18′, ’18′,’post_tag’,”, 1)

BIGQI Info: Duplicate entry ’3′ for key ‘PRIMARY’

Errno: 1062
Message: MySQL Query Error
Time: 2010-8-29 8:19am
Script:
SQL: INSERT INTO wp_term_taxonomy (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`,`count`) VALUES (’3′, ’3′,’category’, ‘癡瞼聶疆繒�汕捍腕把€兜怔刈鄞�疆簫癒癡聶鬚疇簣�嘔刈蜃酵氐把€阬兩€� 疇禮�阬兩€氐匐岑溫￣純敷�0913-782-807‘,14),(’3′, ’3′,’category’,”, 21),(’4′, ’4′,’category’,”, 10),(’8′, ’8′,’post_tag’,”, 167),(’9′, ’9′,’post_tag’,”, 6),(’10′, ’10′,’post_tag’,”, 1),(’11′, ’11′,’post_tag’,”, 1),(’12′, ’12′,’post_tag’,”, 14),(’13′, ’13′,’post_tag’,”, 1),(’14′, ’14′,’post_tag’,”, 1),(’15′, ’15′,’post_tag’,”, 1),(’16′, ’16′,’post_tag’,”, 1),(’17′, ’17′,’post_tag’,”, 2),(’18′, ’18′,’post_tag’,”, 1),(’19′, ’19′,’post_tag’,”, 2),(’20′, ’20′,’post_tag’,”, 8),(’21′, ’21′,’post_tag’,”, 1),(’22′, ’22′,’post_tag’,”, 5),(’23′, ’23′,’post_tag’,”, 6),(’24′, ’24′,’post_tag’,”, 1),(’25′, ’25′,’post_tag’,”, 14),(’26′, ’26′,’post_tag’,”, 5),(’27′, ’27′,’post_tag’,”, 1),(’28′, ’28′,’post_tag’,”, 1),(’29′, ’29′,’post_tag’,”, 5),(’30′, ’30′,’post_tag’,”, 7),(’31′, ’31′,’post_tag’,”, 2),(’32′, ’32′,’post_tag’,”, 1),(’33′, ’33′,’post_tag’,”, 1),(’34′, ’34′,’post_tag’,”, 1),(’35′, ’35′,’post_tag’,”, 1),(’36′, ’36′,’post_tag’,”, 1),(’37′, ’37′,’post_tag’,”, 1),(’38′, ’38′,’post_tag’,”, 1),(’39′, ’39′,’post_tag’,”, 1),(’40′, ’40′,’post_tag’,”, 1),(’41′, ’41′,’post_tag’,”, 1),(’42′, ’42′,’post_tag’,”, 1),(’43′, ’43′,’post_tag’,”, 2),(’44′, ’44′,’post_tag’,”, 1),(’45′, ’45′,’post_tag’,”, 1),(’46′, ’46′,’post_tag’,”, 3),(’47′, ’47′,’post_tag’,”, 1),(’48′, ’48′,’post_tag’,”, 1),(’49′, ’49′,’post_tag’,”, 1),(’50′, ’50′,’post_tag’,”, 1),(’51′, ’51′,’post_tag’,”, 1),(’52′, ’52′,’post_tag’,”, 10),(’53′, ’53′,’post_tag’,”, 1),(’54′, ’54′,’post_tag’,”, 1),(’55′, ’55′,’post_tag’,”, 1),(’56′, ’56′,’post_tag’,”, 1),(’57′, ’57′,’post_tag’,”, 1),(’58′, ’58′,’post_tag’,”, 1),(’59′, ’59′,’post_tag’,”, 13),(’60′, ’60′,’post_tag’,”, 1),(’61′, ’61′,’post_tag’,”, 7),(’62′, ’62′,’post_tag’,”, 5),(’63′, ’63′,’post_tag’,”, 1),(’64′, ’64′,’post_tag’,”, 1),(’65′, ’65′,’post_tag’,”, 1),(’66′, ’66′,’post_tag’,”, 1),(’67′, ’67′,’post_tag’,”, 2),(’68′, ’68′,’post_tag’,”, 1),(’69′, ’69′,’post_tag’,”, 1),(’70′, ’70′,’post_tag’,”, 1),(’71′, ’71′,’post_tag’,”, 1),(’72′, ’72′,’post_tag’,”, 7),(’73′, ’73′,’post_tag’,”, 1),(’74′, ’74′,’post_tag’,”, 1),(’75′, ’75′,’post_tag’,”, 1),(’76′, ’76′,’post_tag’,”, 1),(’77′, ’77′,’post_tag’,”, 1),(’78′, ’78′,’post_tag’,”, 1),(’79′, ’79′,’post_tag’,”, 1),(’80′, ’80′,’post_tag’,”, 1),(’81′, ’81′,’post_tag’,”, 1),(’82′, ’82′,’post_tag’,”, 1),(’83′, ’83′,’post_tag’,”, 1),(’84′, ’84′,’post_tag’,”, 2),(’85′, ’85′,’post_tag’,”, 1),(’86′, ’86′,’post_tag’,”, 1),(’87′, ’87′,’post_tag’,”, 4),(’88′, ’88′,’post_tag’,”, 1),(’89′, ’89′,’post_tag’,”, 1),(’90′, ’90′,’post_tag’,”, 1),(’91′, ’91′,’post_tag’,”, 1),(’92′, ’92′,’post_tag’,”, 1),(’93′, ’93′,’post_tag’,”, 1),(’94′, ’94′,’post_tag’,”, 1),(’95′, ’95′,’post_tag’,”, 1),(’96′, ’96′,’post_tag’,”, 6),(’97′, ’97′,’post_tag’,”, 1),(’98′, ’98′,’post_tag’,”, 1),(’99′, ’99′,’post_tag’,”, 1),(’100′, ’100′,’post_tag’,”, 1),(’101′, ’101′,’post_tag’,”, 1),(’102′, ’102′,’post_tag’,”, 1),(’103′, ’103′,’post_tag’,”, 1),(’104′, ’104′,’post_tag’,”, 1),(’105′, ’105′,’post_tag’,”, 1),(’106′, ’106′,’post_tag’,”, 1),(’107′, ’107′,’post_tag’,”, 1),(’108′, ’108′,’post_tag’,”, 1),(’109′, ’109′,’post_tag’,”, 1),(’110′, ’110′,’post_tag’,”, 1),(’111′, ’111′,’post_tag’,”, 1),(’112′, ’112′,’post_tag’,”, 1),(’113′, ’113′,’post_tag’,”, 1),(’114′, ’114′,’post_tag’,”, 1),(’115′, ’115′,’post_tag’,”, 1),(’116′, ’116′,’post_tag’,”, 1),(’117′, ’117′,’post_tag’,”, 1),(’118′, ’118′,’post_tag’,”, 2),(’119′, ’119′,’post_tag’,”, 1),(’120′, ’120′,’post_tag’,”, 1),(’121′, ’121′,’post_tag’,”, 1),(’122′, ’122′,’post_tag’,”, 1),(’123′, ’123′,’post_tag’,”, 1),(’124′, ’124′,’post_tag’,”, 1),(’125′, ’125′,’post_tag’,”, 1),(’126′, ’126′,’post_tag’,”, 1),(’127′, ’127′,’post_tag’,”, 3),(’128′, ’128′,’post_tag’,”, 1),(’129′, ’129′,’post_tag’,”, 1),(’130′, ’130′,’post_tag’,”, 1),(’131′, ’131′,’post_tag’,”, 1),(’132′, ’132′,’post_tag’,”, 1),(’133′, ’133′,’post_tag’,”, 1),(’134′, ’134′,’post_tag’,”, 1),(’135′, ’135′,’post_tag’,”, 1),(’136′, ’136′,’post_tag’,”, 1),(’137′, ’137′,’post_tag’,”, 1),(’138′, ’138′,’post_tag’,”, 1),(’139′, ’139′,’post_tag’,”, 1),(’140′, ’140′,’post_tag’,”, 1),(’141′, ’141′,’post_tag’,”, 1),(’142′, ’142′,’post_tag’,”, 1),(’143′, ’143′,’post_tag’,”, 1),(’144′, ’144′,’post_tag’,”, 1),(’145′, ’145′,’post_tag’,”, 1),(’146′, ’146′,’post_tag’,”, 1),(’147′, ’147′,’post_tag’,”, 1),(’148′, ’148′,’post_tag’,”, 2),(’149′, ’149′,’post_tag’,”, 2),(’150′, ’150′,’post_tag’,”, 1),(’151′, ’151′,’post_tag’,”, 3),(’152′, ’152′,’post_tag’,”, 2),(’153′, ’153′,’post_tag’,”, 1),(’154′, ’154′,’post_tag’,”, 1),(’155′, ’155′,’post_tag’,”, 1),(’156′, ’156′,’post_tag’,”, 1),(’157′, ’157′,’post_tag’,”, 1),(’158′, ’158′,’post_tag’,”, 1),(’159′, ’159′,’post_tag’,”, 1),(’160′, ’160′,’post_tag’,”, 1),(’161′, ’161′,’post_tag’,”, 1),(’162′, ’162′,’post_tag’,”, 1),(’163′, ’163′,’post_tag’,”, 1),(’164′, ’164′,’post_tag’,”, 1),(’165′, ’165′,’post_tag’,”, 1),(’166′, ’166′,’post_tag’,”, 1),(’167′, ’167′,’post_tag’,”, 1),(’168′, ’168′,’post_tag’,”, 1),(’169′, ’169′,’post_tag’,”, 1),(’170′, ’170′,’post_tag’,”, 1),(’171′, ’171′,’post_tag’,”, 1),(’5′, ’5′,’category’,”, 5),(’172′, ’172′,’post_tag’,”, 1),(’173′, ’173′,’post_tag’,”, 1),(’174′, ’174′,’post_tag’,”, 1),(’175′, ’175′,’post_tag’,”, 1),(’176′, ’176′,’post_tag’,”, 1),(’177′, ’177′,’post_tag’,”, 1),(’178′, ’178′,’post_tag’,”, 1),(’179′, ’179′,’post_tag’,”, 1),(’180′, ’180′,’post_tag’,”, 1),(’181′, ’181′,’post_tag’,”, 1)

Have no cash to buy some real estate? Don’t worry, just because this is achievable to take the loan to work out such kind of problems. Hence take a short term loan to buy all you require.

http://www.00857.cn

转换完成后都是乱码怎么办？

博客搞得不错，欢迎也到我那看看，提提建议。

出错：
Warning: BQDB::require(e:\www\web\aluz.cn\wwwroot\movedata\.data/config.inc.php) [function.BQDB-require]: failed to open stream: No such file or directory in e:\www\web\aluz.cn\wwwroot\movedata\include\db_mysql.class.php on line 88

@haierspi
请问您的QQ是多少？

您好。在网上下载的WordPress.v3.0.Incl.Simp.Chinese.Pack.v2-wpcng.zip 这个版本一直转换不成功。。提示错误和6楼的差不多。。清空terms也没有用。。。能不能把你用的WP版本发给我一份。

找了好久

有人成功转换了吗？ 给个例子瞧瞧

达人 能否写个 wordpress to emlog 的转换程序吖~！

这个必须支持。。。我现在就是BO-BLOG的，，想换。。。

转换时出现如下错误，请指教！

BIGQI Info: Duplicate entry ‘%E6%9C%AA%E5%88%86%E7%B1%BB’ for key ‘slug’

Errno: 1062
Message: MySQL Query Error
Time: 2010-7-22 6:15am
Script:
SQL: INSERT INTO wp_terms (`term_id`,`name`,`slug`) VALUES (’3′,’鏈垎绫?,’%E6%9C%AA%E5%88%86%E7%B1%BB’),(’4′,’淇虹殑瀛?,’%E4%BF%BA%E7%9A%84%E5%AD%97′),(’6′,’缃戞枃鎽?,’%E7%BD%91%E6%96%87%E6%91%98′),(’7′,’璋垵瀹?,’%E8%B0%AC%E6%88%9D%E5%AE%A2′),(’8′,’澶ф澀宸?,’%E5%A4%A7%E6%9D%AD%E5%B7%9E’),(’9′,’铏炬壇铔?,’%E8%99%BE%E6%89%AF%E8%9B%8B’),(’16′,’澶у睅璁?,’%E5%A4%A7%E5%B1%8E%E8%AE%B0′),(’17′,’鎵摢璺?,’%E6%89%AC%E5%93%AA%E8%B7%91′),(’18′,’鍥炲繂褰?,’%E5%9B%9E%E5%BF%86%E5%BD%95′),(’19′,’鏅掑眮灞?,’%E6%99%92%E5%B1%81%E5%B1%81′),(’20′,’娴佹按璐?,’%E6%B5%81%E6%B0%B4%E8%B4%A6′),(’21′,’鍙嬫枃鎽?,’%E5%8F%8B%E6%96%87%E6%91%98′),(’22′,”,”),(’23′,’涓婃捣’,'%E4%B8%8A%E6%B5%B7′),(’24′,’灏忓攼’,'%E5%B0%8F%E5%94%90′),(’25′,’骞翠腑浼氳’,'%E5%B9%B4%E4%B8%AD%E4%BC%9A%E8%AE%AE’),(’26′,’妗愬簮’,'%E6%A1%90%E5%BA%90′),(’27′,’灏忓Ξ瀛?,’%E5%B0%8F%E5%A6%AE%E5%AD%90′),(’28′,’娓告吵’,'%E6%B8%B8%E6%B3%B3′),(’29′,’涔斿竷鏂?,’%E4%B9%94%E5%B8%83%E6%96%AF’),(’30′,’apple’,'apple’),(’31′,’鐚?,’%E7%8C%AB’),(’32′,’绉︾殗宀?,’%E7%A7%A6%E7%9A%87%E5%B2%9B’),(’33′,’鐩爣’,'%E7%9B%AE%E6%A0%87′),(’34′,’绮夌孩鑹?,’%E7%B2%89%E7%BA%A2%E8%89%B2′),(’35′,’灏忎腹’,'%E5%B0%8F%E4%B8%B9′),(’36′,’涓滃寳鑿?,’%E4%B8%9C%E5%8C%97%E8%8F%9C’),(’37′,’闆烽洦’,'%E9%9B%B7%E9%9B%A8′),(’38′,’鏄剧ず鍣?,’%E6%98%BE%E7%A4%BA%E5%99%A8′),(’39′,’鑸熷北涓滆矾’,'%E8%88%9F%E5%B1%B1%E4%B8%9C%E8%B7%AF’),(’40′,’璀﹀憡’,'%E8%AD%A6%E5%91%8A’),(’41′,’涓滃寳’,'%E4%B8%9C%E5%8C%97′),(’42′,’闆ㄧ偣’,'%E9%9B%A8%E7%82%B9′),(’43′,’澶у簡’,'%E5%A4%A7%E5%BA%86′),(’44′,’楣?,’%E9%B9%A4′),(’45′,’鐕曞瓙’,'%E7%87%95%E5%AD%90′),(’46′,’闈欏効’,'%E9%9D%99%E5%84%BF’),(’47′,’鍖婚櫌’,'%E5%8C%BB%E9%99%A2′)

BIGQI Info: Duplicate entry ’14′ for key ‘PRIMARY’

Errno: 1062
Message: MySQL Query Error
Time: 2010-7-20 8:50am
Script:
SQL: INSERT INTO wp_term_taxonomy
出现这个

嘿~

这个必须支持。

不过建议弄之前一定要先备份啊。