vb.org Archive

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)

smooth-c 04-12-2011 08:57 AM

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

Marka Ragnos 04-12-2011 09:58 AM

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

Lynne 04-12-2011 04:05 PM

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 04-14-2011 06:56 AM

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_

Lynne 04-14-2011 04:25 PM

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 04-14-2011 07:39 PM

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 04-14-2011 07:57 PM

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?

smooth-c 04-14-2011 08:23 PM

What do you suggest I do?

Lynne 04-14-2011 09:04 PM

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?


All times are GMT. The time now is 11:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01084 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