Calendar events table missing

The calendar_events table doesn't exist yet. Please run the migration:

db/schema-2g13.sql

Error: getMessage()) ?>

$id]); } catch (Throwable $e) { http_response_code(500); exit('Database error: ' . htmlspecialchars($e->getMessage())); } if (!$event) { http_response_code(404); exit('Event not found.'); } } $flash_error = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { csrf_verify(); $action = $_POST['action'] ?? 'save'; if ($action === 'delete' && $event) { db_exec('DELETE FROM calendar_events WHERE id = :id', ['id' => $event['id']]); header('Location: calendar.php?msg=' . urlencode('Event deleted.')); exit; } // Save / update $title = trim((string)($_POST['title'] ?? '')); $is_all_day = !empty($_POST['is_all_day']); $show_to_members = !empty($_POST['show_to_members']); $sd = trim((string)($_POST['starts_at_date'] ?? '')); $st = trim((string)($_POST['starts_at_time'] ?? '')); $ed = trim((string)($_POST['ends_at_date'] ?? '')); $et = trim((string)($_POST['ends_at_time'] ?? '')); if ($title === '') { $flash_error = 'Title is required.'; } elseif (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $sd)) { $flash_error = 'Start date is required.'; } elseif ($ed !== '' && !preg_match('/^\d{4}-\d{2}-\d{2}$/', $ed)) { $flash_error = 'End date format invalid.'; } else { if ($is_all_day) { // All-day → store midnight to end-of-day $starts_at = $sd . ' 00:00:00'; $ends_at = $ed !== '' ? $ed . ' 23:59:59' : $sd . ' 23:59:59'; } else { if (!preg_match('/^\d{2}:\d{2}$/', $st)) $st = '09:00'; $starts_at = $sd . ' ' . $st . ':00'; if ($ed !== '') { if (!preg_match('/^\d{2}:\d{2}$/', $et)) $et = '10:00'; $ends_at = $ed . ' ' . $et . ':00'; } else { $ends_at = null; } } // Sanity: if end is before start, swap if ($ends_at && strtotime($ends_at) < strtotime($starts_at)) { $flash_error = 'End date/time is before start date/time.'; } else { $payload = [ 'title' => mb_substr($title, 0, 200), 'starts_at' => $starts_at, 'ends_at' => $ends_at, 'is_all_day' => $is_all_day ? 1 : 0, 'show_to_members' => $show_to_members ? 1 : 0, ]; try { if ($event) { db_exec( "UPDATE calendar_events SET title = :title, starts_at = :starts_at, ends_at = :ends_at, is_all_day = :is_all_day, show_to_members = :show_to_members WHERE id = :id", $payload + ['id' => $event['id']] ); } else { db_insert('calendar_events', $payload + ['created_by' => $me['id']]); } // Redirect back to calendar, focused on the event's month $y = (int)date('Y', strtotime($starts_at)); $m = (int)date('n', strtotime($starts_at)); header("Location: calendar.php?y={$y}&m={$m}&msg=" . urlencode($event ? 'Event updated.' : 'Event added.')); exit; } catch (Throwable $e) { $flash_error = 'Save failed: ' . $e->getMessage(); if (function_exists('app_log')) app_log('event save failed: ' . $e->getMessage()); } } } } // Pre-fill values if ($event) { $v_title = $event['title']; $v_allday = (bool)$event['is_all_day']; $v_show = (bool)$event['show_to_members']; $v_sd = date('Y-m-d', strtotime($event['starts_at'])); $v_st = date('H:i', strtotime($event['starts_at'])); if (!empty($event['ends_at'])) { $v_ed = date('Y-m-d', strtotime($event['ends_at'])); $v_et = date('H:i', strtotime($event['ends_at'])); // If the end is set to 23:59:59 from a single-day all-day event, // and the start is the same day at midnight, treat as "no end" if ($v_allday && $v_ed === $v_sd) { $v_ed = ''; $v_et = ''; } } else { $v_ed = ''; $v_et = ''; } } else { $v_title = ''; $v_allday = true; $v_show = true; $v_sd = $_GET['date'] ?? date('Y-m-d'); $v_st = '09:00'; $v_ed = ''; $v_et = '10:00'; } // Preserve POSTed values on error if ($flash_error) { $v_title = $_POST['title'] ?? $v_title; $v_allday = !empty($_POST['is_all_day']); $v_show = !empty($_POST['show_to_members']); $v_sd = $_POST['starts_at_date'] ?? $v_sd; $v_st = $_POST['starts_at_time'] ?? $v_st; $v_ed = $_POST['ends_at_date'] ?? $v_ed; $v_et = $_POST['ends_at_time'] ?? $v_et; } $page_title = $event ? 'Edit event' : 'New event'; require __DIR__ . '/_guard.php'; ?>

← Back to calendar