vb.org Archive - Database Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Database Error - Calendar? (https://vborg.vbsupport.ru/showthread.php?t=261880)

Database Error - Calendar?

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.

Code:

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

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

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

https://vborg.vbsupport.ru/

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

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.

Quote:

Originally Posted by smooth-c (Post 2184475)

http://img829.imageshack.us/img829/3567/capturedbb.jpg

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:

Code:

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:

Code:

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

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

What do you suggest I do?

No, it is the same table:

Code:

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?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01112 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: