Schwarzes Hamburg

  • 23 Dezember 2024, 20:12:01
  • Willkommen Gast
Bitte logg dich ein oder registriere dich.

Einloggen mit Benutzername, Passwort und Sitzungslänge
Erweiterte Suche  

Autor Thema: Fehler beim Aufruf des Albums  (Gelesen 1415 mal)

Kortirion

  • > 1000 Posts
  • ***
  • Beiträge: 2301
Fehler beim Aufruf des Albums
« am: 25 Februar 2006, 06:12:38 »

Jetzt grade...Sa. 25.02 06.08 Uhr:

Could not query recent pics information

DEBUG MODE

SQL Error : 3 Error writing file '/var/log/mysql/mysql.log' (Errcode: 28)

SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM album AS p LEFT JOIN users AS u ON p.pic_user_id = u.user_id LEFT JOIN album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 4

Line : 259
File : /var/www/www.schwarzes-hamburg.com/album.php
Gespeichert
Man has always created his gods, rather than his gods creating him.