Upgrade from 4.01 to 4.82

[XtReMaTriX]

OK, I was forced to update my vB from 2.2.8 to 3.0.3 because of a security hole that was exploited. Once that happend Photopost stopped working (nobody could login).

Now I have just purchased member access to photopost, ran the upgrade scripts on photopost from 4.0.1 to 4.8.2.

So far I have only run upgrade40.php and up. Now I am stuck, I dont know what to do next. I get errors when clicking on some if the images in the gallery, but not all AND I am still not able to login.

Could someone please help me with the next steps i should be doing.

Here is one of the errors i get when clicking on a thumbnail:

MySQL error reported!

Script: showphoto

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,u.signature FROM user u LEFT JOIN userfield uf ON uf.userid=892 LEFT JOIN session s ON s.userid=892 WHERE u.userid=892 LIMIT 1

Result: Unknown column 'u.signature' in 'field list'

Database handle: Resource id #8

[Chuck S]

Hello you need to tell Photopost it is using VB3. You can go into the photopost settings table and change line 41 which says vb2 to vb3.

You might want to read the VB3 Integration FAQ at the top of the Install forum as there is some other stuff to do.

[XtReMaTriX]

Originally Posted by omegatron

Hello you need to tell Photopost it is using VB3. You can go into the photopost settings table and change line 41 which says vb2 to vb3.

You might want to read the VB3 Integration FAQ at the top of the Install forum as there is some other stuff to do.

I ran the convert.php and now I have this error when I try to pull up the gallery:

MySQL error reported!

Script: index

Query: SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,membergroupids FROM ppp_user WHERE username=''

Result: Table '<database_name>.ppp_user' doesn't exist

Database handle: Resource id #8

I have tried using the database that my forums are in, and i have tried using the database that photopost is in... I get the same error for both. The ppp_user table does exist in the photopost database but not the forum database... What should I do now???

[Chuck S]

I beleive you put the wrong prefix for your VB when you did the convertor script

Line 83 of your settings table in Photopost should read the prefix for your VB tables not ppp_

[XtReMaTriX]

Originally Posted by omegatron

I beleive you put the wrong prefix for your VB when you did the convertor script

Line 83 of your settings table in Photopost should read the prefix for your VB tables not ppp_

Much better, BUT i still have a problem. When I attempt to login it says successful but I dont actually get to login. I cant get into the admin section and at the bottom it still says 1 unregistered user browsing...

[Chuck S]

Reading the VB3 Integration FAQ look at the cookie settings part. This has to do with cookies.

Your cookies must match up between the products and your VB license must be entered in the photopost config.

[XtReMaTriX]

I have matched all the cookie settings. I am looking at the cookie created from photopost and the cookie created by vbulletin. What values should be the same?

The domain is showing up as the same, the bbpassword is the same... bbuserid is the same, the number under the domain is the same. I dont know what else I need to do to make this thing work.

[Chuck S]

You can PM me an admin user and site url

Are you using the VB login or Photopost? Looks to me like your using VB If photopost sayd unregistered your not getting a cookie created.

[XtReMaTriX]

Originally Posted by omegatron

You can PM me an admin user and site url

Are you using the VB login or Photopost? Looks to me like your using VB If photopost sayd unregistered your not getting a cookie created.

sent...

[Chuck S]

Looks to me like you never told Photopost your using VB3

What is line 41 set to in your photopost setting table in mysql?

It should read vb3 not vb2

[XtReMaTriX]

Originally Posted by omegatron

Looks to me like you never told Photopost your using VB3

What is line 41 set to in your photopost setting table in mysql?

It should read vb3 not vb2

It says this:

41 User Registration System vbversion vb3 12 1

[Chuck S]

Ok send me your VB license out of the admincp/index.php file and your config file by email to chuck@photopost.com. Let me see what you have there

[XtReMaTriX]

Originally Posted by omegatron

Ok send me your VB license out of the admincp/index.php file and your config file by email to chuck@photopost.com. Let me see what you have there

...sent