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
// Fix Andrew's track manually since callback wasn't processed
session_start();

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

echo "🔧 FIXING ANDREW'S TRACK: 8cd1c23483097cc26fac73049ea0302d\n\n";

// Include database configuration
require_once 'config/database.php';

$pdo = getDBConnection();
if (!$pdo) {
    echo "❌ Database connection failed\n";
    exit;
}

$taskId = '8cd1c23483097cc26fac73049ea0302d';

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

if (!$track) {
    echo "❌ Track not found in database\n";
    exit;
}

echo "📋 CURRENT TRACK STATUS:\n";
echo "Task ID: " . $track['task_id'] . "\n";
echo "Title: " . $track['title'] . "\n";
echo "Status: " . $track['status'] . "\n";
echo "Audio URL: " . $track['audio_url'] . "\n";
echo "User ID: " . $track['user_id'] . "\n\n";

// From the callback log, we know the track was generated successfully
// with two audio files. Let's update it to complete status with the proper audio URL
$audioUrl = '/audiofiles.php?id=' . $taskId;

// Update the track to complete status
$stmt = $pdo->prepare("
    UPDATE music_tracks 
    SET status = 'complete', 
        audio_url = ?, 
        duration = 10.16,
        updated_at = NOW()
    WHERE task_id = ?
");

$result = $stmt->execute([$audioUrl, $taskId]);

if ($result) {
    echo "✅ Track updated successfully!\n";
    echo "New status: complete\n";
    echo "New audio URL: " . $audioUrl . "\n";
    echo "Duration: 10.16 seconds\n\n";
    
    // Verify the update
    $stmt = $pdo->prepare("SELECT * FROM music_tracks WHERE task_id = ?");
    $stmt->execute([$taskId]);
    $updatedTrack = $stmt->fetch();
    
    echo "📋 UPDATED TRACK STATUS:\n";
    echo "Task ID: " . $updatedTrack['task_id'] . "\n";
    echo "Title: " . $updatedTrack['title'] . "\n";
    echo "Status: " . $updatedTrack['status'] . "\n";
    echo "Audio URL: " . $updatedTrack['audio_url'] . "\n";
    echo "Duration: " . $updatedTrack['duration'] . "\n";
    echo "Updated: " . $updatedTrack['updated_at'] . "\n\n";
    
    echo "🎵 TRACK SHOULD NOW BE PLAYABLE!\n";
    echo "✅ Status: complete\n";
    echo "✅ Audio URL: set\n";
    echo "✅ Duration: 10.16 seconds\n";
    echo "✅ Ready for playback\n\n";
    
    echo "🔗 TEST THE TRACK:\n";
    echo "Visit: https://soundstudiopro.com/audiofiles.php?id=" . $taskId . "\n";
    echo "Or play it in your library!\n";
    
} else {
    echo "❌ Failed to update track\n";
    $error = $stmt->errorInfo();
    echo "Error: " . $error[2] . "\n";
}

// Also save the callback data to task_results for backup
$callbackData = [
    'code' => 200,
    'data' => [
        'callbackType' => 'complete',
        'task_id' => $taskId,
        'data' => [
            [
                'audio_url' => 'https://apiboxfiles.erweima.ai/ZDNlMGIxYTctZjQyYS00ZGJjLWIxYzMtNDNkNTBjYmFjYjQ5.mp3',
                'duration' => 10.16,
                'id' => 'd3e0b1a7-f42a-4dbc-b1c3-43d50cbacb49',
                'prompt' => 'a happy song about andrew',
                'title' => 'Generated Track'
            ],
            [
                'audio_url' => 'https://apiboxfiles.erweima.ai/ZDEzZDI0ODktYzg1My00MWI2LWIyZDEtNzRjZTFlNWMxYmFi.mp3',
                'duration' => 9.84,
                'id' => 'd13d2489-c853-41b6-b2d1-74ce1e5c1bab',
                'prompt' => 'a happy song about andrew',
                'title' => 'Generated Track'
            ]
        ]
    ],
    'msg' => 'All generated successfully.'
];

$resultFile = "task_results/{$taskId}.json";
if (!is_dir('task_results')) {
    mkdir('task_results', 0755, true);
}

file_put_contents($resultFile, json_encode($callbackData, JSON_PRETTY_PRINT), LOCK_EX);
echo "✅ Callback data saved to: " . $resultFile . "\n\n";

echo "🎉 ANDREW'S TRACK IS NOW FIXED!\n";
echo "✅ Database updated\n";
echo "✅ Audio URL set\n";
echo "✅ Status: complete\n";
echo "✅ Ready for playback\n";
?>