I am having a problem with my gallery graphics after doing some major work on my vBulletin forum.
To start, I moved my forum to a new domain name. To make it easy, I installed the vBulletin software several weeks ago, and all additional scripts and mods. It was initially at version 3.6.5 (vBGallery at v2.0), with everything working fine. When news came out of the version 3.6.6 release, I installed that last weekend. vBGallery was still working fine.
The official production domain switch (last night) was pretty easy since I didn't change servers. I just closed the old forum installation and pointed the new forum installation to the existing production database. vBGallery constinued to work. I had a few issues within the forum that caused me to go ahead and do the upgrade to version 3.6.7 to see if it would resolve them. Some were resolved, others were not, but the biggest thing was that either the upgrade, or something else I did, broke vBGallery. It worked, but the pictures were not showing up.
I have looked through the configuration, run all maintenance scripts, changed the storage method (I want the images in the database) and still could not fix it. This evening I noticed that there was an upgrade available for vBGallery (v2.2) so I attempted that upgrade which I was hoping would magically straighten things out. Every time I tied to run the upgrade script, I received a bunch of database errors and now I am locked out of the gallery apparantly with a permissions issue of some kind.
As background, I also upgraded my CPMS and VBLinks last night as well. The only problem I have left is the gallery. I hate to keep bugging you Zach (you had to bail me out when I moved to a new server 4 or 5 months ago) but I seem to always have problems when I make a large move.....
I assume your errors when running the gallery update.
- can not find a table name ? "xxxx_setting"
This should fix the database errors when launching the upgrade script for the gallery. The reason for the permission errors is that you have the latest files on the server but not a full upgrade database wise.
I made the changes abouve and ran the script again, checking "upgrade". It gave me a message that I was already at that version. I did the "This will add setting and update setting cache" and "Update your image paths". All appeared to work okay on both of those except I have noticed that most of the smilies have the old domain name in the reference. Rather than cutting and pasting the new domain into several hundred smilie paths, I let that one slide for now.
When I tried to go to the gallery, I got the permissions message again. Here's the specifics of that message:
Bumper, you do not have permission to access this page. This could be due to one of several reasons:
Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
If I completely uninstall the script and start over, will it remove/delete all of my images? Would these kinds of problems be lessened by going to the PhotoPostPro?
Zach, what's funny is that the pictures appear to upload okay, but when you click on them to look at the larger picture, it's not finding the picture and those members that don't happen to be administrators are getting an invalid path message. I'm still looking into the permissions aspects of this, but the permissions are set to allow them to post pictures.....
When the upgrade crashed it was only 1/2 done. Post 2 (above) stoped the update. I have updated the next build with this code.
I looked at your database, during the upgrade all of the tables were to be renamed, but the upgrade script halted. I ran the update manually by going step by step through the update file until your database was updated.
I also CHMOD your data folder were the images were stored as everything was reset to 644.
That makes sense, Zach, thanks. Still having sporadic problems with certain people not being able to post pictures and poor qusality thmbnails and off color photos, but much improved. Does the upgrade change quality settings and such?