Moya, another error when selecting "Find All Posts" on a users profile:
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT post.postid, post.title AS posttitle, post.dateline AS postdateline,
post.iconid AS posticonid, post.pagetext, post.visible, post.attach,
IF(post.userid = 0, post.username, user.username) AS username,
thread.threadid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.replycount,
IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.firstpostid, thread.prefixid, thread.taglist,
thread.pollid, thread.sticky, thread.open, thread.lastpost, thread.forumid, thread.visible AS thread_visible,
user.userid
,pdeletionlog.userid AS pdel_userid, pdeletionlog.username AS pdel_username, pdeletionlog.reason AS pdel_reason
,tdeletionlog.userid AS tdel_userid, tdeletionlog.username AS tdel_username, tdeletionlog.reason AS tdel_reason
, threadread.readtime AS threadread
,thread.vbbux_cost,thread.vbplaza_titleflags,threa d.vbplaza_titletextcolor,threa d.vbplaza_titleglowcolor,thread.vbplaza_titleshado wcolor,thread.vbplaza_titlefon ttype,thread.vbplaza_titlebordercolor,thread
|