Please help! I just upgraded and my gallery is not working.
After upgrading vBulletin v3.0.8 to v3.5.4, we have been experiencing
difficulties our integration with the Photopost Gallery v5.3
If you select an image to upload and click the upload button, the image
put in the gallery database, but the script fails before presenting the
Here is the error we are getting:
***************** beg error message *************************
Database error in vBulletin 3.5.4:
MySQL Error : Table 'corvette_gallery.bbcode' doesn't exist
Error Number : 1146
Date : Monday, March 13th 2006 @ 08:27:31 PM
******************** end of error message ***********************
We are using vBulletin 3.5.4, MySQL v5.0, PHP version 4.4.1 and
CMPS V 2.1.0 and Photopost v5.3
No code hacks .
We did attempt to edit settings in the admin script of Photopost, and
cannot even get to that file.
Please provide any suggestions as to what to check or correct.
gallery down after VB3.0.8 to 3.5.4 - sql issues...
More information -
I updated on of the photopost scripts to show me the sql errors -
What is happening is that the period separating the database name and the table name is missing.
Here is the SQL in error -
Query: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM corvette_forumsuser u LEFT JOIN corvette_forumssession s ON s.userid=u.userid WHERE u.userid=19
As you can see, the database(corvette_forums) is not delimited from the table names (user and session).
I have tried changing the inc and config settings to no avail.
The version of Photopost I am running is 5.13, and as stated above, we have vBulletin 3.5.4 and VBAdvanced v 2.1.0
You may see our gallery at
Please help us out - our members find the allery to be one of the features that makes it great!
As a heads up , I have read all the upgrade faqs etc.
We have NOT run any upgrade scripts for PhotoPost.
[ Moved to PhotoPost PHP Pro ]
Photopost 5.13 is not compatible with vbulletin 3.5.
You must be running at minimum Photopost 5.2 so please log in to your members area and download 5.3
Thank you for your help. I have seen many posts by you helping people here.
I downloaded the 5.3 file, and followed the instructions for the install.
I modified the config-inc.php and config-int.php files.
The config-inc.php file in my existing directory had version 5.13 in the comments.
When I attempt to execute the upgrade script, I receive the following errors:
I have that variable set in config-int.php as it should be.
I tried running some of the other upgrades on the upgrade.php script, and they created tables with no pp_ prefix - so I just dropped them.
All of the alter commands had errors (because of the prefix not being correct).
I appreciate your thoughts as to what to look for to correct.
You do not replace your config files on an upgrade. You use the upgrade to upgrade your 5.1 to 5.3. I would suggest you check your config-inc.php file to see that it has the correct table prefix for photopost. The prefix is entered in that file not the int one which is used for vb integration. This is where the upgrade script would get its prefix from the config-inc.php file.
Thank you for your quick reply.
The instructions for the upgrade state that you have to use the new config-inc files because of new variables:
However, we are now back to getting the "We're sorry, but the system experienced an unrecoverable error. Please try again later." errors.
Just FYI - made note at the time of uploading that my "new" config-inc.php from the zip file did not contain an entry for $cookie_domain as per the isntructions above. I added an entry for this variable in the config-inc.php file and put it on the server.
I must be doing something wrong.....
Thanks for your expert help!
Hi Chuck S -
I edited the pp-inc.php to allow display of the error -
Basic problem - using my database name as my table-prefix.
I fixed it.
In the settings table the variable for my forums table prefix was set to pp_
Now I have a problem in the admin panels - I'll research here before I ask...
Cookie settings is what you want to search for. VB and Photopost must match. Tons of threads here with posts by me ;)
|All times are GMT -5. The time now is 03:53 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0