Jue Mar 14, 2013 12:38 pm • a través de Web
Mod: cBB Blog 1.0.0-beta
Error: Al borrar una entrada, aparece un error SQL (Not values in SQL Comparision)
Solución:1. Abrir blog/includes/functions.php
2. Buscar:
- Código: Seleccionar todo
$sql = 'SELECT physical_filename
FROM ' . BLOG_ATTACHMENTS_TABLE . '
WHERE ' . $db->sql_in_set('physical_filename', array_keys($attach_ary));
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result))
{
unset($attach_ary[$row['physical_filename']]);
}
$db->sql_freeresult($result);
3. Reemplazar por:
- Código: Seleccionar todo
if(sizeof($attach_ary))
{
$sql = 'SELECT physical_filename
FROM ' . BLOG_ATTACHMENTS_TABLE . '
WHERE ' . $db->sql_in_set('physical_filename', array_keys($attach_ary));
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result))
{
unset($attach_ary[$row['physical_filename']]);
}
$db->sql_freeresult($result);
}