converted from phpbb forums to vb

[Cindy Coutts]

i have successfully upgraded the forums from phpbb to vb trying to run the userfix because images are showing up in the wrong users galleries (even though the user id's are the same on both pp and vb)

i emptied the pp usergroup table as it says in a post i found, ran the install script to change the info to point to the vb database

when i run userfix i get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/photozo/public_html/album/forums/vb3.php on line 32

from what i have read its a issue with the config-inc.php not being set right but they are

would it matter if phpbb and pp were both in the same db and now vb and pp are in different db's?

[Chuck S]

vBulletin Installation/Integration Common Issues and Resolutions.

Check out number 5 it would appear the database for vb is incorrect or most likely you have forgotten to enter the proper table prefix for vbulletin on step 4 of the install. rerunning install and entering the proper info will solve that then you can run userifx.php

[Cindy Coutts]

i dont have a table prefix for the vb forum but i will go ahead and retry to install

[Chuck S]

Okay well then that means the database info you entered for the user database on the config is incorrect to connect to and find the vb tables.

[Cindy Coutts]

// PhotoPost's
$database="photozo_com";
$mysql_user="photozo_peng";
$mysql_password="editedout";

$database_bb="photozo_com2";
$user_bb="photozo_com2";
$password_bb="editedout";

//vb's config
$config['Database']['dbname'] = 'photozo_com2';
$config['MasterServer']['username'] = 'photozo_com2';
$config['MasterServer']['password'] = 'editedout';

i have edited out the pw but i have double checked them sevreal times

[Chuck S]

If you have those details entered and it still tells you the table can not be found you most definately have a table prefix on your vb database.

[Cindy Coutts]

but it doesn't say a table can't be found

[Cindy Coutts]

vb config file
$config['Database']['tableprefix'] = '';

pp config file
$pp_db_prefix = "";

[Cindy Coutts]

see my problem is not that the userid's dont match up because they do

see attached image you will see that it's sammie's user gallery (top left) but when you look at the images it says users jiml

[Cindy Coutts]

could it have anything to do with the forums and gallery being turned off?

[Chuck S]

What is this site?

I am simply referring to information based on your error

Content visible to verified customers only.

[Cindy Coutts]

Digital Photography Photozo Forums

[Chuck S]

Your install is closed you would need to open it for me to see it but if you get the error your posting it has to be a database or table prefix issue.

[Cindy Coutts]

opening now

[Chuck S]

Looks fine to me in fact I only got that error for about 10 or so photos and that would most likely be a result of a user not existing in the forum.

[Cindy Coutts]

look here Elements from the Port Museum in Rotterdam (2005) - Members Gallery

[Chuck S]

DavidFox Gallery - Members Gallery

Those are albums owned by a user. I dont beleive albums are reassigned using the userfix script not something I even considered since changing integrations is not something we openly suggest. I released that little tool after users started doing that.

try redownloading the script and running the change album owners thing as I added something that might help.

[Cindy Coutts]

after restoring the db

the user id fix still wont work for me and the album fix messed up the galleries by listing each one on the index page making the gallery very slow as it loads up everything on one page...

[pengrus]

Chuck,

We have just ordered an Installation Service as you suggested in another thread. The order number is techimo-20812.

Please let me know what you need to help us. I'll let Cindy assist you as she helped us with phpbb to vB switch.

Thank you!

[Chuck S]

Well they will let me know when they process the order there is an install to do and any questions I will let you know