| the Sandman |
04-13-2006 02:17 PM |
I still cannot get this to work. :( The problem is with guests, who get the database error:
Code:
<!--
Database error in vBulletin 3.5.3:
Invalid SQL:
## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE open = '1'
AND forumid NOT IN (0,92,41,38,154,174,83,78,30,114,31,33,32,84,111,67,123,160,161,70,121,71,72,73,74,7,79,81,8,10,108,34,9,68,11,40,117,118,)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 10;
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 ')
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
Error Number : 1064
Date : Thursday, April 13th 2006 @ 10:56:46 AM
Script : http://www.theadminzone.com/index.php
Referrer :
IP Address :
Username : Unregistered
Classname : vb_database
-->
Any suggestions? I could really use this. |
More Information