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/utils/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

$pdo = getDBConnection();

echo "<h2>Database Track Status</h2>";

// Get all tracks with their status
$stmt = $pdo->query("
    SELECT id, user_id, task_id, title, status, audio_url, created_at 
    FROM music_tracks 
    ORDER BY created_at DESC 
    LIMIT 10
");

$tracks = $stmt->fetchAll();

echo "<table border='1' style='border-collapse: collapse; width: 100%;'>";
echo "<tr><th>ID</th><th>User</th><th>Task ID</th><th>Title</th><th>Status</th><th>Audio URL</th><th>Created</th></tr>";

foreach ($tracks as $track) {
    echo "<tr>";
    echo "<td>" . $track['id'] . "</td>";
    echo "<td>" . $track['user_id'] . "</td>";
    echo "<td>" . substr($track['task_id'], 0, 20) . "...</td>";
    echo "<td>" . htmlspecialchars($track['title']) . "</td>";
    echo "<td style='color: " . ($track['status'] === 'complete' ? 'green' : ($track['status'] === 'failed' ? 'red' : 'orange')) . "'>" . $track['status'] . "</td>";
    echo "<td>" . ($track['audio_url'] ? 'Yes' : 'No') . "</td>";
    echo "<td>" . $track['created_at'] . "</td>";
    echo "</tr>";
}

echo "</table>";

// Check specific task from callback log
echo "<h3>Checking Task from Callback Log</h3>";
$task_id = '97b8373fd807c92b1b31209bb785a50c'; // From the callback log

$stmt = $pdo->prepare("SELECT * FROM music_tracks WHERE task_id = ?");
$stmt->execute([$task_id]);
$track = $stmt->fetch();

if ($track) {
    echo "<p style='color: green;'>✅ Found track in database!</p>";
    echo "<p>Track ID: " . $track['id'] . "</p>";
    echo "<p>Status: " . $track['status'] . "</p>";
    echo "<p>Audio URL: " . ($track['audio_url'] ?: 'None') . "</p>";
} else {
    echo "<p style='color: red;'>❌ Track not found in database</p>";
}
?>