Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/soundstudiopro.com/private_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
session_start();

// Temporarily bypass admin check for debugging
// if (!isset($_SESSION['user_id']) || !isset($_SESSION['is_admin']) || !$_SESSION['is_admin']) {
//     header('Location: /auth/login.php');
//     exit;
// }

echo "Starting admin debug...<br>";

// Test database connection
require_once 'config/database.php';
try {
    $pdo = getDBConnection();
    echo "Database connection: OK<br>";
    
    // Test a simple query
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM users");
    $result = $stmt->fetch();
    echo "Users count: " . $result['count'] . "<br>";
    
    // Test overall stats query
    $overall_stats = $pdo->query("
        SELECT 
            COUNT(*) as total_tracks,
            COUNT(CASE WHEN status = 'complete' THEN 1 END) as completed,
            COUNT(CASE WHEN status = 'processing' THEN 1 END) as processing,
            COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed,
            COUNT(CASE WHEN metadata IS NOT NULL AND metadata != '' THEN 1 END) as with_metadata,
            COUNT(CASE WHEN task_id IS NOT NULL THEN 1 END) as with_task_id,
            COUNT(CASE WHEN user_id IS NOT NULL THEN 1 END) as with_user,
            COUNT(CASE WHEN user_id IS NULL THEN 1 END) as orphaned
        FROM music_tracks
    ")->fetch();
    
    echo "Overall stats: " . print_r($overall_stats, true) . "<br>";
    
} catch (Exception $e) {
    echo "Database error: " . $e->getMessage() . "<br>";
    exit;
}

// Test current tab
$current_tab = $_GET['tab'] ?? 'dashboard';
echo "Current tab: " . $current_tab . "<br>";

// Test header include
try {
    include 'includes/header.php';
    echo "Header included successfully<br>";
} catch (Exception $e) {
    echo "Header error: " . $e->getMessage() . "<br>";
    exit;
}

echo "Debug completed successfully!";
?>