+
Viernes
Máx. 22°C
Min. 14°C
Sábado
Máx. 27°C
Min. 14°C
Domingo
Máx. 24°C
Min. 17°C
|
|
Error Can't create/write to file '/tmp/#sql_6e83_4.MYD' (Errcode: 17) in query
SELECT SQL_CALC_FOUND_ROWS
eventos.*,
YEAR(eventos.fecha) AS anio,
MONTH(eventos.fecha) AS mes,
eventos_traduccion.nombre,
eventos_traduccion.copete,
eventos_traduccion.descripcion,
eventos_traduccion.palabras_clave,
tpreview.id_foto,
tpreview.filename,
tpreview.desc_foto,
adjuntos.cant AS adjuntos,
videos.cant AS cant_videos,
zonas.nombre AS nombre_zona,
departamentos.nombre AS nombre_ciudad
FROM
eventos
INNER JOIN eventos_traduccion ON (eventos.id=eventos_traduccion.id_evento)
LEFT JOIN (SELECT * FROM (
SELECT
id_galeria AS id_evento,
id AS id_foto,
orden,
filename,
eventos_fotos_traduccion.texto1 AS desc_foto
FROM
eventos_fotos
INNER JOIN eventos_fotos_traduccion ON (eventos_fotos.id=eventos_fotos_traduccion.id_foto)
WHERE
habilitado=1 AND
(eventos_fotos_traduccion.id_idioma = 1)
ORDER BY principal DESC, orden, id DESC) t GROUP BY t.id_evento) tpreview ON (tpreview.id_evento=eventos.id)
LEFT JOIN (select id_adjunto,count(id_adjunto) as cant from eventos_adjuntos group by id_adjunto) AS adjuntos ON (eventos.id=adjuntos.id_adjunto)
LEFT JOIN (select id_galeria_videos,count(id_galeria_videos) as cant from eventos_videos group by id_galeria_videos) AS videos ON (eventos.id=videos.id_galeria_videos)
LEFT OUTER JOIN zonas ON (eventos.id_zona = zonas.id)
LEFT OUTER JOIN departamentos ON (zonas.id_departamento = departamentos.id)
WHERE
(eventos_traduccion.id_idioma = 1) AND
(eventos.habilitado=1) AND
(eventos_traduccion.idioma_habilitado=1) AND (eventos.todas_las_zonas=1 OR (departamentos.id=117))
ORDER BY
eventos.fecha DESC,
eventos.orden,
eventos_traduccion.nombre LIMIT 0,12. In file in line . Date: 2010-03-11 05:32:31
Fatal error: Call to a member function fetch_array() on a non-object in /home/portalde/public_html/eventos/eventos.php on line 43
| |
|
|
|
