Upgrade Problem

BrentWilson · August 18th, 2007, 10:20 PM

I can not get the Gallery to upgrade. Everytime the Plugin runs it spits out this sql error:

Code:

Content visible to verified customers only.

Gallery shows white pages and no links are available in the left side of the admincp for the gallery.

Zachariah · August 19th, 2007, 05:37 PM

Run the install script from your browser by going to:

Code:

Content visible to verified customers only.

[ x ] Upgrade.

This script will make all necessary changes to your database, templates, phrases, and settings.

Once you have finished please remove vbgallery_install.php, product-ppvbgallery.xml in the forums/admincp folder.

BrentWilson · August 19th, 2007, 05:45 PM

Tried it both ways. Via the install script and uploading manually. Same result.

Zachariah · August 19th, 2007, 06:01 PM

I did a full search on vBGallery and vBulletin files looking @the error.
"SET nextrun = 1187492340"

=======================================
Search String: SET nextrun

Processing file : forums\includes\functions_cron.php
Line 185 - SET nextrun = " . $nextrun . "
Found 1 occurrences.

Processing file : forums\install\upgrade_300b7.php
Line 108 - SET nextrun = 1062979200
Found 1 occurrences.

Searched 984 file(s), found 2 occurrences in 2 file(s)

=======================================

These are 2 vBulletin core files.
- Try and upload forums\includes\functions_cron.php from your vBulletin main Zip and try the upgrade again.

BrentWilson · August 21st, 2007, 12:36 AM

I've already tried this as well. I finally got it to work but I can still reproduce the error when I try to reinstall templates and plugins. It's not installing all the crons it should. The error stops it after only one cron has been installed.

Zachariah · August 21st, 2007, 11:15 AM

Well the CRONS are installed via product XML file.
- you can import the vBGallery product again. (select overwrite) this should clean up things, if there are problems.

In the download of the gallery script
- forums/admin/product-ppvbgallery.xml

Log-in to your AdminCP
- Plugins & Products -> Manage Products -> [Add/Import Product]
Import Product
[Browse] - forums/admin/product-ppvbgallery.xml

Allow Overwrite [ x ] Yes

BrentWilson · August 21st, 2007, 07:22 PM

It's related to using a slave database server. Not sure if this is on your end or vBulletins end.

When I disable the slave database by using datatype mysql, the import works. When I enable it with mysql_slave it doesn't work.