Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post From PUNBB 1.2.x To ICP 
 
Hello everybody,
I have a forum powered with punbb 1.2.4 and, now that french language files are available (thanks to the translators), i'd like to move to Icy Phoenix.
I search infos on local forum and on the web, and it seems move is not really simple  
- i should move to phpbb2
- then move to phpbb3
- then move to icp
- then make work having to be done after transfer
More, i'd like to keep users passwords as described on phpbb forums
http://www.phpbb.com/community/view...298342&start=75

Wouldn't it be possible to imagine a conversion tool to enable webmasters to make the move in only one step ?
if it doesn't exist and/or will not exist so soon, would it be possible to find somebody able to help me for rather basic costs ?

Thanks for help,
André
 



 
Last edited by avdl on Tue 19 Jan, 2010 21:30; edited 1 time in total 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
#French
Bonjour,

Tout d'abord souviens-toi: la traduction n'est pas finie !
J'ai écris une procédure de migration, sinon fais une petite recherche

#English
Hi,
First, remember that the translation is not finished !
I have wrote a how to, else search ;-).
 



 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Informpro wrote: [View Post]
#French
Tout d'abord souviens-toi: la traduction n'est pas finie !

Yes, I noticed that, thanks,
if i make it, spare some time in the coming months, i'll give an hand, but right now, it's not possible for me !

Quote:

J'ai écris une procédure de migration, sinon fais une petite recherche

if i post a question here, it certainly means i couldn't find it !
I tried several searches on this site ... noway
i tried a search directly from search engines .... unsuccessful too, no how-to to find here or anywhere else.

If you give me the link, sure it might be helpful for many of us !!!
Thanks,
André
 



 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Right procedure: convert from punbb to phpbb _2_, then convert to IP .

Ok, I just post a (reallyyyyyyyyyyyyyyyyy) little SVN commit .

Let me explain something: IcyPhoenix.fr will die, because i'm not the owner of the domain (was I-neti, who die). ChillyBoarder pay for 1 year, I don't know when it will finish (2 weeks ? 1 month ?). I will backup LOL.
 



 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
The right procedure to update is this (provided the right convertors are available and working):
  • Convert from PUNBB to phpBB 2
  • Upgrade phpBB 2 to Icy Phoenix
  • Edit the login procedure to allow usage of PUNBB passwords


If you are willing to have a try on a local testing environment we are pleased to help for free.

If you want someone doing that for you... it's your choice.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Informpro wrote: [View Post]
Right procedure: convert from punbb to phpbb _2_, then convert to IP .

Thanks for that answer, i did not understand the move to ICP was from PHPBB2, that seems ok now.


Quote:

Ok, I just post a (reallyyyyyyyyyyyyyyyyy) little SVN commit .

I received it, thanks
BTW, is there a way to get the french buttons you used on IcyPhoenix.fr.
I couldn't find a place to download from ?

Quote:

Let me explain something: IcyPhoenix.fr will die,

I'm new to Icy and this website is the one i really need.
Perhaps a french forum within this forum would be the solution for the french-only  speakers ?
Thanks,
André
 



 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Ok - Ip.fr is still open ! This is really a surprise because I'm not the owner of the domain (was the host, who "disappear"), so I'm happy to have it working LOL ^^.

I will do a db backup and buy a icyphoenix-fr.com (I don't know when ip.fr will end ... I can't rebuy a new year, the host "disappear").

I will release a IcyPhoenix Pack with with buttons ! Anyway, you can find it here .
 



 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Mighty Gorgon wrote: [View Post]
The right procedure to update is this (provided the right convertors are available and working):
  • Convert from PUNBB to phpBB 2
  • Upgrade phpBB 2 to Icy Phoenix
  • Edit the login procedure to allow usage of PUNBB passwords


Thanks Gordon,
I think that will do it,
I hoped there was a direct way to import data.
I gave the punbb2phpbb2 a try, it works good, except language preference of users are not kept.
I did not try the phpbb2icy import yet.
I'll come back if i stumble

Regards,
André
 



 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Great, let me know, so we can wrap up a process to convert which may be useful for other users.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Mighty Gorgon wrote: [View Post]
Great, let me know, so we can wrap up a process to convert which may be useful for other users.


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: [Download] [Hide]
  1. # ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`  
  2. +++ Erreur: Duplicate column name 'cat_parent'  
  3.  
  4. # ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`  
  5. +++ Erreur: Duplicate column name 'cat_user_id'  
  6.  
  7. # ALTER TABLE phpbb_auth_access ADD `auth_mod` tinyint(1) NOT NULL default '0'  
  8. +++ Erreur: Duplicate column name 'auth_mod'  
  9.  
  10. # ALTER TABLE `phpbb_sessions` ADD `session_admin` TINYINT(2) DEFAULT '0' NOT NULL  
  11. +++ Erreur: Duplicate column name 'session_admin'  
  12.  
  13. # 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`) )  
  14. +++ Erreur: Table 'phpbb_sessions_keys' already exists  
  15.  
  16. # INSERT INTO phpbb_config VALUES ('allow_autologin', '1')  
  17. +++ Erreur: Duplicate entry 'allow_autologin' for key 'PRIMARY'  
  18.  
  19. # INSERT INTO phpbb_config VALUES ('max_autologin_time', '0')  
  20. +++ Erreur: Duplicate entry 'max_autologin_time' for key 'PRIMARY'  
  21.  
  22. # 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)  
  23. +++ Erreur: Column count doesn't match value count at row 1  
  24.  
  25. # DROP TABLE phpbb_cracktrack  
  26. +++ Erreur: Unknown table 'phpbb_cracktrack'  
  27.  
  28. # ALTER TABLE phpbb_users ADD user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL  
  29. +++ Erreur: Duplicate column name 'user_login_tries'  
  30.  
  31. # ALTER TABLE phpbb_users ADD user_last_login_try int(11) DEFAULT '0' NOT NULL  
  32. +++ Erreur: Duplicate column name 'user_last_login_try'  
  33.  
  34. # ALTER TABLE `phpbb_search_results` ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL  
  35. +++ Erreur: Duplicate column name 'search_time'  
  36.  
  37. # INSERT INTO phpbb_config VALUES ('search_min_chars', '3')  
  38. +++ Erreur: Duplicate entry 'search_min_chars' for key 'PRIMARY'  
  39.  
  40. # DROP TABLE phpbb_flags  
  41. +++ Erreur: Unknown table 'phpbb_flags'  
  42.  
  43. # DROP TABLE `phpbb_ctrack`  
  44. +++ Erreur: Unknown table 'phpbb_ctrack'  
  45.  
  46. # DROP TABLE `phpbb_ct_filter`  
  47. +++ Erreur: Unknown table 'phpbb_ct_filter'  
  48.  
  49. # ALTER TABLE `phpbb_users` DROP `ct_postcount`  
  50. +++ Erreur: Can't DROP 'ct_postcount'; check that column/key exists  
  51.  
  52. # ALTER TABLE `phpbb_users` DROP `ct_posttime`  
  53. +++ Erreur: Can't DROP 'ct_posttime'; check that column/key exists  
  54.  
  55. # ALTER TABLE `phpbb_users` DROP `ct_searchcount`  
  56. +++ Erreur: Can't DROP 'ct_searchcount'; check that column/key exists  
  57.  
  58. # ALTER TABLE `phpbb_users` DROP `ct_searchtime`  
  59. +++ Erreur: Can't DROP 'ct_searchtime'; check that column/key exists  
  60.  
  61. # DROP TABLE `phpbb_block_position`  
  62. +++ Erreur: Unknown table 'phpbb_block_position'  
  63.  
  64. # DROP TABLE `phpbb_block_variable`  
  65. +++ Erreur: Unknown table 'phpbb_block_variable'  
  66.  
  67. # DROP TABLE `phpbb_blocks`  
  68. +++ Erreur: Unknown table 'phpbb_blocks'  
  69.  
  70. # DROP TABLE `phpbb_layout`  
  71. +++ Erreur: Unknown table 'phpbb_layout'  
  72.  
  73. # DROP TABLE `phpbb_portal_config`  
  74. +++ Erreur: Unknown table 'phpbb_portal_config'  
  75.  
  76. # DROP TABLE `phpbb_config_mg`  
  77. +++ Erreur: Unknown table 'phpbb_config_mg'  
  78.  
  79. # DROP TABLE `phpbb_color_groups`  
  80. +++ Erreur: Unknown table 'phpbb_color_groups'  
  81.  
  82. # ALTER TABLE `phpbb_groups` DROP `group_color_group`  
  83. +++ Erreur: Can't DROP 'group_color_group'; check that column/key exists  
  84.  
  85. # ALTER TABLE `phpbb_users` DROP `user_session_topic`  
  86. +++ Erreur: Can't DROP 'user_session_topic'; check that column/key exists  
  87.  
  88. # ALTER TABLE `phpbb_sessions` DROP `session_topic`  
  89. +++ Erreur: Can't DROP 'session_topic'; check that column/key exists  
  90.  
  91. # ALTER TABLE `phpbb_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`  
  92. +++ Erreur: Duplicate column name 'layout_special'  
  93.  
  94. # CREATE TABLE `phpbb_dl_notraf` ( user_id MEDIUMINT(8) NOT NULL DEFAULT 0, dl_id INT(11) NOT NULL DEFAULT 0 )  
  95. +++ Erreur: Table 'phpbb_dl_notraf' already exists  
  96.  
  97. # ALTER TABLE `phpbb_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'  
  98. +++ Erreur: Unknown column 'forum_wide' in 'phpbb_cms_layout'  
  99.  
  100. # ALTER TABLE `phpbb_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'  
  101. +++ Erreur: Unknown column 'forum_wide' in 'phpbb_cms_layout_special'  
  102.  
  103. # INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('link_this_topic', '0')  
  104. +++ Erreur: Duplicate entry 'link_this_topic' for key 'PRIMARY'  
  105.  
  106. # ALTER TABLE `phpbb_ajax_shoutbox` DROP `shout_uid`  
  107. +++ Erreur: Can't DROP 'shout_uid'; check that column/key exists  
  108.  
  109. # ALTER TABLE `phpbb_cms_blocks` DROP `block_bbcode_uid`  
  110. +++ Erreur: Can't DROP 'block_bbcode_uid'; check that column/key exists  
  111.  
  112. # ALTER TABLE `phpbb_dl_bug_tracker` DROP `report_uid`  
  113. +++ Erreur: Can't DROP 'report_uid'; check that column/key exists  
  114.  
  115. # ALTER TABLE `phpbb_dl_comments` DROP `bbcode_uid`  
  116. +++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists  
  117.  
  118. # ALTER TABLE `phpbb_downloads` DROP `bbcode_uid`  
  119. +++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists  
  120.  
  121. # ALTER TABLE `phpbb_downloads_cat` DROP `bbcode_uid`  
  122. +++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists  
  123.  
  124. # ALTER TABLE `phpbb_kb_articles` DROP `bbcode_uid`  
  125. +++ Erreur: Can't DROP 'bbcode_uid'; check that column/key exists  
  126.  
  127. # ALTER TABLE `phpbb_pa_comments` DROP INDEX `comments_id`  
  128. +++ Erreur: Can't DROP 'comments_id'; check that column/key exists  
  129.  
  130. # ALTER TABLE `phpbb_pa_comments` DROP INDEX `comment_bbcode_uid`  
  131. +++ Erreur: Can't DROP 'comment_bbcode_uid'; check that column/key exists  
  132.  
  133. # ALTER TABLE `phpbb_pa_comments` DROP `comment_bbcode_uid`  
  134. +++ Erreur: Can't DROP 'comment_bbcode_uid'; check that column/key exists  
  135.  
  136. # ALTER TABLE `phpbb_shout` DROP `shout_bbcode_uid`  
  137. +++ Erreur: Can't DROP 'shout_bbcode_uid'; check that column/key exists  
  138.  
  139. # 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  
  140. +++ Erreur: Unknown column 't.post_text_compiled' in 'field list'  
  141.  
  142. # DROP TABLE `phpbb_optimize_db`  
  143. +++ Erreur: Unknown table 'phpbb_optimize_db'  
  144.  
  145. # 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  
  146. +++ Erreur: Table 'tilia2bb2.phpbb_megamail' doesn't exist  
  147.  
  148. # RENAME TABLE `phpbb_megamail` TO `_old_phpbb_megamail`  
  149. +++ Erreur: Can't find file: '.\tilia2bb2\phpbb_megamail.frm' (errno: 2)  
  150.  
  151. # ALTER TABLE `phpbb_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`  
  152. +++ 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  
  153.  
  154. # ALTER TABLE `phpbb_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`  
  155. +++ 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  
  156.  
  157. # UPDATE `phpbb_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'  
  158. +++ Erreur: Unknown column 'border_explain' in 'where clause'  
  159.  
  160. # UPDATE `phpbb_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'  
  161. +++ Erreur: Unknown column 'border_explain' in 'where clause'  
  162.  
  163. # UPDATE `phpbb_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'  
  164. +++ Erreur: Unknown column 'titlebar_explain' in 'where clause'  
  165.  
  166. # UPDATE `phpbb_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'  
  167. +++ Erreur: Unknown column 'titlebar_explain' in 'where clause'  
  168.  
  169. # ALTER TABLE phpbb_registration_desc DROP `reg_option1`  
  170. +++ Erreur: Can't DROP 'reg_option1'; check that column/key exists  
  171.  
  172. # ALTER TABLE phpbb_registration_desc DROP `reg_option2`  
  173. +++ Erreur: Can't DROP 'reg_option2'; check that column/key exists  
  174.  
  175. # ALTER TABLE phpbb_registration_desc DROP `reg_option3`  
  176. +++ Erreur: Can't DROP 'reg_option3'; check that column/key exists  
  177.  
  178. # ALTER TABLE `phpbb_cms_layout_special` ADD `page_id` varchar(100) NOT NULL DEFAULT '' AFTER `lsid`  
  179. +++ Erreur: Duplicate column name 'page_id'  
  180.  
  181. # ALTER TABLE `phpbb_cms_layout_special` ADD `locked` tinyint(1) NOT NULL DEFAULT '1' AFTER `page_id`  
  182. +++ Erreur: Duplicate column name 'locked'  
  183.  

 



 
Last edited by avdl on Thu 11 Feb, 2010 22:50; edited 2 times in total 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
The most of this errors are duplicated entrys, what means that the tables or entrys already exist.

Others are drop errors, that tell you that the tables it should drop do´nt exist.
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
spydie wrote: [View Post]
The most of this errors are duplicated entrys, what means that the tables or entrys already exist.

Others are drop errors, that tell you that the tables it should drop do´nt exist.


Hello Spydie,
thanks for reply ... but:
Quote:
The most of this errors are duplicated entrys, what means that the tables or entrys already exist.

ip tables are created during the migration process.
error in post import is "+++ Erreur: Unknown column 't.post_text_compiled' in 'field list' " means to me import script asks for a column called t.post_text_compiled which seems not to be present in phpbb2 posts table.

Quote:
Others are drop errors, that tell you that the tables it should drop do´nt exist.

Errors like
# # ALTER TABLE phpbb_registration_desc DROP `reg_option3`  
# +++ Erreur: Can't DROP 'reg_option3'; check that column/key exists
happen on new tables just created by IP during process.

I can send my phpbb2 tables to one developpers ready to make the test ?
Thanks,
André
 



 
avdlSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: From PUNBB 1.2.x To ICP 
 
Quote:

ip tables are created during the migration process.
error in post import is "+++ Erreur: Unknown column 't.post_text_compiled' in 'field list' " means to me import script asks for a column called t.post_text_compiled which seems not to be present in phpbb2 posts table.


IP script converts PhpBB2 tables to IP tables
Quote:

Errors like
# # ALTER TABLE phpbb_registration_desc DROP `reg_option3`  
# +++ Erreur: Can't DROP 'reg_option3'; check that column/key exists
happen on new tables just created by IP during process.
Alter is convert/change table. No new table just created.
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron