Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-06-2009, 12:44 AM
notrious notrious is offline
 
Join Date: Mar 2007
Location: New York
Posts: 373
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error @ calendar.php & admincp/index.php

Hi there getting 2 wired erros one @ admincp index page and 2nd on calendar.php.

Searched a lot but no clue so posting here. I have tried disabling plugins and hooks glob.. Forum was on 3.7 plat upgrade to 3.8. Now running on 3.8.4.

Any help would be really appreciated...

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

	SELECT COUNT(*) AS count
	FROM event AS event
	INNER JOIN calendar AS calendar USING (calendarid)
	WHERE event.visible = 0;

MySQL Error   : Unknown column 'calendarid' in 'from clause'
Error Number  : 1054
Request Date  : Saturday, December 5th 2009 @ 09:39:25 PM
Error Date    : Saturday, December 5th 2009 @ 09:39:25 PM
Script        :  (FORUMURL)  /forum/admincp/index.php?do=home
Referrer      :  (FORUMURL)      /forum/admincp/index.php?do=nav
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.85-community-log
Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

		SELECT event.*,
		user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
		IF(dateline_to = 0, 1, 0) AS singleday
		, subscribeevent.eventid AS subscribed
		FROM event AS event
		LEFT JOIN user AS user ON (user.userid = event.userid)
		LEFT JOIN subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = 22818)
		WHERE calendarid = 1 AND
			((dateline_to >= 1256990400 AND dateline_from < 1265025600) OR (dateline_to = 0 AND dateline_from >= 1256990400 AND dateline_from <= 1265025600 ))	AND
			visible = 1
		ORDER BY dateline_from;

MySQL Error   : Unknown column 'dateline_to' in 'field list'
Error Number  : 1054
Request Date  : Saturday, December 5th 2009 @ 09:38:55 PM
Error Date    : Saturday, December 5th 2009 @ 09:38:55 PM
Script        :(forum URL) /forum/calendar.php
Referrer     :(forum URL) /forum/index.php
IP Address    : 
Username      :
Classname     : vB_Database
MySQL Version : 5.0.85-community-log
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04224 seconds
  • Memory Usage 2,309KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete