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/55be918b/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
// Debug Task ID Mismatch
require_once 'config/database.php';

echo "<h1>🔍 Debugging Task ID Mismatch</h1>";

$pdo = getDBConnection();
if (!$pdo) {
    echo "<p style='color: red;'>❌ Database connection failed</p>";
    exit;
}

echo "<p style='color: green;'>✅ Database connected</p>";

// Check what task IDs are in the database
echo "<h2>📋 Task IDs in Database</h2>";

try {
    $stmt = $pdo->query("
        SELECT 
            mt.id,
            mt.title,
            mt.task_id,
            mt.variations_count,
            COUNT(av.id) as actual_variations
        FROM music_tracks mt
        LEFT JOIN audio_variations av ON mt.id = av.track_id
        WHERE mt.variations_count > 0
        GROUP BY mt.id
        ORDER BY mt.id ASC
        LIMIT 10
    ");
    
    $tracks = $stmt->fetchAll();
    
    if (!empty($tracks)) {
        echo "<table border='1' style='border-collapse: collapse; width: 100%; margin: 20px 0;'>";
        echo "<tr style='background: #f0f0f0;'>";
        echo "<th>Track ID</th><th>Title</th><th>Task ID</th><th>Variations Count</th><th>Actual Variations</th>";
        echo "</tr>";
        
        foreach ($tracks as $track) {
            echo "<tr>";
            echo "<td>{$track['id']}</td>";
            echo "<td>" . htmlspecialchars($track['title']) . "</td>";
            echo "<td>{$track['task_id']}</td>";
            echo "<td>{$track['variations_count']}</td>";
            echo "<td>{$track['actual_variations']}</td>";
            echo "</tr>";
        }
        echo "</table>";
    }
    
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Error getting tracks: " . $e->getMessage() . "</p>";
}

// Check what files are actually downloaded
echo "<h2>📁 Downloaded Audio Files</h2>";

$audioDir = 'audio_files/';
if (is_dir($audioDir)) {
    $audioFiles = scandir($audioDir);
    $audioFiles = array_filter($audioFiles, function($file) {
        return $file !== '.' && $file !== '..' && pathinfo($file, PATHINFO_EXTENSION) === 'mp3';
    });
    
    echo "<p><strong>Total audio files:</strong> " . count($audioFiles) . "</p>";
    
    // Group files by type
    $mainFiles = [];
    $variationFiles = [];
    
    foreach ($audioFiles as $file) {
        if (strpos($file, '_variation_') !== false) {
            $variationFiles[] = $file;
        } else {
            $mainFiles[] = $file;
        }
    }
    
    echo "<p><strong>Main track files:</strong> " . count($mainFiles) . "</p>";
    echo "<p><strong>Variation files:</strong> " . count($variationFiles) . "</p>";
    
    // Show first few variation files
    echo "<h3>Sample Variation Files:</h3>";
    echo "<ul>";
    foreach (array_slice($variationFiles, 0, 10) as $file) {
        echo "<li>{$file}</li>";
    }
    if (count($variationFiles) > 10) {
        echo "<li>... and " . (count($variationFiles) - 10) . " more</li>";
    }
    echo "</ul>";
    
    // Show first few main files
    echo "<h3>Sample Main Track Files:</h3>";
    echo "<ul>";
    foreach (array_slice($mainFiles, 0, 10) as $file) {
        echo "<li>{$file}</li>";
    }
    if (count($mainFiles) > 10) {
        echo "<li>... and " . (count($mainFiles) - 10) . " more</li>";
    }
    echo "</ul>";
    
} else {
    echo "<p style='color: red;'>❌ Audio files directory not found</p>";
}

// Try to find a match between database task IDs and filenames
echo "<h2>🔍 Trying to Find Matches</h2>";

try {
    // Get a sample track with variations
    $stmt = $pdo->query("
        SELECT 
            mt.id,
            mt.title,
            mt.task_id,
            mt.variations_count
        FROM music_tracks mt
        WHERE mt.variations_count > 0
        ORDER BY mt.id ASC
        LIMIT 1
    ");
    
    $sampleTrack = $stmt->fetch();
    
    if ($sampleTrack) {
        echo "<p><strong>Sample Track:</strong></p>";
        echo "<ul>";
        echo "<li>Track ID: {$sampleTrack['id']}</li>";
        echo "<li>Title: {$sampleTrack['title']}</li>";
        echo "<li>Task ID: {$sampleTrack['task_id']}</li>";
        echo "<li>Variations Count: {$sampleTrack['variations_count']}</li>";
        echo "</ul>";
        
        // Look for files that might match this task ID
        if (!empty($sampleTrack['task_id'])) {
            $taskId = $sampleTrack['task_id'];
            echo "<p><strong>Looking for files matching task ID:</strong> {$taskId}</p>";
            
            $matchingFiles = [];
            foreach ($audioFiles as $file) {
                if (strpos($file, $taskId) !== false) {
                    $matchingFiles[] = $file;
                }
            }
            
            if (!empty($matchingFiles)) {
                echo "<p style='color: green;'>✅ Found matching files:</p>";
                echo "<ul>";
                foreach ($matchingFiles as $file) {
                    echo "<li>{$file}</li>";
                }
                echo "</ul>";
            } else {
                echo "<p style='color: red;'>❌ No files found matching task ID: {$taskId}</p>";
                
                // Try to find files that might be related
                echo "<p><strong>Looking for similar files:</strong></p>";
                $similarFiles = [];
                foreach ($audioFiles as $file) {
                    if (strpos($file, substr($taskId, 0, 8)) !== false) {
                        $similarFiles[] = $file;
                    }
                }
                
                if (!empty($similarFiles)) {
                    echo "<p style='color: orange;'>⚠️ Found files with similar IDs:</p>";
                    echo "<ul>";
                    foreach ($similarFiles as $file) {
                        echo "<li>{$file}</li>";
                    }
                    echo "</ul>";
                } else {
                    echo "<p style='color: red;'>❌ No similar files found either</p>";
                }
            }
        }
    }
    
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Error analyzing sample track: " . $e->getMessage() . "</p>";
}

echo "<hr>";
echo "<p><em>Debug completed at: " . date('Y-m-d H:i:s') . "</em></p>";
?>