Database Error - Calendar?

[smooth-c]

I've been getting this database error for about a week or so now. I can't work out any change that I've made that could have caused this, so I hope someone can help.

Database error in vBulletin 4.1.2:

Invalid SQL:

               SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
                       calendar.calendarid,calendar.title, displayorder
               FROM vb_calendar AS calendar
               LEFT JOIN vb_calendarpermission AS calendarpermission ON
                       (calendarpermission.calendarid = calendar.calendarid AND
                               usergroupid IN (1))
               ORDER BY displayorder ASC;

MySQL Error   : Unknown column 'calendar.calendarid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, April 12th 2011 @ 05:26:29 AM
Error Date    : Tuesday, April 12th 2011 @ 05:26:29 AM
Script        : http://www.xx.com/discussion/calendar.php?c=1&do=displayweek&month=1&week=1261872000
Referrer      :
IP Address    : 38.101.148.xxx
Username      : Unregistered
Classname     : vB_Database

The calendar seems to work fine when I use it. Strange. I've been getting on average.. 20 emails a day with this error?

Thanks

[Marka Ragnos]

That is weird, maybe some people are affected depending on which GMT setting?

[Lynne]

Look at your calendar table - do you have a field called calendarid? You may want to try a repair/optimize on the table.

[smooth-c]

As previously mentioned - Nothing changed prior to these problems. It appears calendarid is there, but it looks slightly out of place. It's underlined, the only one that is out of all of them.

By the way, my table prefix for vBulletin is vb_

[Lynne]

It's supposed to be underlined as it is the key.

I honestly can find nothing wrong with the query. Have you tried doing a repair/optimize on the table?

[smooth-c]

I have, yup. :/ Several times. Calendar seems to work fine on the board. But these emails I'm getting are massively frustrating. There must be a cause.

[borbole]

Originally Posted by smooth-c

As previously mentioned - Nothing changed prior to these problems. It appears calendarid is there, but it looks slightly out of place. It's underlined, the only one that is out of all of them.

By the way, my table prefix for vBulletin is vb_

It looks like the error you are getting is referring to another table, without prefix:

MySQL Error   : Unknown column 'calendar.calendarid' in 'field list'

Because if it referred to the table that you posted at the screenshot, the error message would have said:

MySQL Error   : Unknown column 'vb_calendar.calendarid' in 'field list'

Just like it is mentioned at the query. You see the difference?

[smooth-c]

What do you suggest I do?

[Lynne]

No, it is the same table:

FROM vb_calendar AS calendar

so, calendar.calendarid is a valid field.

Have you ever gotten this error on the site? Have your users? Or is it on Unregistered Users getting the error? And can unregistered users view the calendar?