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!
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'
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???
Last edited by XtReMaTriX; September 29th, 2004 at 07:18 PM.
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...