upgrade problem

[mixhard]

i uploaded the 3 files in the readme

/forums/includes/functions_gallery_imageedit.php
/forums/admincp/vbgallery_install.php
/forums/admincp/product-ppvbgallery.xml

Run the install script from your browser by going to:

http://www.mixhard.ca/forum/admincp/...ry_install.php
i choose upgrade, and click continue to get to a photopost page with nothing on it.

see attachment.

I recently migrated servers, could this be a CHMOD setting preventing the script from running?

[Zachariah]

That was security update from 2.4.1-2.4.2. I missed adding upgrade from other versions. (paste below)

This is a security update to prevent script file upload exploits. Please read the security bulletin for more information about this issue.

This version of vBGallery has been tested on:
* vBulletin® Version 3.6.8
* vBulletin® Version 3.7.0 Beta 3


File Changes
Upload the new PhotoPost vBGallery files to the directories listed below.
root/forum/admincp

• vbgallery_install.php
• product-ppvbgallery.xml

root/forum/includes

• functions_gallery_imageedit.php

Upgrade

vBGallery 2.4.1 - 2.4.2

Upload:

• /forums/includes/functions_gallery_imageedit.php
• /forums/admincp/vbgallery_install.php
• /forums/admincp/product-ppvbgallery.xml

Skip down to "[all versions of upgrade]"


vBGallery 1.0 - 2.4.0
Please upload and replace all files on your web server.

In the script folder there are 2 folders.
- forums (upload to vBulletin root)
- gallery

The content of the forums folder is uploaded to the root of your vBulletin install. The file structure of the upload will coincide with the vBulletin folder layout.

The gallery folder must also stay in tact, but can be placed in many places.

EX:
1)
http://www.domain.com <- vBulletin root
http://www.domain.com/gallery
http://gallery.domain.com

2)
http://www.domain.com
http://www.domain.com/forums <- vBulletin root
http://www.domain.com/forums/gallery
http://www.domain.com/gallery
http://gallery.domain.com


You can also change the /gallery/ name. (EX: /photos/ )


- Ascii: php, js, html, css - anything that is a text file
- Binary: gif, jpg, png - any media file

[all versions of upgrade]

Run the install script from your browser by going to:

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.

[Zachariah]

I recently migrated servers

- Make sure you update your file paths in vbgallery settings and /gallery/gallery_config.php to reflect the forums new path.

Server change means /path/to/your/files changes. Also in your forums attachments, avatars, signatures if saved to system file must also be updated. (default is database)

[mixhard]

i did what your directions said, now the gallery is fubared

i get this error when trying to access is



Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT catid, styleid, title, description, parent, parentlist, catimage, imagecount, postcount, lastimageid, lastimagetitle, lastimageuserid, lastimageusername, lastimagedateline, lastpostid, lastpostuserid, lastpostusername, lastpostimagetitle, lastpostdateline, styleoverride
FROM ppgal_categories
ORDER BY;

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
Date : Friday, January 11th 2008 @ 10:30:11 PM
Script : http://www.mixhard.ca/forum/gallery/index.php
Referrer : http://www.mixhard.ca/forum/index.php
IP Address : 24.66.94.142
Username : LSDave
Classname : vB_Database


if you need ftp and admin access lemme know

[Zachariah]

Did the upgrade proceed ok ?
- were the error messages during

Content visible to verified customers only.

[upgrade]

[mixhard]

upgrade seemed to work fine

then when i try to navigate to the gallery i got this error.

[mixhard]

Under manage products in my admincp it shows photopost at 2.4.2

[Zachariah]

Turn on the gallery - it's off
- I can not see it.

Did you update ?
AdminCP => vBGallery => Modify Settings
- Title, URL's, & Paths
-- Files Path
-- FTP User Folder Path

[mixhard]

gallery is on now, and none of the paths changed

[Zachariah]

AdminCP => vBGallery => Maintenance
- Update Category Cache

[mixhard]

already tried that

[Zachariah]

Shoot me some access I'll take a poke.
- AdminCP / ftp via PM, I'll give ya an update.

[Zachariah]

There were a few files missing on upload.
- I edited and fixed 1 of the 3 skins for the gallery "Final MixHard" There were 3-4 templates you had some customs stuff done to.

$vba_options changed to $ppg_options and the skin came up.
- at first w/ the old code still in use many things were missing.

I forgot when I was in there.
- CHMOD -R recursively you will need change your gallery upload folder that stores the images to 777. On server move they change most of the time to read-only

[mixhard]

excellent, thanks for the prompt support. Only good things to say about Photoposts support team.

[cavatina]

Thanks Zachariah for your magical touch on my forum as well as I had some issues with the upgrade (my bad). Cheers!

[itonline]

hey there,
i´ve got the same problem as mixhard, i tried to upgrade from vbgallery 2.3 to version 2.4.2 while using vbulletin 3.6.8. After choosing [upgrade] i only get the photopost page with nothing on it (like in mixhards screenshot).

any ideas?

two other questions:

- is it possible to activate vbgallery in the vbulletin-navi by "settings", or do i have to embed the link "by hand"?

- why will the style-settings keep beeing ignored? i have multiple categories with differnet styles and they are all displayed with the default-style??

Link: http://forum.outdoorchannel.de/forum/gallery/

thanks.

[Zachariah]

itonline, did you replace all the files that came in the zip package over your files that reside on the serve ?

[itonline]

zachariah,
we alreday fixed it ... we did a complete new installation of 2.4.2. that fixed all our problems.
thanks!