Bug Posts not appearing for some users / Database errors being sent

[McCarroll21]

Some users on my site are saying that the live updates aren't showing for them. I am getting database error emails sent to me from those users, so hopefully this will help.

I have logged in as the users to see it not working for them, so it is account based, not something local to their machine.

Some database error emails:

From Friday, March 2:

Database error in vBulletin 4.1.10:

Invalid SQL:

                       SELECT postid, userid, title, pagetext, visible, dateline
                       FROM vb_post
                       WHERE postid >= '697747'
                               AND threadid = '26293'
                               AND visible = 1
                               AND post.userid NOT IN (3963)
                       ORDER BY postid ASC;

MySQL Error   : Unknown column 'post.userid' in 'where clause'
Error Number  : 1054
Request Date  : Friday, March 2nd 2012 @ 09:28:50 PM
Error Date    : Friday, March 2nd 2012 @ 09:28:54 PM
Script        : http://www.*******.com/forums/ajaxthreads.php
Referrer      : http://www.*******.com/forums/showthread.php?t=26293
IP Address    : *******
Username      : TheMatrix31
Classname     : vB_Database
MySQL Version :

From Saturday, March 3:

Database error in vBulletin 4.1.10:

Invalid SQL:

                       SELECT postid, userid, title, pagetext, visible, dateline
                       FROM vb_post
                       WHERE postid >= '697948'
                               AND threadid = '26304'
                               AND visible = 1
                               AND post.userid NOT IN (3963)
                       ORDER BY postid ASC;

MySQL Error   : Unknown column 'post.userid' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, March 3rd 2012 @ 01:07:28 PM
Error Date    : Saturday, March 3rd 2012 @ 01:07:28 PM
Script        : http://www.*******.com/forums/ajaxthreads.php
Referrer      : http://www.*******.com/forums/showthread.php?t=26304&page=2
IP Address    : *******
Username      : twade09
Classname     : vB_Database
MySQL Version :

Just wanted to show similar errors from different users and different threads.

 

[Fillip H.]

Firstly, let me thank you for your absolutely stellar bug report. Concise, but detailed enough that it has everything I need to fix it right away. It really warms my heart to post in threads like this

Which is what makes me happy to say that I have fixed it This only occurs when you are using the "Global Ignore" (formerly known as "Tachy Goes To Coventry") feature.

If you re-download the product and re-upload only this file: /dbtech/ajaxthreads/actions/ajax.php it should now be working as intended

 

[McCarroll21]

Thanks for the fix! Thanks for the explanation, too. It was confusing me because it was only happening for some people but not for everyone and it wasn't really usergroup specific (though we have had some moderators step down and maybe that's why it wasn't triggering for them).