Quote:
Originally Posted by n_i_t_r_o_u_s
this is a great hack, is it possible to port it to 3.0.6?
here's the error i get when calling it up:
Database error in vBulletin 3.0.6:
Code:
Invalid SQL:
SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
user.username, thread.open, attachment.userid
FROM wwwtoke_attachment AS attachment
LEFT JOIN wwwtoke_post AS post ON (post.postid = attachment.postid)
LEFT JOIN wwwtoke_thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN wwwtoke_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN wwwtoke_user AS user ON (attachment.userid = user.userid)
WHERE attachment.userid = 1
AND ((forumid IN (,3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,14,15,21,22,23,24,25,26,27,28) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
ORDER BY attachment.attachmentid DESC
LIMIT 0, 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 '3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,
mysql error number: 1064
|
i get the same type of error to here is my error :
PHP Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
user.username, thread.open, attachment.userid
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN user AS user ON (attachment.userid = user.userid)
WHERE attachment.userid = 1
AND ((forumid IN (,1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
ORDER BY attachment.attachmentid DESC
LIMIT 0, 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 '1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlo
mysql error number: 1064
|