Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: mr.bobo on May 17, 2004, 12:10:58 PM

Title: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 12:10:58 PM
I'm getting the following error when trying to convert.


phpBB2 to SMF Converter
Converting...
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 296
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 401

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 411
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 492

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 502
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 586

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 596
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 684

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 694
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 770

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 780
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 850

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 860
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 929

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 939
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1014

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1024
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1093

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1103
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1173

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1183
successful.
Recalculating forum statistics... successful.
Conversion Complete



Any ideas?
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 17, 2004, 02:19:05 PM
Make sure you've still got all your phpBB tables and have entered the correct path for both phpBB and SMF. You also need to make sure you install SMF before you try to convert.
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 02:34:29 PM
the forums are setup http://newforums.dumpsterworld.com is SMF, and http://www.dumpsterworld.com is PHPBB.  The PHPBB is still working so I assume that all my tables work.  I'm 99.9% sure the paths are correct /home/dumpster/public_html/newforums and /home/dumpster/public_html/ for SMF, PHPbb respectively.  Got any ideas?

Thanks in advance.

-Bob
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 17, 2004, 02:59:29 PM
Are you sure you entered the correct database prefix for phpBB? Also, are SMF and phpBB running on the same database?
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 03:07:18 PM
(http://mrbobo.net/uploaded/screenshot.GIF)
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 17, 2004, 03:13:38 PM
Ok. That's what's causing the problem. The convertor assumes that the two boards are running on the same database. Upload install.php and re-install SMF on the dumpster_forums database. Then run the convertor again and it should work fine.
Title: Re: PHPBB to SMF Problems
Post by: [Unknown] on May 17, 2004, 03:39:31 PM
No, it doesn't.  But, it does assume that the users for each have access to each...

-[Unknown]
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 06:03:16 PM
Sorry for being a pain but I did what Oldies said, and reinstalled using the same DB as phpbb, but now I get this :

phpBB2 to SMF Converter
Converting...
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 296
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 401

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 411
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 492

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 502
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 586

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 596
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 684

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 694
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 770

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 780
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 850

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 860
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 929

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 939
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1014

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1024
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1093

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1103
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1173

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1183
successful.
Recalculating forum statistics... successful.

Conversion Complete
Congratulations, the conversion has completed sucessfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the phpBB2 installation.

We hope you had a smooth transition,

Simple Machines
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 17, 2004, 06:19:50 PM
I have no idea what to tell you. For some reason it can't seem to find the tables you need or something...
Title: Re: PHPBB to SMF Problems
Post by: [Unknown] on May 17, 2004, 06:23:22 PM
This is probably caused by strange characters in your database name.  Please try changing, temporarily, your database name to:

`whatever it is`

Note the backticks - it's the key next to 1 on your keyboard. (it must be that type of quote!)  After conversion, please try changing the database name back.

It will have to be changed in both phpBB and SMF.  Again, this has been solved in the working copy and will not be neccessary for the next release.

-[Unknown]
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 07:12:20 PM
Sorry for asking such a dumb questions, but how do I change the DB name?  Thanks so much for all your help so far it's been much appreciated and I'm looking forward to using SMF.
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 17, 2004, 07:16:15 PM
Edit config.php (for phpBB) and Settings.php (for SMF).
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 07:23:12 PM
Ok, but how do I change the actual name of the DB so all the settings are transfered over to the new one?

Thanks,

Bob
Title: Re: PHPBB to SMF Problems
Post by: [Unknown] on May 17, 2004, 08:05:09 PM
Don't worry; SMF supports database names with strange characters in them - the problem is only the converter.  If you just add `s to both sides of the name in them, it will work properly and then you can change it back without any problems.

-[Unknown]
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 17, 2004, 09:56:08 PM
ahh, sorry I misunderstood you ok, I'll give that a try and post back here with the results.
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 18, 2004, 09:47:31 AM
Quote from: [Unknown] on May 17, 2004, 08:05:09 PM
Don't worry; SMF supports database names with strange characters in them - the problem is only the converter.  If you just add `s to both sides of the name in them, it will work properly and then you can change it back without any problems.

-[Unknown]

Where exactly do I enter the ` s?

Sorry,

Bob
Title: Re: PHPBB to SMF Problems
Post by: Eris Siva on May 18, 2004, 11:53:08 AM
I got this same issue when trying to convert. Now that you've explained it-I understand.

Is it possible to just have it (the script) to install to a specified database so that this problem doesn't occur?
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 18, 2004, 12:25:05 PM
adonis think you could explain it to me?  I'm still not understanding exactly what must be done.
Title: Re: PHPBB to SMF Problems
Post by: Eris Siva on May 18, 2004, 03:21:38 PM
As far as I can tell, you would put the backticks in the config files and also in your SQL database (prob. using phpMyAdmin), but around your database name.

For example:

smartmachines_database

becomes

`smartmachines_database`



Is that it?
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 18, 2004, 03:37:19 PM
maybe I should just wait for the next release, I can't seem to figure out how to change the DB name... :( when will the next release be out?
Title: Re: PHPBB to SMF Problems
Post by: Grudge on May 18, 2004, 04:53:22 PM
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;
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 18, 2004, 05:32:09 PM
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
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 18, 2004, 11:15:57 PM
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.
Title: Re: PHPBB to SMF Problems
Post by: Grudge on May 19, 2004, 04:43:24 AM
I've offered to help Mr.bobo via pm to convert his forum.
Title: Re: PHPBB to SMF Problems
Post by: Oldiesmann on May 19, 2004, 12:51:24 PM
Ok. Thanks Grudge.
Title: Re: PHPBB to SMF Problems
Post by: mr.bobo on May 21, 2004, 09:36:55 PM
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

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

Thanks,

-Bob
Title: Re: PHPBB to SMF Problems
Post by: Grudge on May 23, 2004, 04:10:19 PM
Good to see you got the database issue resolved! Glad you're happy!
Title: Re: PHPBB to SMF Problems
Post by: jjgarza70 on December 07, 2004, 10:36:51 PM
QuoteHi 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

Quote




thanks for the help
Title: Re: PHPBB to SMF Problems
Post by: [Unknown] on December 07, 2004, 10:38:46 PM
Please try using the same database and user for both phpBB and SMF.

-[Unknown]
Title: Re: PHPBB to SMF Problems
Post by: jjgarza70 on December 08, 2004, 12:00:57 AM
the databases have the same same except the extension name..

so that's not it...

thanks
Title: Re: PHPBB to SMF Problems
Post by: [Unknown] on December 08, 2004, 01:10:35 AM
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]
Title: Re: PHPBB to SMF Problems
Post by: jjgarza70 on December 08, 2004, 09:32:19 AM
Yep..

My PHPBB old forum works just fine,  www.euforia2u.com/joegarza/  the newly created forum www.euforia2u.com/utopia/ 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
Title: Re: PHPBB to SMF Problems
Post by: Grudge on December 08, 2004, 09:47:23 AM
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"
Title: Re: PHPBB to SMF Problems
Post by: jjgarza70 on December 08, 2004, 10:34:03 AM
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 
Title: Re: PHPBB to SMF Problems
Post by: Grudge on December 08, 2004, 10:41:52 AM
You can actually probably ignore those. It's because Settings.php isn't chmod to 777 I expect