I'm sorry the error isn't caused by the query it's being caused by this:
$Times->getColumnVal('start_time')
Why?
This works:
function fcdb_query_events($start, $end) {
global $calendar_events, $view;
$result = array();
while(!$calendar_events->atEnd()) {
$item = new stdClass;
$item->id = $calendar_events->getColumnVal('id');
$item->name = $calendar_events->getColumnVal('name');
$item->name = is_numeric($calendar_events->getColumnVal('name')) ? $calendar_events->getColumnVal('UserFirstName').' '.$calendar_events->getColumnVal('UserLastName').' '.$calendar_events->getColumnVal('UserPhone') : $calendar_events->getColumnVal('name');
$item->description = $calendar_events->getColumnVal('description');
$item->recurrence = $calendar_events->getColumnVal('recurrence');
$item->start_date = $calendar_events->getColumnVal('start_date') . ' ' . $calendar_events->getColumnVal('start_time');
$item->end_date = $calendar_events->getColumnVal('end_date') . ' ' . $calendar_events->getColumnVal('end_time');
$item->repeat = $calendar_events->getColumnVal('repeats');
$item->repeat_on = is_int($calendar_events->getColumnVal('repeat_on')) ? ('x'.$calendar_events->getColumnVal('repeat_on')) : "";
$item->repeat_every = $calendar_events->getColumnVal('repeat_every') . $item->repeat_on;
$item->occurrence = $calendar_events->getColumnVal('occurrence');
$item->occurrence_end = $calendar_events->getColumnVal('occurrence_end');
$item->repeat_key = $calendar_events->getColumnVal('repeat_key');
$item->attribute = $calendar_events->getColumnVal('attribute');
$item->allDay = false;
$item->event_id = $calendar_events->getColumnVal('event_id');
$result[] = $item;
$calendar_events->moveNext();
But this doesn't:
function fcdb_query_events($start, $end) {
global $calendar_events, $view;
$result = array();
while(!$calendar_events->atEnd()) {
$item = new stdClass;
$item->id = $calendar_events->getColumnVal('id');
$item->name = $calendar_events->getColumnVal('name');
$item->name = is_numeric($calendar_events->getColumnVal('name')) ? $calendar_events->getColumnVal('UserFirstName').' '.$calendar_events->getColumnVal('UserLastName').' '.$calendar_events->getColumnVal('UserPhone') : $calendar_events->getColumnVal('name');
$item->description = $calendar_events->getColumnVal('description');
$item->recurrence = $calendar_events->getColumnVal('recurrence');
$item->start_date = $calendar_events->getColumnVal('start_date') . ' ' . $Times->getColumnVal('start_time');
$item->end_date = $calendar_events->getColumnVal('end_date') . ' ' . $Times->getColumnVal('end_time');
$item->repeat = $calendar_events->getColumnVal('repeats');
$item->repeat_on = is_int($calendar_events->getColumnVal('repeat_on')) ? ('x'.$calendar_events->getColumnVal('repeat_on')) : "";
$item->repeat_every = $calendar_events->getColumnVal('repeat_every') . $item->repeat_on;
$item->occurrence = $calendar_events->getColumnVal('occurrence');
$item->occurrence_end = $calendar_events->getColumnVal('occurrence_end');
$item->repeat_key = $calendar_events->getColumnVal('repeat_key');
$item->attribute = $calendar_events->getColumnVal('attribute');
$item->allDay = false;
$item->event_id = $calendar_events->getColumnVal('event_id');
$result[] = $item;
$calendar_events->moveNext();