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/.cursor-server/data/User/History/32646c3d/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
// Enable error reporting
error_reporting(E_ALL);
ini_set('display_errors', 1);

echo "<h1>Library Debug Test</h1>";

// Test 1: Session
echo "<h2>Test 1: Session</h2>";
session_start();
echo "Session started: " . (session_status() === PHP_SESSION_ACTIVE ? "OK" : "FAILED") . "<br>";
echo "Session ID: " . session_id() . "<br>";
echo "User ID: " . ($_SESSION['user_id'] ?? 'NOT SET') . "<br>";

// Test 2: Database connection
echo "<h2>Test 2: Database Connection</h2>";
try {
    require_once 'config/database.php';
    $pdo = getDBConnection();
    if ($pdo) {
        echo "Database connection: OK<br>";
        
        // Test 3: User query
        echo "<h2>Test 3: User Query</h2>";
        if (isset($_SESSION['user_id'])) {
            $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
            $stmt->execute([$_SESSION['user_id']]);
            $user = $stmt->fetch();
            if ($user) {
                echo "User found: " . htmlspecialchars($user['name']) . "<br>";
                echo "User credits: " . $user['credits'] . "<br>";
            } else {
                echo "User not found<br>";
            }
        } else {
            echo "No user ID in session<br>";
        }
        
        // Test 4: Music tracks query
        echo "<h2>Test 4: Music Tracks Query</h2>";
        if (isset($_SESSION['user_id'])) {
            $stmt = $pdo->prepare("SELECT COUNT(*) as count FROM music_tracks WHERE user_id = ?");
            $stmt->execute([$_SESSION['user_id']]);
            $result = $stmt->fetch();
            echo "User tracks count: " . $result['count'] . "<br>";
            
            // Test the actual query that might be failing
            $stmt = $pdo->prepare("
                SELECT 
                    COUNT(*) as total_tracks,
                    COUNT(CASE WHEN status = 'complete' THEN 1 END) as completed_tracks,
                    COUNT(CASE WHEN status = 'processing' THEN 1 END) as processing_tracks,
                    AVG(CASE WHEN status = 'complete' THEN duration END) as avg_duration
                FROM music_tracks 
                WHERE user_id = ?
            ");
            $stmt->execute([$_SESSION['user_id']]);
            $user_stats = $stmt->fetch();
            echo "User stats query: OK<br>";
            echo "Total tracks: " . $user_stats['total_tracks'] . "<br>";
            echo "Completed tracks: " . $user_stats['completed_tracks'] . "<br>";
            echo "Processing tracks: " . $user_stats['processing_tracks'] . "<br>";
            echo "Avg duration: " . ($user_stats['avg_duration'] ?? 'N/A') . "<br>";
        }
        
    } else {
        echo "Database connection: FAILED<br>";
    }
} catch (Exception $e) {
    echo "Database error: " . $e->getMessage() . "<br>";
}

// Test 5: Function test
echo "<h2>Test 5: Function Test</h2>";
try {
    function getUserMusicTracks($pdo, $user_id, $limit = 50) {
        $stmt = $pdo->prepare("
            SELECT * FROM music_tracks 
            WHERE user_id = ? 
            ORDER BY created_at DESC 
            LIMIT ?
        ");
        $stmt->execute([$user_id, $limit]);
        return $stmt->fetchAll();
    }
    
    if (isset($_SESSION['user_id']) && $pdo) {
        $user_tracks = getUserMusicTracks($pdo, $_SESSION['user_id']);
        echo "Function test: OK<br>";
        echo "Tracks returned: " . count($user_tracks) . "<br>";
    } else {
        echo "Function test: SKIPPED (no user or DB)<br>";
    }
} catch (Exception $e) {
    echo "Function error: " . $e->getMessage() . "<br>";
}

echo "<h2>Test Complete</h2>";
?>