Please help! I just upgraded and my gallery is not working.

[doggy1]

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!

[doggy1]

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!

[KW802]

[ Moved to PhotoPost PHP Pro ]

[Chuck S]

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

[doggy1]

Originally Posted by Chuck S

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:

Originally Posted by upgrade.php_errors

Preparing to update database...
Error performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','5.2',53,0);
Error: Table 'corvette_gallery.settings' doesn't exist

Error performing MySQL command: INSERT INTO settings VALUES (211,'Minutes to cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)
Error: Table 'corvette_gallery.settings' doesn't exist

Error performing MySQL command: INSERT INTO settings VALUES (212,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)
Error: Table 'corvette_gallery.settings' doesn't exist

Database not properly setup - unable to read settings table. Contact administrator.

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.

[Chuck S]

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.

[doggy1]

Originally Posted by Chuck S

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:

Originally Posted by upgrade.txt

1) Check for new config-inc.php variables, some recent additions are:

$cookie_domain has been added for website cookies. I highly recommend setting this to ".youdomain.com" where
yourdomain is the name of your domain. This will enable cookies to be read across your website regardless
of the URL (i.e. galley.website.com and forums.website.com). If you are using a forum integration you
must have this set in both your forums and photopost.

<SNIP VB3 COMMENT>

2) Upload all files - except config-inc.php, unless you modified it from the ZIP file - to
your server. You do not need install.php for an upgrade.

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

[doggy1]

Hi Chuck S -

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

Originally Posted by error_message

Query: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,s.lastactivity,u.membergroupids FROM corvette_forumsuser u LEFT JOIN corvette_forumssession s ON s.userid=u.userid WHERE u.userid=19

Result: Table 'corvette_forums.corvette_forumsuser' doesn't exist

Database handle: Resource id #10

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

[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

[Chuck S]

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