View Full Version : Upgrade Problem
August 18th, 2007, 10:20 PM
I can not get the Gallery to upgrade. Everytime the Plugin runs it spits out this sql error:
Database error in vBulletin 3.6.8:
SET nextrun = 1187492340
WHERE cronid = 31 AND nextrun =;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Username : Tech Admin
Classname : vB_Database_Slave
Gallery shows white pages and no links are available in the left side of the admincp for the gallery.
August 19th, 2007, 05:37 PM
Run the install script from your browser by going to:
http://www.yourwebsite.com/forums/admincp/vbgallery_install.php[ 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.
August 19th, 2007, 05:45 PM
Tried it both ways. Via the install script and uploading manually. Same result.
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.
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.
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
Log-in to your AdminCP
- Plugins & Products -> Manage Products -> [Add/Import Product]
[Browse] - forums/admin/product-ppvbgallery.xml
Allow Overwrite [ x ] Yes
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.