Converting phpnuke forum - > SMF

[russ]

I have been using phpnuke for sometime now and its time to move on to something better. But I would like to keep my original posts and member data (ie usernames and passwords and profile) only and use this in the new forum setup already. Is there any way of doing this?

Many thanks in advance.

(

Current forum info from phpnuke

Module Copyright © Information
Forums module for PHP-Nuke


Module's Name: Forums
Module's Version: 2.0.6
Module's Description: phpBB 2.0.6 port by NukeCops
License: GNU/GPL
Author's Name: Nuke Cops
Author's Email: [email protected]
)

[[Unknown]]

Have you tried the phpBB converter?

-[Unknown]

[russ]

will that work with phpnuke tho? phpbb has been adapted for phpnuke i would think. i might be wrong tho

[russ]

i read somewhere the SMF forum has to be empty for t his process to be sucessful... is that true?

[[Unknown]]

i read somewhere the SMF forum has to be empty for t his process to be sucessful... is that true?

No, but it will be emptied, I'm afraid.

-[Unknown]

[russ]

if i were to backuo the SMF files and then let it overwrite teh forum, could i then add the original data/posts back in to the converted forum data?

[[Unknown]]

I'm afraid not... the posts and other data is stored in the database, with numeric indexes... and it's not that simple .

-[Unknown]

[russ]

ah ok no worries. thanks for helping - il try the phpbb converter on a test database and see what happens.

[russ]

Just wondering if there was anyone i could pay (via paypal) to make the upgrade for me?

I am willing to pay good money for it to be done

[russ]

still wondering if anyone would like to be paid to upgrade a phpnuke forum to a smf forum

it is quite essential

Many thanks

[Cyber Freak]

I tried to convert my PHP Nuke (phpbb) board to SMF but it does not work..
i used your phpbb2_to_smf.php.   

[df3rry]

I managed to get the phpBB to SMF converter working for phpBB on phpnuke.
The problem is the user table used in phpnuke which doesn't work with the $from_prefix used to migrate the rest of the tables.
All I did was manually change the reference to the user table to the actual location of the table:
    smf.nuke_users instead of $from_prefix.users   (being smf the database name)

I also manually set the dbname and table prefix to the actual names used:
$dbname ='smf';
$table_prefix ='nuke_bb';

And thats it!!
I don't know if this can help anybody else but it worked ok on a 500+ message test site.

[Jae]

I am also trying to convert a PHP-Nuke forum to SMF, with no success so far.  Here are the messages I'm getting from the converter when I run it:

Notice: Undefined variable: dbname in /var/www/testlab/SMF/phpbb2_to_smf.php on line 121

Notice: Undefined variable: table_prefix in /var/www/testlab/SMF/phpbb2_to_smf.php on line 121

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 215

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 303
Converting members...
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 458

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 459

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 477

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 491

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 524
successful.
Converting additional member groups...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 621

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 655
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 721

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 731
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 827

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 843
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 927

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 937
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1025

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1038
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1114

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1124
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1194

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1204
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1273

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1283
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1358

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1368
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1437

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1447
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1517

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1527
successful.
Converting board access...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1587

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1755
successful.
Converting group access permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1802

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1887
successful.
Copying avatar image files...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1918

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1919
successful.
Converting censored words...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1968

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 1973
successful.
Converting reserved names...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2016

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2018
successful.
Converting ban list...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2057

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2097
successful.
Converting misc settings...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2125

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2211

Notice: Undefined variable: phpbb_forum_name in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2214

Notice: Undefined variable: phpbb_admin_email in /var/www/testlab/SMF/phpbb2_to_smf.php on line 2215
successful.
Recalculating forum statistics... successful.

My coding knowledge is next to zip - can anyone help with this?

Thanks in advance!   

[Oldiesmann]

Make sure that those two are either running on the same database or that the same MySQL user has access to both databases.

[Jae]

I'm using two different databases for the PHP-Nuke forums and the SMF forums.  The MySQL user does have access to both databases.  Maybe I should try re-installing SMF and point it to the PHP-Nuke database?

[Grudge]

Ummm... are you *sure* you are running it in the same directory as your SMF forum? Looks to me like Settings.php isn't in the same directory, or is otherwise not complete.

[Jae]

No, it's not in the same directory.  I'm running the SMF site on a sub-domain as a test site.  The site owner hasn't decided whether or not she wants to switch to SMF yet, so I was trying to let her see what it would look like.

Do I need to install SMF in the same directory as PHP-Nuke to make this work?

[Oldiesmann]

Yeah. Installing SMF in the php-nuke database will work just fine.

[Jae]

I think I need some clarification.

The database for the PHP-Nuke installation is called a-larger-world_com_-_1.  I've reinstalled SMF and entered this database as the one being used for SMF, with a table prefix of smf_.  I'm still getting the same error messages as before.

The Forums module for PHP-Nuke is found in the directory /var/www/html/modules/Forums.  Do I need to have SMF installed in this directory as well?  Right now, it is in the directory /var/www/html/smf.

I apologize for my cluelessnes on this.  I use SMF on my site, and I've never had any trouble with installations or administration or anything else I need to do with it.  I love it, and am trying to get the owner of this site to switch over.

[packman]

SMF and the phpnuke forum software should be in different directories. The ones you've used seem reasonable. It's the SMF tables and other forum tables that need to be in the same database. Again, you seem to have done this and the default smf_ is a reasonable table prefix to use.

I assume the user you're running the converter from has at least read access to the phpnuke directory structure and read-write access to the SMF directory structure?

Also, the phpnuke forum is based on phpBB2, but how close is it to the standalone 'real' phpBB2. The converter might be having problems because the phpnuke forum is slightly different, e.g. it doesn't store its settings in Settings.php, or the Settings.php file is stored in a different directory, or has a subtly different format/structure?