Captive Reefs
Customer
Just upgraded my forum to 4.2.2 and when I upgrade and enable vbslider I am getting the following database error:
Any suggestions would be appreciated.
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.dateline, forum.forumid, forum.title_clean as forumtitle, post.pagetext AS message, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height
FROM vb_thread AS thread
INNER JOIN vb_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_attachment AS attachment ON (attachment.contentid = post.postid)
LEFT JOIN vb_contenttype as contenttype ON (contenttype.contenttypeid = attachment.contenttypeid)
LEFT JOIN vb_filedata as fd ON (attachment.filedataid = fd.filedataid)
WHERE 1=1
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline <= 1390244490
GROUP BY thread.threadid
ORDER BY thread.dateline DESC
LIMIT 0,;
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 '' at line 17
Error Number : 1064
Request Date : Monday, January 20th 2014 @ 01:01:30 PM
Error Date : Monday, January 20th 2014 @ 01:01:30 PM
Script : http://www.captivereefs.com/forum/forum.php
Referrer : http://www.captivereefs.com/forum/login.php?do=logout&logouthash=
IP Address : 23.28.72.178
Username : administration
Classname : vB_Database
MySQL Version : 5.1.63-cllAny suggestions would be appreciated.
