Calendar Error when viewing event details.

[nickbrewer]

Hi all,

Running
-CMS 1.2.3 Black Rock
-Calendar 0.7.5

website
www.hornet.sparcc.org
'district calendar' on left menu

When i click on an event for the event details i get the below error:

-------------------------------------------------------------------------------------------------

categories_table_name; $events_to_categories_table_name = $module->events_to_categories_table_name; $events_table_name = $module->events_table_name; $category = get_parameter_value($parameters, 'category', ''); $summaries = get_parameter_value($parameters, 'summaries', 1); $first_day_of_week = get_parameter_value($parameters, 'first_day_of_week', 1); $table_id = get_parameter_value($parameters, 'table_id', 'calendar-'.$id.$returnid); $event_id = get_parameter_value($parameters, 'event_id', -1); if($event_id == -1) { // no event echo '

Cannot find event
'; return; } $use_session = get_parameter_value($parameters, 'use_session', true); if($use_session) { $month = get_parameter_value($parameters, 'month', date('n'), 'calendar-month'.$id.$returnid); $year = get_parameter_value($parameters, 'year', date('Y'), 'calendar-year'.$id.$returnid); } else { $month = get_parameter_value($parameters, 'month', date('n')); $year = get_parameter_value($parameters, 'year', date('Y')); } $db =& $module->GetDb(); $where = 'WHERE'; $sql = "SELECT DISTINCT $events_table_name.* FROM $events_table_name WHERE event_id = $event_id"; $rs = $db->Execute($sql); if($rs->RecordCount() != 1) { // something's wrong echo '
Either event_id is not in the database, or there is more than one event with this id! ('.$event_id.')
'; return; } $event = $rs->FetchRow(); // pick up categories $sql = "SELECT DISTINCT $categories_table_name.* FROM $categories_table_name LEFT JOIN $events_to_categories_table_name ON $events_to_categories_table_name.category_id = $categories_table_name.category_id WHERE $events_to_categories_table_name.event_id = $event_id"; $rs = $db->Execute($sql); $categories = array(); if($rs) { $categories = $rs->GetArray(); } $return_url = $module->CreateReturnLink($id, $returnid, $module->lang('cal_return')); $day_names = $module->GetDayNames(); $day_short_names = $module->GetDayShortNames(); $month_names = $module->GetMonthNames(); if($first_day_of_week != 0) { for($i = 0; $i GetLabels(); // assign to Smarty $module->smarty->assign_by_ref('month_names', $month_names); $module->smarty->assign_by_ref('day_names', $day_names); $module->smarty->assign_by_ref('day_short_names', $day_short_names); $module->smarty->assign_by_ref('event', $event); $module->smarty->assign_by_ref('categories', $categories); $module->smarty->assign_by_ref('return_url', $return_url); $module->smarty->assign_by_ref('table_id', $table_id); $module->smarty->assign_by_ref('lang', $lang); $module->smarty->assign_by_ref('mo', $lang); // Display template if (isset($params['eventtemplate'])) { echo $module->ProcessTemplate($params['eventtemplate']); } else { $t = $module->GetTemplate('event'); if(empty($t)) { $module->SetTemplate('event', $module->GetDefaultTemplate('event')); } echo $module->ProcessTemplateFromDatabase('event'); } } ?>

---------------------------------------------------------------------------------------------

My calendar 'event' template looks like so:

-----------------------------------------------------------------------------------------------


{$event.event_title}

{assign var=month_number value=$event.event_date_start|date_format:"%m"}
{assign var=end_month_number value=$event.event_date_end|date_format:"%m"}
{if $event.event_date_start == $event.event_date_end || $event.event_date_end == ""}
{$lang.date}: {$event.event_date_start|date_format:"%e"} {$month_names[$month_number]} {$event.event_date_start|date_format:"%Y"}
{else}
{if $event.event_date_start|date_format:"%d%m%Y" == $event.event_date_end|date_format:"%d%m%Y"}
{$lang.date}: {$event.event_date_start|date_format:"%e"} {$month_names[$month_number]} {$event.event_date_start|date_format:"%Y %H:%M"} {$lang.to} {$event.event_date_end|date_format:"%H:%M"}
{else
{$lang.date}: {$event.event_date_start|date_format:"%e"} {$month_names[$month_number]} {$event.event_date_start|date_format:"%Y %H:%M"} {$lang.to} {$event.event_date_end|date_format:"%d"} {$month_names[$end_month_number]} {$event.event_date_end|date_format:"%Y %H:%M"}
{/if}
{/if}
{if $event.event_summary !="" && $event.event_details ==""}
{$lang.summary}: {$event.event_summary}
{/if}
{if $event.event_details !="" && $event.event_details != "
"}
{$lang.details}: {eval var=$event.event_details}
{/if}
{$return_url}


-----------------------------------------------------------------------------------------------

I am in no way a PHP programmer... i know just enough to be dangerous.  I'm pretty sure this was working fine before i upgraded to Black Rock.  And i haven't touched the templates since i first setup the calendar.

any ideas what could be giving me this error?

Thanks in advance.