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/4f941519/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
require_once 'config/database.php';

echo "<h2>🔍 Audio Variations Table Structure</h2>";

try {
    $pdo = getDBConnection();
    if (!$pdo) {
        echo "❌ Database connection failed";
        exit;
    }
    
    // Check the actual structure
    echo "<h3>📊 Table Structure:</h3>";
    $stmt = $pdo->query("DESCRIBE audio_variations");
    $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    foreach ($columns as $col) {
        echo "<strong>{$col['Field']}</strong> - {$col['Type']}<br>";
    }
    
    // Test a simple query without metadata
    echo "<h3>📊 Test Query (without metadata):</h3>";
    $stmt = $pdo->prepare("
        SELECT 
            variation_index,
            audio_url,
            duration,
            title,
            tags,
            image_url,
            source_audio_url,
            created_at
        FROM audio_variations 
        WHERE track_id = 3
        ORDER BY variation_index ASC
    ");
    $stmt->execute();
    $variations = $stmt->fetchAll();
    
    echo "Found " . count($variations) . " variations for Track 3<br>";
    
    if (!empty($variations)) {
        foreach ($variations as $var) {
            echo "- Variation {$var['variation_index']}: {$var['audio_url']} (Duration: {$var['duration']})<br>";
            
            // Check if file exists
            $file_path = str_replace('/audio_files/', 'audio_files/', $var['audio_url']);
            if (file_exists($file_path)) {
                echo "  ✅ File exists: {$file_path}<br>";
            } else {
                echo "  ❌ File missing: {$file_path}<br>";
            }
        }
    }
    
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>