https://www.icyphoenix.com/viewtopic.php?f=35&t=6859&p=47734#p47734
-----------------------------------
avdl
Thu 11 Feb, 2010 17:05

Re: From PUNBB 1.2.x To ICP
-----------------------------------
[quote user="Mighty Gorgon" post="47253"]Great, let me know, so we can wrap up a process to convert which may be useful for other users.[/quote]

Hello Gordon,
i just tried phpbb to ip conversion.
database_update.php goes through, users and topics conversion seems ok but posts conversions wont work (punbb to phpbb 2023 works good)

IP tables were created by the database_update.php script.
After conversion, users and topics are present in new tables but posts table is empty.
Thanks for help,
André


Here are Requests that did not execute correctly:
[code]
# ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`
+++ Erreur: Duplicate column name 'cat_parent'

# ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`
+++ Erreur: Duplicate column name 'cat_user_id'

# ALTER TABLE phpbb_auth_access ADD `auth_mod` tinyint(1) NOT NULL default '0'
+++ Erreur: Duplicate column name 'auth_mod'

# ALTER TABLE `phpbb_sessions` ADD `session_admin` TINYINT(2) DEFAULT '0' NOT NULL
+++ Erreur: Duplicate column name 'session_admin'

# CREATE TABLE `phpbb_sessions_keys` ( `key_id` varchar(32) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `last_ip` varchar(8) NOT NULL default '0', `last_login` int(11) NOT NULL default '0', PRIMARY KEY (`key_id`,`user_id`), KEY `last_login` (`last_login`) )
+++ Erreur: Table 'phpbb_sessions_keys' already exists

# INSERT INTO phpbb_config VALUES ('allow_autologin', '1')
+++ Erreur: Duplicate entry 'allow_autologin' for key 'PRIMARY'

# INSERT INTO phpbb_config VALUES ('max_autologin_time', '0')
+++ Erreur: Duplicate entry 'max_autologin_time' for key 'PRIMARY'

# INSERT INTO `phpbb_kb_articles` VALUES (1, 1, 'Test Article', 'This is a test article for your KB', '1057708235', 2, '', '93074f48a9', 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric <(...) > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo <(...) > (Jon Ohlsson) - http://www.mx-system.com/ Be sure you add categories and article types in the ACP and also change the Configuration to your liking. Have fun and enjoy your new Knowledge Base! :D', 1, 1, 0, 0, '0.0000', 0)
+++ Erreur: Column count doesn't match value count at row 1

# DROP TABLE phpbb_cracktrack
+++ Erreur: Unknown table 'phpbb_cracktrack'

# ALTER TABLE phpbb_users ADD user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL
+++ Erreur: Duplicate column name 'user_login_tries'

# ALTER TABLE phpbb_users ADD user_last_login_try int(11) DEFAULT '0' NOT NULL
+++ Erreur: Duplicate column name 'user_last_login_try'

# ALTER TABLE `phpbb_search_results` ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL
+++ Erreur: Duplicate column name 'search_time'

# INSERT INTO phpbb_config VALUES ('search_min_chars', '3')
+++ Erreur: Duplicate entry 'search_min_chars' for key 'PRIMARY'

# DROP TABLE phpbb_flags
+++ Erreur: Unknown table 'phpbb_flags'

# DROP TABLE `phpbb_ctrack`
+++ Erreur: Unknown table 'phpbb_ctrack'

# DROP TABLE `phpbb_ct_filter`
+++ Erreur: Unknown table 'phpbb_ct_filter'

# ALTER TABLE `phpbb_users` DROP `ct_postcount`
+++ Erreur: Can't DROP 'ct_postcount'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_posttime`
+++ Erreur: Can't DROP 'ct_posttime'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_searchcount`
+++ Erreur: Can't DROP 'ct_searchcount'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `ct_searchtime`
+++ Erreur: Can't DROP 'ct_searchtime'; check that column/key exists

# DROP TABLE `phpbb_block_position`
+++ Erreur: Unknown table 'phpbb_block_position'

# DROP TABLE `phpbb_block_variable`
+++ Erreur: Unknown table 'phpbb_block_variable'

# DROP TABLE `phpbb_blocks`
+++ Erreur: Unknown table 'phpbb_blocks'

# DROP TABLE `phpbb_layout`
+++ Erreur: Unknown table 'phpbb_layout'

# DROP TABLE `phpbb_portal_config`
+++ Erreur: Unknown table 'phpbb_portal_config'

# DROP TABLE `phpbb_config_mg`
+++ Erreur: Unknown table 'phpbb_config_mg'

# DROP TABLE `phpbb_color_groups`
+++ Erreur: Unknown table 'phpbb_color_groups'

# ALTER TABLE `phpbb_groups` DROP `group_color_group`
+++ Erreur: Can't DROP 'group_color_group'; check that column/key exists

# ALTER TABLE `phpbb_users` DROP `user_session_topic`
+++ Erreur: Can't DROP 'user_session_topic'; check that column/key exists

# ALTER TABLE `phpbb_sessions` DROP `session_topic`
+++ Erreur: Can't DROP 'session_topic'; check that column/key exists

# ALTER TABLE `phpbb_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`
+++ Erreur: Duplicate column name 'layout_special'

# CREATE TABLE `phpbb_dl_notraf` ( user_id MEDIUMINT(8) NOT NULL DEFAULT 0, dl_id INT(11) NOT NULL DEFAULT 0 )
+++ Erreur: Table 'phpbb_dl_notraf' already exists

# ALTER TABLE `phpbb_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Erreur: Unknown column 'forum_wide' in 'phpbb_cms_layout'

# ALTER TABLE `phpbb_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Erreur: Unknown column 'forum_wide' in 'phpbb_cms_layout_special'

# INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('link_this_topic', '0')
+++ Erreur: Duplicate entry 'link_this_topic' for key 'PRIMARY'

# ALTER TABLE `phpbb_ajax_shoutbox` DROP `shout_uid`
+++ Erreur: Can't DROP 'shout_uid'; check that column/key exists

# ALTER TABLE `phpbb_cms_blocks` DROP `block_bbcode_uid`
+++ Erreur: Can't DROP 'block_bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_dl_bug_tracker` DROP `report_uid`
+++ Erreur: Can't DROP 'report_uid'; check that column/key exists

# ALTER TABLE `phpbb_dl_comments` DROP `bbcode_uid`
+++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_downloads` DROP `bbcode_uid`
+++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_downloads_cat` DROP `bbcode_uid`
+++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_kb_articles` DROP `bbcode_uid`
+++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_pa_comments` DROP INDEX `comments_id`
+++ Erreur: Can't DROP 'comments_id'; check that column/key exists

# ALTER TABLE `phpbb_pa_comments` DROP INDEX `comment_bbcode_uid`
+++ Erreur: Can't DROP 'comment_bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_pa_comments` DROP `comment_bbcode_uid`
+++ Erreur: Can't DROP 'comment_bbcode_uid'; check that column/key exists

# ALTER TABLE `phpbb_shout` DROP `shout_bbcode_uid`
+++ Erreur: Can't DROP 'shout_bbcode_uid'; check that column/key exists

# INSERT INTO `___posts___` SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard, p.enable_autolinks_acronyms FROM `phpbb_posts` p, `phpbb_posts_text` t WHERE p.post_id = t.post_id ORDER BY p.post_id
+++ Erreur: Unknown column 't.post_text_compiled' in 'field list'

# DROP TABLE `phpbb_optimize_db`
+++ Erreur: Unknown table 'phpbb_optimize_db'

# INSERT INTO `___megamail___` SELECT m.mail_id, m.mailsession_id, 0, m.user_id, m.group_id, m.email_subject, m.email_body, 0, m.batch_start, m.batch_size, m.batch_wait, m.status FROM `phpbb_megamail` m ORDER BY m.mail_id
+++ Erreur: Table 'tilia2bb2.phpbb_megamail' doesn't exist

# RENAME TABLE `phpbb_megamail` TO `_old_phpbb_megamail`
+++ Erreur: Can't find file: '.\tilia2bb2\phpbb_megamail.frm' (errno: 2)

# ALTER TABLE `phpbb_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`
+++ Erreur: 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 'SET DEFAULT '1' AFTER `border_explain`' at line 1

# ALTER TABLE `phpbb_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`
+++ Erreur: 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 'SET DEFAULT '1' AFTER `border`' at line 1

# UPDATE `phpbb_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'
+++ Erreur: Unknown column 'border_explain' in 'where clause'

# UPDATE `phpbb_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'
+++ Erreur: Unknown column 'border_explain' in 'where clause'

# UPDATE `phpbb_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'
+++ Erreur: Unknown column 'titlebar_explain' in 'where clause'

# UPDATE `phpbb_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'
+++ Erreur: Unknown column 'titlebar_explain' in 'where clause'

# ALTER TABLE phpbb_registration_desc DROP `reg_option1`
+++ Erreur: Can't DROP 'reg_option1'; check that column/key exists

# ALTER TABLE phpbb_registration_desc DROP `reg_option2`
+++ Erreur: Can't DROP 'reg_option2'; check that column/key exists

# ALTER TABLE phpbb_registration_desc DROP `reg_option3`
+++ Erreur: Can't DROP 'reg_option3'; check that column/key exists

# ALTER TABLE `phpbb_cms_layout_special` ADD `page_id` varchar(100) NOT NULL DEFAULT '' AFTER `lsid`
+++ Erreur: Duplicate column name 'page_id'

# ALTER TABLE `phpbb_cms_layout_special` ADD `locked` tinyint(1) NOT NULL DEFAULT '1' AFTER `page_id`
+++ Erreur: Duplicate column name 'locked'
[/code]


