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