phpBB2phpNuke

[GregD]

[Evaders99]

Need to compare the following tables to make sure they match. If necessary, drop the phpBB fields for those mods

[Alan]

I have the same issue as mads and gregd.

This is a new install of 7.9. I upgraded the forums through all the updates individually.

ie; upgrade17-18.php then upgrade18-19.php and so on up till version up to phpbb version 2.0.22

mysql version is 4.0.22-standard
php version is 4.4.4

I have a phpbb version 2.0.22 that I did a database backup of, I then did a restore to the phpnuke database - which ran successfully.

I then ran phpbb2phpnuke.php and get the following...

Dumping previous phpNuke users data


Inserting phpBB users data into phpNuke


Updating phpNuke users user_level


Updating phpNuke users user_regdate


Dumping previous forums data


Reseting phpNuke bad banlist table structure (Not critical, don't worry if errors)
Error reseting phpNuke bad nuke_bbbanlist table structure - Can't DROP 'ban_time'. Check that column/key exists


Reseting phpNuke bad ranks table structure (Not critical, don't worry if errors)
Error reseting phpNuke bad nuke_bbranks table structure - Can't DROP 'rank_max'. Check that column/key exists


Inserting phpBB forums data into phpNuke
Error inserting data from phpbb_auth_access to nuke_bbauth_access - Column count doesn't match value count at row 1
Error inserting data from phpbb_forums to nuke_bbforums - Column count doesn't match value count at row 1
Error inserting data from phpbb_posts to nuke_bbposts - Column count doesn't match value count at row 1
Error inserting data from phpbb_privmsgs to nuke_bbprivmsgs - Column count doesn't match value count at row 1
Error inserting data from phpbb_topics to nuke_bbtopics - Column count doesn't match value count at row 1


Reseting phpNuke default_style


Reseting phpNuke smilies path


Reseting phpNuke anonymous posts


Reseting gzip compress settings


Emptying phpNuke session data


I checked the tables as you stated and the phpbb tables have the restored (correct) information in them, the corrolating nuke files do not.

Thanks,
Alan

[Alan]

I re-read you comment about checking the fields of those tables and they were not the same. All the phpbb tables had and additional field of either attachment or download. I did at one time have the attachment mod in the original phpbb and suspect this is where the additional fields came from.

After droping those fields from the phpbb tables everything seemed to work fine.

Thanks for a great conversion tool!
Alan

[GregD]

Yes, i dropped the tables causing the issue and the data was migrated without an issue.

It seems the conversion hates mods!

[Evaders99]

Glad you got it working

Really this script is designed to be simple and fast. It is not designed to be complicated.. as such

[sixu]

hey, I seem to be having a problem converting too..

I have phpbb 2.0.22, is this compatible?

each time i attempt to convert, i get the following:

Please check your phpNuke prefix settings in phpbb2phpnuke_config.php

[Evaders99]

Looks correct to me, did you load up the Nuke tables and phpBB tables in that database?
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

[talonj]

I'm running a standalone phpBB 2.0.22 forum and just installed a PHP-Nuke 8.0 site also running phpBB 2.0.22. I exported all tables and data from phpbb and imported them into the Nuke database. I ran phpbb2phpnuke.php script and all went well, no errors. I then deleted all phpbb_ tables within my Nuke database. I completed the forum configuration. I tried to login and get the following error:

[Evaders99]

See: http://evaders.swrebellion.com/forums/postt55.html
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

[talonj]

Thus far everything seems to be running smooth. Import went fine and conversion showed no errors. I do have a user that is active in forum that tries to login as [DIE]-Piano and receives a white screen with Illegal username...

Any ideas what to search for?

[Evaders99]

phpNuke does use some filters for usernames. There is some code in the Your_Account module that does this

Depending on your version / Patched level, this code may be different
Look in modules/Your_Account/index.php

[talonj]

Evaders99,

Worked like a charm. Greatly appreciate the script and the assistance with making this transition seamless.

As far as the filters for usernames, is there some location that shows how to properly enter these characters into modules/Your_Account/index.php ??

[Evaders99]

Hmm well, you'd have to look up some basics on Regular Expressions. I don't know them well at all either.
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

[chrisbeau]

Ive been using phpbb 2.0.22 for the last couple of months, and just uploaded the 7.9 nuke version (done nothing else)

And then uploaded this converter, Ive entered the settings which I took from the phpbb config file