PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old June 24th, 2005, 01:08 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 12
Unhappy After Upgrade to 1.0.1 New Image thumbnail links stopped working.

Hey everyone...An interesting happening after upgrading the vBGallery from RC4 to 1.0.1 tonight.

Everything seems to be working just fine except the Newest Image block on the bottom of the site. I've changed the settings on there to different numbers of "new images" and I keep getting this db error:

Quote:
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT images.imageid, images.userid, images.thumbname, extension
FROM adv_gallery_images AS images

WHERE valid = 1
ORDER BY dateline DESC, imageid DESC
LIMIT 1,2,5,10,25
mysql error: You have an error in your SQL syntax near '5,10,25' at line 7

mysql error number: 1064
The "Random Image" block on the bottom works fine...You click on the thumbnails and it goes to the image....Just the New Images get's me that error. I've tried deleting all of the images (gallery isn't live on the site yet so I have that luxury LOL) and uploading new ones...to no avail.

Here's the link to the one image that I uploaded here a couple of seconds ago from the "New Images" block.....

http://forum.bowzone.ca/gallery/show...atid=newimages
Code:
Content visible to verified customers only.
I'm running vb3.0.7 / vbgallery 1.0.1....Gallery has no hacks...
BOWZONE is offline   Reply With Quote
Old June 24th, 2005, 01:21 AM   #2 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 12
Re: After Upgrade to 1.0.1 New Image thumbnail links stopped working.

Hmm..upon further checking.....the links for the following are not working either...

Under What's New: New Images and New Posts give the same sql error as posted above.....and under the What's Popular link...all 3 options in there give me a blank page...

I would rather not uninstall and re-install but I'm thinking that it may be my only option.

BOWZONE is offline   Reply With Quote
Old June 24th, 2005, 08:51 AM   #3 (permalink)
Registered User
Verified Customer
 
KW802's Avatar
 
Join Date: Nov 2005
Posts: 1,400
Re: After Upgrade to 1.0.1 New Image thumbnail links stopped working.

Bowzone,

In your Gallery ACP did you set the various Gallery paths?
KW802 is offline   Reply With Quote
Old June 24th, 2005, 09:36 AM   #4 (permalink)
Brian
Guest
 
Posts: n/a
Re: After Upgrade to 1.0.1 New Image thumbnail links stopped working.

If you're getting that db error then you did not upload all of the files for 1.0.1. Go back and be sure to upload every file that came in the package.
  Reply With Quote
Old June 24th, 2005, 10:52 AM   #5 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 12
Talking Re: After Upgrade to 1.0.1 New Image thumbnail links stopped working.

Quote:
Originally Posted by Brian
If you're getting that db error then you did not upload all of the files for 1.0.1. Go back and be sure to upload every file that came in the package.
Well then....looks like the stupid pill I took worked...LOL!

You were right Brian...3 files in the gallery dir. didn't overwrite the existing...I just checked the dates on them all...

Thanks a ton Brian....I really appreciate the solution.

Scott
BOWZONE is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forum Stopped Working alp33 Photopost Pro Installation & Upgrades 8 October 26th, 2005 12:10 PM
View Image Count Stopped Working(NOT A BUG) kevinrstruck Photopost Pro Bug Reports 2 October 16th, 2005 09:52 PM
photopost stopped working bigfoilin General Discussion 1 October 8th, 2005 08:12 AM
Checkbox has stopped working StuartDH Installs and Upgrade - vBulletin 3.0.X 1 July 21st, 2005 09:47 AM


All times are GMT -5. The time now is 12:05 PM.

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