View Single Post
  #25  
Old 05-12-2006, 09:06 PM
Lygren Lygren is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Geek Article and Review System License Holder GeekMart License Holder 
Default

Well, changing this get me:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT g.threadid,g.header_image image, p.title, g.byline, IF(g.synopsis, g.synopsis, p.pagetext) synopsis ,round((g.overall_rating/10),0) author_rating, g.overall_rating author_rating_percent,round((g.avg_rating/10),0) member_rating, g.avg_rating member_rating_percent ,g.pagecount, g.custom2 FROM
bb_gars g

INNER JOIN bb_thread t ON g.threadid = t.threadid
INNER JOIN bb_post p ON t.firstpostid = p.postid
WHERE t.visible = 1 AND t.open != 10
AND t.forumid in (67,68,69)

ORDER BY g.threadid RAND() LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND() LIMIT 5' at line 9
Error Number : 1064
Date : Friday, May 12th 2006 @ 11:06:58 PM
Script : http://avforum.com/
Referrer :
IP Address : 85.166.26.160
Username : lygren
Classname : vb_database
Reply With Quote