=========================================== 🔍 DIAGNÓSTICO: Videos Ocurrencia #1138 =========================================== 1️⃣ DATOS EN BASE DE DATOS ------------------------------------------- 📋 Ocurrencia ID: 1138 📋 External ID: AGT-001220 📋 DNI Sereno: 48883953 2️⃣ CONTENIDO DE mul_url_remoto ------------------------------------------- ⚠️ mul_url_remoto está VACÍO 3️⃣ ARCHIVOS FÍSICOS EN STORAGE ------------------------------------------- 📸 ✅ storage/app/public/multimedia/48883953/1138/fotos → 48bdc090932072b48b2eb1755f3bd79e.jpg (176.77 KB) 🎥 ✅ storage/app/public/multimedia/48883953/1138/videos → 5dbad596805922aa5f325136c2c392b6.mp4 (18948.77 KB) 🎵 ❌ Carpeta NO existe: storage/app/public/multimedia/48883953/1138/audios 4️⃣ VERIFICAR SUPABASE STORAGE ------------------------------------------- 📋 External ID: AGT-001220 📋 Supabase ID extraído: 001220 📋 DNI Sereno: 48883953 ❌ Credenciales de Supabase no configuradas en .env 5️⃣ TABLA MULTIMEDIA -------------------------------------------
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'valcozanet_ocurrencias_mdnch.multimedia' doesn't exist (Connection: mysql, SQL: select * from `multimedia` where `ocurrencia_id` = 1138)
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():3172}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get()check_videos_1138.php197echo "5️⃣ TABLA MULTIMEDIA\n";198echo "-------------------------------------------\n";199200$multimedia = DB::table('multimedia')201 ->where('ocurrencia_id', $ocurrenciaId)202 ->get();203204if ($multimedia->isEmpty()) {205 echo "⚠️ No hay registros en tabla multimedia para esta ocurrencia\n\n";206} else {207 echo "📊 Total registros: " . $multimedia->count() . "\n\n";208 209 $tiposCounts = [210 'foto' => 0,211 'video' => 0,212 'audio' => 0,213 'otro' => 0214select * from `ocurrencias` where `id` = 1138 limit 1