PHPBB to SMF Problems

[Grudge]

Sorry... he means in the converter files find the line that starts:

$to_prefix = ... <more stuff here>

and set it to:
   $to_prefix = '`' . $db_name . '`.' . $db_prefix;

(not the ` additions)

then find:

   $from_prefix = .. <more stuff here>

and make that line:
   $from_prefix = '`' . $dbname . '`.' . $table_prefix;

[mr.bobo]

I modified my converter file and it's still not working could someone modify it for me maybe, and send it to you me?  I may be doing something wrong, my e-mail is [email protected]

Thanks,

Bob

[Oldiesmann]

Grudge - that's actually quite a bit more complicated than it needs to be.

Bob - upload a clean copy of the phpbb convertor file to your server, then edit config.php (for phpBB) and Settings.php (for SMF) and add ` marks to that database name. (ie 'database_name' becomes '`database_name`'). Try it from there and see if that works.

[Grudge]

I've offered to help Mr.bobo via pm to convert his forum.

[Oldiesmann]

Ok. Thanks Grudge.

[mr.bobo]

Just wanted to say a HUGE thank you to everyone here for helping me out.  Thanks to the modified converter, and a quick e-mail to my host about my DB, I'm up and running!

http://www.dumpsterworld.com [nofollow]

I look forward to the future of this software it's great!

Thanks,

-Bob

[Grudge]

Good to see you got the database issue resolved! Glad you're happy!

[jjgarza70]

Hi Guys...

I am also trying to convert from Phpbb to SMF however I came across the following errors...

does anyone has an idea how to fix these...

thanks... (I already tried to insert the  ` but I get  a "Secirity Warning Shell Error "

here's what am getting

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 215

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 303
Converting members...
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 458

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 459

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 477

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 491

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 621

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 655
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 721

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 731
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 827

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 843
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 927

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1025

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1038
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1114

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1194

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1273

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1358

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1437

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1517

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1587

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1802

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1918

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1919

Warning: copy(/home/euforia2/public_html/utopia/avatars/index.php): failed to open stream: Permission denied in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2961
successful.
Converting censored words...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 1968

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2016

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2057

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/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 /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2125

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2211

Notice: Undefined variable: phpbb_forum_name in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2214

Notice: Undefined variable: phpbb_admin_email in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 2215

thanks for the help

[[Unknown]]

Please try using the same database and user for both phpBB and SMF.

-[Unknown]

[jjgarza70]

the databases have the same same except the extension name..

so that's not it...

thanks

[[Unknown]]

I'm sorry, but the error messages you received clearly indicate a permission issue with the MySQL accounts being used.  For whatever reason, the converter cannot access either the destination tables or the source tables from the user set up with SMF.

I assume both forums work fine independently?

-[Unknown]

[jjgarza70]

Yep..

My PHPBB old forum works just fine,  www.euforia2u.com/joegarza/ [nofollow]  the newly created forum www.euforia2u.com/utopia/ [nofollow] works ok, exept that its empy due to not able to convert from phpbb

here's the config and settings variables

config.php

$dbname = 'euforia2_xmb1';
$dbuser = 'euforia2_xmb1';


here's settings.php

$db_server = 'localhost';
$db_name = 'euforia2_smf1';
$db_user = 'euforia2_smf1';

can you tell me what I am doing wrong?


both databases are in the same server and I use Cpanel to access them as well


and these are my paths for the databases


path to smf :  /home/euforia2/public_html/utopia

path to phpbb: /home/euforia2/public_html/joegarza



thanks..

Joe

[Grudge]

Yes, using cpanel give the user called smf1 access to the database called xmb1. The database names are different so you need to ensure the user can see the xmb1 database. This is quite easy from the "MySQL database" link in cpanel, it's in a section called "Add User To Database"

[jjgarza70]

all right ..

Most of the forum has been transfered, however I still have some errors...

Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Converting board access... successful.
Converting group access permissions... successful.
Copying avatar image files... successful.
Converting censored words... successful.
Converting reserved names... successful.
Converting ban list... successful.
Converting misc settings...
Warning: fopen(/home/euforia2/public_html/utopia/Settings.php): failed to open stream: Permission denied in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3012

Warning: fclose(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3013

Warning: fopen(/home/euforia2/public_html/utopia/Settings.php): failed to open stream: Permission denied in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3016

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3022

Warning: fclose(): supplied argument is not a valid stream resource in /home/euforia2/public_html/utopia/phpbb2_to_smf.php on line 3023
successful.
Recalculating forum statistics... successful.


thanks 

[Grudge]

You can actually probably ignore those. It's because Settings.php isn't chmod to 777 I expect