db error after upgrading to 2.1.0

[diettalk]

I'm getting this error from only 2 of my users, who cannot view CMPS after upgrading to 2.1.0.

It's strange, only 2 users. I had one logout and she was able to view the portal, and when she logged in, she got the error again.

I've checked and made sure both news.php and latesttopics.php are new 2.1.0 files.


Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT
thread.threadid, post.title, thread.replycount, postusername, postuserid,
thread.dateline AS postdateline, thread.lastposter, thread.lastpost,
IF(views<=thread.replycount, thread.replycount+1, views) AS views,
thread.forumid, post.postid, pagetext, allowsmilie

,thread.iconid AS threadiconid, iconpath AS threadiconpath

, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

LEFT JOIN post_parsed AS post_parsed ON (post_parsed.postid = post.postid AND
post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND
post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)



LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid =
thread.threadid AND subscribethread.userid = '2468')
WHERE thread.threadid IN(52052,51883,51628,51300,51011)
AND thread.postuserid NOT IN(,)

GROUP BY post.postid
ORDER BY thread.dateline DESC
LIMIT 5;

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 ')

GROUP BY post.postid
ORDER BY thread.dateline DESC
LIMIT 5' at line 18
Error Number : 1064
Date : Monday, January 30th 2006 @ 07:36:23 PM

[diettalk]

I'm also getting this from the 2 users.

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT thread.pollid, open, threadid, replycount, forumid, question,
poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters,
public , voteoption
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND
pollvote.userid = 2468)
WHERE open <> 10 AND visible = 1 AND active = 1
AND thread.postuserid NOT IN(,)


AND thread.forumid NOT IN(105,73,62)
ORDER BY poll.dateline 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 ')


AND thread.forumid NOT IN(105,73,62)
ORDER BY poll.dateline DESC' at line 6
Error Number : 1064
Date : Tuesday, January 31st 2006 @ 08:17:44 AM

[Brian]

Do the users who are getting these errors have any members added to their ignore lists?

[diettalk]

I'll ask... but I have someone in my ignore list and I'm not getting an error.

I have one user who gets an error when trying to get into their ignore list.

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username FROM user
WHERE userid IN (2515,3694,7746,1759,)
ORDER BY username;

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 ')
ORDER BY username' at line 2
Error Number : 1064
Date : Thursday, February 2nd 2006 @ 06:42:47 AM

[Brian]

The original problem looks like it has to do with a bad ingore list value, which is why I asked. For the error you've just posted, is that from the user cp? If so, it looks like there's a problem with vBulletin and your ignore lists, so you would need to ask for help at vbulletin.com.

[diettalk]

Seems to be a bug in 3.5.3 ...

http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2151

[diettalk]

Brian... I got a fix to fix the error in profile.php but it still doesn't fix the issue with the CMPS


Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , voteoption
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 2468)
WHERE open <> 10 AND visible = 1 AND active = 1
AND thread.postuserid NOT IN(,)


AND thread.forumid NOT IN(105,73,62)
ORDER BY poll.dateline 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 ')


AND thread.forumid NOT IN(105,73,62)
ORDER BY poll.dateline DESC' at line 6
Error Number : 1064
Date : Monday, February 6th 2006 @ 12:20:41 PM


vb fix is here... http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2151

[diettalk]

hmm... I removed all users from their list and CMPS worked. I guess people will have to remove all users and then add them back in.

[Brian]

It's hard to tell for sure since I'm not positive of the exact conditions to reproduce this error, but for anyone still haivng this problem, try looking in your includes/vba_cmps_include_bottom.php file for this code:
$ignusers = array_merge($ignusers, explode(' ', $vbulletin->userinfo['ignorelist']));

Replace with this:
$ignusers = array_merge($ignusers, explode(' ', trim($vbulletin->userinfo['ignorelist'])));

And see if that takes care of the problem.