
02-08-2006, 04:19 PM
|
 |
|
|
Join Date: Aug 2003
Location: Tampa, FL
Posts: 229
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Installed, but getting many database errors:
Quote:
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,38,154,83,78,30,114,31,33,32,111,84,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
|
|