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/6c336190/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

echo "<h2>🔍 Variations Debug - Database Check</h2>";

try {
    // Check what fields exist in music_tracks
    echo "<h3>📊 music_tracks table structure:</h3>";
    $stmt = $pdo->query("DESCRIBE music_tracks");
    $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($columns as $col) {
        if (strpos($col['Field'], 'variation') !== false) {
            echo "<strong>{$col['Field']}</strong> - {$col['Type']}<br>";
        }
    }
    
    // Check what fields exist in audio_variations
    echo "<h3>📊 audio_variations 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>";
    }
    
    // Check sample data
    echo "<h3>📊 Sample track data:</h3>";
    $stmt = $pdo->query("SELECT id, title, variations_count, variation_count FROM music_tracks LIMIT 5");
    $tracks = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($tracks as $track) {
        echo "Track {$track['id']}: '{$track['title']}' - variations_count: {$track['variations_count']}, variation_count: {$track['variation_count']}<br>";
    }
    
    // Check if audio_variations has data
    echo "<h3>📊 audio_variations count:</h3>";
    $stmt = $pdo->query("SELECT COUNT(*) as total FROM audio_variations");
    $count = $stmt->fetch();
    echo "Total variations: {$count['total']}<br>";
    
    if ($count['total'] > 0) {
        echo "<h3>📊 Sample variations:</h3>";
        $stmt = $pdo->query("SELECT track_id, variation_index, audio_url FROM audio_variations LIMIT 5");
        $variations = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($variations as $var) {
            echo "Track {$var['track_id']} - Variation {$var['variation_index']}: {$var['audio_url']}<br>";
        }
    }
    
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>