PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.6x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/)
-   -   Upgrade Problem (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/132964-upgrade-problem.html)

BrentWilson August 18th, 2007 10:20 PM

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


All times are GMT -5. The time now is 03:58 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97