Database Error

[ricker]

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

SELECT IF(votenum >= , votenum, 0) AS votenum, IF(votenum >= AND votenum> 0, votetotal / votenum, 0) AS voteavg, images.imageid
FROM adv_gallery_images AS images

WHERE valid = 1 AND votenum >=
ORDER BY voteavg DESC, votenum DESC, images.imageid DESC
LIMIT 0;

MySQL Error : You have an error in your SQL syntax near ' votenum, 0) AS votenum, IF(votenum >= AND votenum> 0, votetotal / votenum, 0) ' at line 2
Error Number : 1064
Date : Tuesday, August 9th 2005 @ 04:41:23 PM
Script : http://www.myjeeprocks.com/forums/ga...orderby=rating
Referrer :
IP Address : *******
Username : sarah
Classname : vb_database

Ummm!! What gives?

[ricker]

Well, the good thing is that I can't seem to reproduce it ... but that doesn't necessarily mean something isn't wrong.

Admin CP => vBulletin Options => Poll and Thread Rating Options => Required Thread Rating Votes to Show Rating

Make sure you have that option set to a valid number.

[ricker]

Originally Posted by Brian

Admin CP => vBulletin Options => Poll and Thread Rating Options => Required Thread Rating Votes to Show Rating

Make sure you have that option set to a valid number.

It's set to 1. So far, the only other error messages I"ve gotten have come from this page. Maybe the first was just a fluke?

It's still giving me the error when I try to view that link as a guest. I don't see why it would make a difference for someone that was logged in though... I just checked on a couple of other sites and it seems to work fine for them as well, so I'm not really sure how you would be getting that error. If you'd like to submit a support ticket though I'll be glad to take a look.

[ricker]

I have another error now ... I will submit a ticket, thanks Brian.

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

SELECT images.imageid, images.userid, images.thumbname, extension
FROM adv_gallery_images AS images

WHERE valid = 1 AND images.userid NOT IN(761) AND images.posts != 0 AND images.lastpostdateline > AND images.catid NOT IN(582,576)
ORDER BY images.lastpostdateline DESC, images.imageid DESC;

MySQL Error : You have an error in your SQL syntax near 'AND images.catid NOT IN(582,576)
ORDER BY images.lastpostdateline DESC, image' at line 5
Error Number : 1064
Date : Thursday, August 18th 2005 @ 12:47:24 PM
Script : http://www.myjeeprocks.com/forums/ga...catid=newposts
Referrer :
IP Address : 216.136.233.164
Username : Unregistered
Classname : vb_database

[Lionel]

I have the very same databse error with version 2.0 and vb 3.60