FotoAlbum MOd Sql Problem
Verfasst: 06.03.2005 20:26
Hallo,
auf der album.php zeigt er jetzt diesen Fehler an, (ich hatte bisher keine Probleme damit) kann mir jemand bitte weiterhelfen?
Could not get last pic information
DEBUG MODE
SQL Error : 1109 Unknown table 'p' in where clause
SELECT c.comment_pic_id, c.comment_user_id, c.comment_username, c.comment_time, u.user_id, u.username, a.pic_id, a.pic_cat_id FROM phpbb_album_comment AS c LEFT JOIN phpbb_users AS u ON c.comment_user_id = u.user_id LEFT JOIN phpbb_album AS a ON c.comment_pic_id = a.pic_id WHERE a.pic_cat_id = '11' AND p.pic_approval = 1 ORDER BY c.comment_time DESC LIMIT 1
Line : 199
File : /srv/www/htdocs/web44/html/album.php
auf der album.php zeigt er jetzt diesen Fehler an, (ich hatte bisher keine Probleme damit) kann mir jemand bitte weiterhelfen?
Could not get last pic information
DEBUG MODE
SQL Error : 1109 Unknown table 'p' in where clause
SELECT c.comment_pic_id, c.comment_user_id, c.comment_username, c.comment_time, u.user_id, u.username, a.pic_id, a.pic_cat_id FROM phpbb_album_comment AS c LEFT JOIN phpbb_users AS u ON c.comment_user_id = u.user_id LEFT JOIN phpbb_album AS a ON c.comment_pic_id = a.pic_id WHERE a.pic_cat_id = '11' AND p.pic_approval = 1 ORDER BY c.comment_time DESC LIMIT 1
Line : 199
File : /srv/www/htdocs/web44/html/album.php