Error in my Database

[aspen1018]

I keep getting this error emailed to me:

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT
SUM(counter) as sum_att_views
FROM attachment as a
INNER JOIN post AS p ON p.postid = a.postid
INNER JOIN thread AS t ON p.threadid = t.threadid
WHERE a.userid=1;

MySQL Error : Unknown column 'a.postid' in 'on clause'
Error Number : 1054
Request Date : Monday, November 12th 2012 @ 04:52:00 PM
Error Date : Monday, November 12th 2012 @ 04:52:00 PM

However the forum seems to be functioning fine?

Any suggestions?

[Lynne]

That is from a modification as there is no postid field in the attachment table in vB4. You need to disable/remove the modification to get rid of the error.

[aspen1018]

ok but I never added a mod for about a year now? Hmmmmm I guess I could try disabling one by one