debug_insert.php

<?php
require 'includes/config.php';
require 'includes/progress_helper.php';

$username = 'test_user';
$courseId = 'TEST_COURSE';
$toolId = 1;
$activityType = 'test_activity';

try {
    echo "Attempting insert...\n";
    $success = markActivityComplete($con, $username, $courseId, $toolId, $activityType);
    if ($success) {
        echo "Success!\n";
    } else {
        echo "Failed. Check error log.\n";
        // Let's try to get the error explicitly
        $stmt = $con->prepare(
            "INSERT INTO user_course_progress 
             (username, course_id, tool_id, activity_type, is_completed, completed_at)
             VALUES (?, ?, ?, ?, 1, NOW())
             ON DUPLICATE KEY UPDATE 
             is_completed = 1, 
             completed_at = NOW()"
        );
        if (!$stmt->execute([$username, $courseId, $toolId, $activityType])) {
            print_r($stmt->errorInfo());
        }
    }
} catch (Exception $e) {
    echo "Exception: " . $e->getMessage() . "\n";
}
?>