https://www.icyphoenix.com/viewtopic.php?f=35&t=6470
-----------------------------------
Markuz Nightwind
Tue 15 Sep, 2009 18:58

Upgrade From PHPBB2
-----------------------------------
Hello, I tried today to move my phpbb3 forum into Icy Phoenix 1.3. I read there is no simple way to do it, so i tought about converting to smf, then to phpbb2 and at last to Icy Phoenix. Basically it works (i don't care about errors with bbcode tags or avatars or password to be reseted) and i have a fully working phpbb2 forum... BUT when i pass it to icyphoenix latest version using the "phpbb upgrade" instructions what i obtain is an empty forum with just topics/posts count but no posts. There are old_phpbb_posts/topics tables in the database but nothing is passed in the phpbb_posts/topics tables.

Any help would be appreciated.

P.S. You can check directly @ http://www.nightwindworld.org/phpbb2/forum.php

Thanks!


-----------------------------------
spydie
Tue 15 Sep, 2009 19:14

Re: Upgrade From PHPBB2
-----------------------------------
try going to ACP-configuration-quick setting´s

select an option and see if the post´s apear afterwards


-----------------------------------
Markuz Nightwind
Tue 15 Sep, 2009 20:34

Re: Upgrade From PHPBB2
-----------------------------------
Hmmm can't even login with my username atm. Tried "forgot password" option and after activating it by mail i still cannot login. Tried to register a new user and got

[quote]Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_users (user_registered_ip, user_registered_hostname, user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_from_flag, user_interests, user_phone, user_selfdes, user_profile_view_popup, user_sig, user_avatar, user_avatar_type, user_viewemail, user_upi2db_which_system, user_upi2db_new_word, user_upi2db_edit_word, user_upi2db_unread_color, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_showavatars, user_showsignatures, user_allowswearywords, user_allowhtml, user_allowbbcode, user_allow_pm_in, user_allow_mass_email, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_time_mode, user_dst_time_lag, user_dateformat, user_posts_per_page, user_topics_per_page, user_hot_threshold, user_lang, user_style, user_gender, user_level, user_allow_pm, user_birthday, user_birthday_y, user_birthday_m, user_birthday_d, user_next_birthday_greeting, user_active, user_actkey) VALUES ('54de79b1', 'host-84-222-121-177.cust-adsl.tiscali.it', 2971, 'Markuz', 1253039213, '83bd5c4e2752887b9fad6c1831021526', 'markuznightwind@gmail.com', '', '', '', '', '', '', '', '', 0, '', '', 0, 0, 0, 0, 0, 0, '', '', '', '', 0, , 1, 1, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, 0, 60, 'F d, Y, h:i:s A', '15', '20', '15', 'english', 1, '0', 0, 1, '5800', '1985', '11', '18', '2009', 1, '')

Line : 1129
File : usercp_register.php[/quote]

Did the convert again... but same thing happens. I'm really going mad :/


-----------------------------------
novice programmer
Tue 15 Sep, 2009 20:39

Re: Upgrade From PHPBB2
-----------------------------------
Have you tried to check the /cache folder?

BTW, can you confirm there are no posts on the DB by using a non phpbb powered/based DB manager?

That forum you are showing us has been downgraded from phpbb3 throught smf or updated from phpbb2?


-----------------------------------
Markuz Nightwind
Tue 15 Sep, 2009 20:43

Re: Upgrade From PHPBB2
-----------------------------------
Using phpmyadmin it shows phpbb_posts (that's icyphoenix current table) with 0 rows while _old_phpbb_posts has 46577. The forum steps were [url=http://www.nightwindworld.org/forum]PHPBB3 => [url=http://www.nightwindworld.org/smf]SMF 1.1 => PHPBB2 => Icyphoenix (using the instructions from homepage). Until PHPBB2 step all was working fine, now with IP errors here and there and no topics/posts :(


-----------------------------------
spydie
Tue 15 Sep, 2009 20:55

Re: Upgrade From PHPBB2
-----------------------------------
check if phpbb_users table exists please

something similar happend to a friend yesterday


-----------------------------------
novice programmer
Tue 15 Sep, 2009 20:58

Re: Upgrade From PHPBB2
-----------------------------------
[quote user="spydie" post="44419"]check if phpbb_users table exists please

something similar happend to a friend yesterday[/quote]

Perhaps it has been a "Server has gone away" without a rollback then?


-----------------------------------
Markuz Nightwind
Tue 15 Sep, 2009 21:04

Re: Upgrade From PHPBB2
-----------------------------------
[quote user="spydie" post="44419"]check if phpbb_users table exists please

something similar happend to a friend yesterday[/quote]

Yeah it's there

[quote]phpbb_users  	860Rows  	MyISAM  	256,8 KiB  	-[/quote]

Tried again "forgot password" to reset it and it still goes with
[quote]You have specified an incorrect or inactive username, or an invalid password.[/quote]

If i try to register a new user, still the same

[quote]Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_users (user_registered_ip, user_registered_hostname, user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_from_flag, user_interests, user_phone, user_selfdes, user_profile_view_popup, user_sig, user_avatar, user_avatar_type, user_viewemail, user_upi2db_which_system, user_upi2db_new_word, user_upi2db_edit_word, user_upi2db_unread_color, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_showavatars, user_showsignatures, user_allowswearywords, user_allowhtml, user_allowbbcode, user_allow_pm_in, user_allow_mass_email, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_time_mode, user_dst_time_lag, user_dateformat, user_posts_per_page, user_topics_per_page, user_hot_threshold, user_lang, user_style, user_gender, user_level, user_allow_pm, user_birthday, user_birthday_y, user_birthday_m, user_birthday_d, user_next_birthday_greeting, user_active, user_actkey) VALUES ('54de79b1', 'host-84-222-121-177.cust-adsl.tiscali.it', 2971, 'Markuz', 1253041470, '83bd5c4e2752887b9fad6c1831021526', 'markuznightwind@gmail.com', '', '', '', '', '', '', '', '', 0, '', '', 0, 0, 0, 0, 0, 0, '', '', '', '', 0, , 1, 1, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, 0, 60, 'F d, Y, h:i:s A', '15', '20', '15', 'english', 1, '0', 0, 1, '999999', '0', '0', '0', '0', 1, '')

Line : 1129
File : usercp_register.php[/quote]

 :(  :(


-----------------------------------
novice programmer
Wed 16 Sep, 2009 00:06

Re: Upgrade From PHPBB2
-----------------------------------
Phpbb3 series uses a different password engine than phpbb2 series, becase of the advantage of adding salt to the MD5 password hash. Perhaps converting from phpbb3 to smf and to phpbb2 did not revert correctly the MD5 salting. Try checking your MD5 hash (the stored password) on the DB is what it should be ;) . It should have no slts on it, so there are many tools that will give you the plain hash you need to check for.

Probably doing the downgrade to smf did not make the login cookie useless, so you could interact besides you could not login again with user/password.


-----------------------------------
Markuz Nightwind
Wed 16 Sep, 2009 10:55

Re: Upgrade From PHPBB2
-----------------------------------
Yeah i know that, but it doesn't explain why the password recover (that should reset it, with the correct salt) doesn't work. Anyway it seems related to the new 1.5.0.53a patch, without that as far as i can see it works. Still i have no posts or topics converted and wonder why. Will try to manually join the old_phpbb tables to the icyphoenix one...

Thanks for the fast answers btw, I appreciated it :)

Edit: Manually imported all posts, fixed 90% of broken bbcodes etc etc. Now another problem comes up, activating Forum [News] block the following error comes up @ homepage

[quote]Fatal error: Call to undefined method stdClass::parse() in /web/htdocs/www.nightwindworld.org/home/phpbb/fetchposts.php  on line 92[/quote]

Any clue on that?

P.S. www.nightwindworld.org/phpbb


-----------------------------------
novice programmer
Wed 16 Sep, 2009 22:55

Re: Upgrade From PHPBB2
-----------------------------------
If you do have time, get bazaar and download the source code for 1.2 latest stable from lp:/icy-phoenix/1.2-stable

I do not know of any issues with the converter at that version.

Then upgrade to 1.3.

That repo is about 100 MB of size and if contains copies of all the 1.2 files on the website. But it is not longer supported, so upgrade to 1.3 when you get to work 1.2 (if you manage to)

If you are intrested on this and if you need help n order to get bazaar or to get the contents just post the issues and your OS if it is a bazaar download/install issue


