PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old August 9th, 2005, 06:42 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Mar 2005
Location: Apple Valley, CA
Posts: 46
Send a message via AIM to ricker Send a message via Yahoo to ricker
Database Error

Quote:
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 is offline   Reply With Quote
Old August 9th, 2005, 07:02 PM   #2 (permalink)
Member
Verified Customer
 
Join Date: Mar 2005
Location: Apple Valley, CA
Posts: 46
Send a message via AIM to ricker Send a message via Yahoo to ricker
Re: Database Error

Well, the good thing is that I can't seem to reproduce it ... but that doesn't necessarily mean something isn't wrong.
ricker is offline   Reply With Quote
Old August 10th, 2005, 01:21 PM   #3 (permalink)
Brian
Guest
 
Posts: n/a
Re: Database Error

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.
  Reply With Quote
Old August 10th, 2005, 03:24 PM   #4 (permalink)
Member
Verified Customer
 
Join Date: Mar 2005
Location: Apple Valley, CA
Posts: 46
Send a message via AIM to ricker Send a message via Yahoo to ricker
Re: Database Error

Quote:
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?
ricker is offline   Reply With Quote
Old August 10th, 2005, 03:27 PM   #5 (permalink)
Brian
Guest
 
Posts: n/a
Re: Database Error

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.
  Reply With Quote
Old August 18th, 2005, 03:44 PM   #6 (permalink)
Member
Verified Customer
 
Join Date: Mar 2005
Location: Apple Valley, CA
Posts: 46
Send a message via AIM to ricker Send a message via Yahoo to ricker
Re: Database Error

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
ricker is offline   Reply With Quote
Old August 29th, 2006, 06:35 PM   #7 (permalink)
Registered User
 
Join Date: Mar 2002
Posts: 176
I have the very same databse error with version 2.0 and vb 3.60
Lionel 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
Database Error Lizard King Installs and Upgrade - vBulletin 3.5.X 2 October 5th, 2005 03:32 AM
Database error -peace- Installs and Upgrade - vBulletin 3.0.X 1 September 23rd, 2005 11:25 AM
Database error! simmonet Photopost Pro Installation & Upgrades 2 February 11th, 2005 10:22 AM
Database error izan Classifieds Bug Reports 7 October 23rd, 2004 12:40 PM
Database Error... maikj Photopost Pro Installation & Upgrades 8 July 14th, 2004 04:01 PM


All times are GMT -5. The time now is 10:57 AM.

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