Reilly
12-02-2005, 08:19 PM
Now when I click on the Messageboard Members Pics in the Album, I get this:
Could not query pics information
DEBUG MODE
SQL Error : 1054 Unknown column 'pic_new_comment' in 'order clause'
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, p.pic_lock, p.pic_approval, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id = '2' AND p.pic_approval = 1 GROUP BY p.pic_id ORDER BY pic_new_comment DESC LIMIT 25
Line : 341
File : /home/coldplay/public_html/forum/album_cat.php
Could not query pics information
DEBUG MODE
SQL Error : 1054 Unknown column 'pic_new_comment' in 'order clause'
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, p.pic_lock, p.pic_approval, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id = '2' AND p.pic_approval = 1 GROUP BY p.pic_id ORDER BY pic_new_comment DESC LIMIT 25
Line : 341
File : /home/coldplay/public_html/forum/album_cat.php