Icy Phoenix

Old Support Topics - Upgrade From PHPBB2

Markuz Nightwind [ Tue 15 Sep, 2009 18:58 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: 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

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

novice programmer [ Tue 15 Sep, 2009 20:39 ]
Post subject: 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 ]
Post subject: 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 PHPBB3 => 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 ]
Post subject: 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 ]
Post subject: Re: Upgrade From PHPBB2

spydie wrote: [View Post]
check if phpbb_users table exists please

something similar happend to a friend yesterday

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

Markuz Nightwind [ Tue 15 Sep, 2009 21:04 ]
Post subject: Re: Upgrade From PHPBB2

spydie wrote: [View Post]
check if phpbb_users table exists please

something similar happend to a friend yesterday

Yeah it's there

Quote:
phpbb_users 860Rows MyISAM 256,8 KiB -

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.

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

novice programmer [ Wed 16 Sep, 2009 00:06 ]
Post subject: 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 ]
Post subject: 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

Any clue on that?

P.S. www.nightwindworld.org/phpbb

novice programmer [ Wed 16 Sep, 2009 22:55 ]
Post subject: 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