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
gets
put in the gallery database, but the script fails before presenting the
next
screen.

Here is the error we are getting:

***************** beg error message *************************
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT *
FROM bbcode;

MySQL Error : Table 'corvette_gallery.bbcode' doesn't exist
Error Number : 1146
Date : Monday, March 13th 2006 @ 08:27:31 PM
Script :
http://www.corvettevalley.com/galler...o=2686&cat=533

******************** end of error message ***********************

We are using vBulletin 3.5.4, MySQL v5.0, PHP version 4.4.1 and
VBAdvanced
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
now we
cannot even get to that file.

Please provide any suggestions as to what to check or correct.

Thank you!

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

http://www.corvettevalley.com/gallery

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.

Thank you!

[ 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

Hello Chuck S -

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:

The upgrade script is not recognizing that I have a "pp_" prefix on my gallery tables.

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.

Thank you.

Hello

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.

Hi Chuck S -

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:

Since your post, I have restored the backup up config files (int and inc) from my backup and now the install has run and stated that it was successful.

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!

doggy1

Hi Chuck S -

I edited the pp-inc.php to allow display of the error -

As you can see, I am right back where I started with the same problem that I had before the upgrade from 5.13 to 5.3

Basic problem - using my database name as my table-prefix.

www.corvettevalley.com\gallery

Thanks!

doggy1

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...

doggy1

Cookie settings is what you want to search for. VB and Photopost must match. Tons of threads here with posts by me ;)