Debug de Subida de Cover (PostgreSQL)";
// 1. Verificar configuración de base de datos
echo "1. Configuración de Base de Datos
";
$db_config = [
'hostname' => 'localhost',
'username' => 'postgres',
'password' => '1234',
'database' => 'db_chamba_produccion',
'dbdriver' => 'postgres'
];
try {
$pdo = new PDO("pgsql:host={$db_config['hostname']};dbname={$db_config['database']}",
$db_config['username'], $db_config['password']);
echo "✅ Conexión a BD exitosa
";
} catch (PDOException $e) {
echo "❌ Error de conexión: " . $e->getMessage() . "
";
}
// 2. Verificar tabla y campo (PostgreSQL)
echo "2. Estructura de Tabla
";
$stmt = $pdo->query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'tbl_usuarios'");
if ($stmt->rowCount() > 0) {
echo "✅ Tabla tbl_usuarios existe
";
$stmt = $pdo->query("SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'tbl_usuarios' AND column_name = 'img_cover'");
if ($stmt->rowCount() > 0) {
echo "✅ Campo img_cover existe
";
$column = $stmt->fetch(PDO::FETCH_ASSOC);
echo " - Tipo: " . $column['data_type'] . "
";
echo " - Null: " . $column['is_nullable'] . "
";
} else {
echo "❌ Campo img_cover NO existe
";
// Mostrar campos existentes relacionados con imágenes
echo "
Campos de imagen existentes:
";
$stmt = $pdo->query("SELECT column_name, data_type FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'tbl_usuarios' AND (column_name LIKE '%img%' OR column_name LIKE '%image%') ORDER BY column_name");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo " - " . $row['column_name'] . ": " . $row['data_type'] . "
";
}
}
} else {
echo "❌ Tabla tbl_usuarios NO existe
";
// Mostrar tablas disponibles
echo "
Tablas disponibles:
";
$stmt = $pdo->query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name LIMIT 10");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo " - " . $row['table_name'] . "
";
}
}
// 3. Verificar directorios
echo "3. Directorios de Upload
";
$upload_paths = [
'./uploads/',
'./uploads/community/',
'./uploads/community/covers/',
'./uploads/community/covers/thumbs/'
];
foreach ($upload_paths as $path) {
if (is_dir($path)) {
echo "✅ $path existe (permisos: " . substr(sprintf('%o', fileperms($path)), -4) . ")
";
} else {
echo "❌ $path NO existe
";
}
}
// 4. Verificar extensiones PHP
echo "4. Extensiones PHP
";
$required_extensions = ['gd', 'mysqli', 'json'];
foreach ($required_extensions as $ext) {
if (extension_loaded($ext)) {
echo "✅ Extensión $ext cargada
";
} else {
echo "❌ Extensión $ext NO cargada
";
}
}
// 5. Verificar configuración de PHP
echo "5. Configuración PHP
";
echo "upload_max_filesize: " . ini_get('upload_max_filesize') . "
";
echo "post_max_size: " . ini_get('post_max_size') . "
";
echo "max_execution_time: " . ini_get('max_execution_time') . "
";
echo "memory_limit: " . ini_get('memory_limit') . "
";
// 6. Probar el controlador directamente
echo "6. Prueba del Controlador
";
echo "";
echo "7. Verificar Rutas
";
echo "Base URL: " . (function_exists('base_url') ? base_url() : 'No disponible') . "
";
echo "SCRIPT_NAME: " . $_SERVER['SCRIPT_NAME'] . "
";
echo "REQUEST_URI: " . $_SERVER['REQUEST_URI'] . "
";
} catch (Exception $e) {
echo "❌ Error general: " . $e->getMessage() . "
";
echo "Stack trace:
" . $e->getTraceAsString() . "
";
}
?>