|
|
Error Can't create/write to file '/tmp/#sql_2c8d_2.MYD' (Errcode: 17) in query
SELECT SQL_CALC_FOUND_ROWS
noticias.*,
YEAR(noticias.fecha) AS anio,
MONTH(noticias.fecha) AS mes,
noticias_traduccion.titulo,
noticias_traduccion.copete,
noticias_traduccion.descripcion,
noticias_traduccion.palabras_clave,
noticias_traduccion.notas,
tpreview.id_foto,
tpreview.filename,
tpreview.desc_foto
FROM
noticias
INNER JOIN noticias_traduccion ON (noticias.id=noticias_traduccion.id_noticia)
LEFT JOIN (SELECT * FROM (
SELECT
id_galeria AS id_noticia,
id AS id_foto,
orden,
filename,
noticias_fotos_traduccion.texto1 AS desc_foto
FROM
noticias_fotos
INNER JOIN noticias_fotos_traduccion ON (noticias_fotos.id=noticias_fotos_traduccion.id_foto)
WHERE
habilitado=1 AND
(noticias_fotos_traduccion.id_idioma = 2)
ORDER BY principal DESC, orden, id DESC) t GROUP BY t.id_noticia) tpreview ON (tpreview.id_noticia=noticias.id)
WHERE
(noticias_traduccion.id_idioma = 2) AND
(noticias.habilitada=1) AND
(noticias_traduccion.idioma_habilitado=1)
ORDER BY
noticias.fecha DESC LIMIT 0,12. In file in line . Date: 2012-05-20 19:43:47
Fatal error: Call to a member function fetch_array() on a non-object in /home/cppropie/properties-uruguayNEW.com/noticias/noticias.php on line 37
| |
|
|
|