The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Take a look at the event table in your database. Does it have a calendarid or dateline_to field?
|
#3
|
|||
|
|||
Oh big thanks Lynne i was looking in calendar table .. thanks i just notice few things were missing from event table .. compare to a fresh vb install which i did early today so i just drop table and restore it and it fix the problem..
A Big Thanks .. YOU ROCK !!!!! |
#4
|
|||
|
|||
Edit. I was looking at the wrong thing. I do have both of the fields, but I still get the "Invalid Event specified. If you followed a valid link, please notify the administrator" message when clicking on the calendar link.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|