Upgrading: ubb.Threads --> vBulletin

[jeffro88]

Hey guys,

I've been running PhotoPost 3.2 (Old, I know) with ubb.threads as my forum for a few years now. I recently upgraded my forums to vBulletin and am now wanting to upgrade my PhotoPost to the latest version so I can have the compatibility and full integration with vB 3.5.

What process should I do to ensure that all of my data/photos from my current (3.2) PhotoPost doesn't get lost while upgrading to the new PP? Thanks in advance for the suggestions.

Jeff
CustomTacos.com

[Chuck S]

Okay here is the steps needed.

1 Upgrade your photopost first to the latest version.

a. you have not stated whether you already switched photopost to use vb3 integration??

Basically you edit your config file with the proper vbulletin database info and vb license number. You can use phpmyadmin to view the settings table setting 41 and 83 to input vb3 as your integration type and input if used the proper table prefix for vbulletin and clear your w3t_ out of there. You then in phpmyadmin delete all other usergroups in the usergroup table except admin which you change the groupid from 1 to 6 which represents the vb admin. This will give you admin access where you can reimport the vb usergroups

Then go on to step 2

2. After upgrading Photopost to the latest version and successfully integrating it with vb3 you would need to run this script to realign the userid
s as the vb impex importer changes userid's for users on import

Reassign userid's when switching integrations to VBulletin

[jeffro88]

Originally Posted by Chuck S

Okay here is the steps needed.

a. you have not stated whether you already switched photopost to use vb3 integration??

No, I haven't switched anything in Photopost yet. Been kinda scared to do so.

Thanks for taking the time to explain that so thoroughly. I'll give it a shot in the next few days. Seems pretty straight forward, but I'll definitely back everything up before I start.

Thanks again!

Jeff

[steffonator]

Originally Posted by Chuck S

Then go on to step 2

2. After upgrading Photopost to the latest version and successfully integrating it with vb3 you would need to run this script to realign the userid
s as the vb impex importer changes userid's for users on import

Reassign userid's when switching integrations to VBulletin

That was just what I was looking for. Does it work for Classifieds 2.42? Would be great if it does.

Thanks
S

[Chuck S]

well you need to change the script as far as the table it updates as it updates the photos table. In classifieds it is the products table

[steffonator]

Doesn't work for me, my httpd error log is filled with this

[Wed Dec 21 23:40:02 2005] [error] PHP Notice: Undefined variable: action in /home/html/se.surfzone/public_html/pp/import.php on line 85
[Wed Dec 21 23:40:02 2005] [error] PHP Notice: Undefined variable: action in /home/html/se.surfzone/public_html/pp/import.php on line 17
[Wed Dec 21 23:40:02 2005] [error] PHP Notice: Undefined variable: action in /home/html/se.surfzone/public_html/pp/import.php on line 19
[Wed Dec 21 23:40:02 2005] [error] PHP Notice: Undefined variable: action in /home/html/se.surfzone/public_html/pp/import.php on line 52
[Wed Dec 21 23:40:02 2005] [error] PHP Notice: Undefined variable: action in /home/html/se.surfzone/public_html/pp/import.php on line 85

[Chuck S]

It was written for photopost. I am merely stating the difference would be to alter the photos query to products

[steffonator]

I get those errors when I try with PhotoPost.

[Chuck S]

When you run the script does anything happen? We are talking this one right

Reassign userid's when switching integrations to VBulletin

As long as you fill in the proper database info for vb and photopost your userid's will be updated in photopost. Many people have used this script with no issue.

You will see on screen like this

importing(blah)importing(test)importing(fuzzy) and so on

[steffonator]

That is the one I'am using. The script is doing something but no output on screen. I pull the header from vB, can that be a problem?

[steffonator]

I have updated the script to use a database other than localhost.
PP and vB uses the same database.

$vb_db = "cust_steffo_vb351";
$photopost_db = "cust_steffo_vb351";
$host = "db.webbplatsen.se";
mysql_connect($host,$vb_user,$vb_pass);

[Chuck S]

You need to fill out the database info on both parts. This script doesnt call any vb header

[steffonator]

Of course

// Vbulletin database information goes here
$vb_db = "cust_steffo_vb351";
$vb_user = "steffo_user";
$vb_pass = "somepwd";
$vb_prefix="vb_";
$host = "db.webbplatsen.se";

// Photopost database information goes here
$photopost_db = "cust_steffo_vb351";
$photopost_user = "steffo_user";
$photopost_pass = "somepwd";
$pp_prefix = "pp_";

The url changes to http://someurl/import.php?action=update_comments

[Chuck S]

Right and you should see some printing on screen?

Can't really say anything more since you edited the file. The hack that I included was written only for localhost which means if you had to place a $host statement make sure you replaced localhost twice in that file

[steffonator]

I moved the database to another server to be able to use localhost but no change. Can it be something with the javascript. The load on my PC goes up about 30%

[Chuck S]

The java is simply a forward page command to refresh and do the next page

It is a simple connection to a database to grab userid's based on username and reset all userid's on the photopost tables after you switch integration to vb.

Let me take a stab here. You have register globals off on your server. Try adding this to the top of the file

$action = $_GET['action'];

[steffonator]

Thanks, that was it. I will try to do the same for ppc later.

[steffonator]

I'am not able to make this to work with Classifieds.
The comments are ok but the rest isn't.
Can you help me?

[Chuck S]

Sorry it is not written for classifieds and will not work since the userid is needed on the files. This is why it says this script is only for photopost 5

Basically if you switch integrations you might need to write a script to check your old forum users table and make the new forum user table userid the same as the old one.

[steffonator]

Ok, well the classifieds section will heal over time