TEAMBAJAMARINE
01-23-2006, 08:43 PM
Any Ideas?
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(3737,3738,3739,4163)
GROUP BY post.postid
ORDER BY
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 'LIMIT 10' at line 20
mysql error number: 1064
Date: Monday 23rd of January 2006 07:41:38 PM
Script: http://www.teambajamarine.com/home.php?
Referer: http://www.teambajamarine.com
Username: Unregistered
IP Address: 24.216.122.122
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(3737,3738,3739,4163)
GROUP BY post.postid
ORDER BY
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 'LIMIT 10' at line 20
mysql error number: 1064
Date: Monday 23rd of January 2006 07:41:38 PM
Script: http://www.teambajamarine.com/home.php?
Referer: http://www.teambajamarine.com
Username: Unregistered
IP Address: 24.216.122.122