Anyone with an idea what the following problem is? Only get this error message anytime anyone clicks the link from usercp to 'list subscriptions' and it's only been since I did the upgrade to ver. 3.6.2. I could probably suss it out since it does say line 4 near such and assuming this is in subscription.php file, but I'm afraid I'll screw something up. Help please.
Code:
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview, thread.threadid, IF(thread.threadprefix <> '', CONCAT('', thread.threadprefix, ' - ', thread.title), thread.title) AS title AS threadtitle, forumid, pollid, open, replycount, postusername,
thread.lastpost, thread.lastposter, thread.lastpostid, postuserid, thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible, thread.attach
, threadread.readtime AS threadread
, thread.threadprefix
FROM ****_thread AS thread
LEFT JOIN ****_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN ****_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 5)
WHERE thread.threadid IN (2937,2834,2913,3003,2977,3000,2828,2986,3005,2983,2955,2992,2954,2969,2935,3002,2909,2854,2994,2974)
ORDER BY thread.lastpost DESC;
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 'AS threadtitle, forumid, pollid, open, replycount, postusername,
thread.last' at line 4
Error Number : 1064
Date : Tuesday, October 31st 2006 @ 07:48:27 AM
Script : http://www.****.***/forums/subscription.php?do=viewsubscription
Referrer : http://www.****.***/forums/usercp.php
IP Address : **.***.***.***
Username : *********
Classname : vb_database