|
Could not query pics information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0' at line 9
SELECT p.pic_id, p.pic_filename, 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 przemobb2_album AS p
LEFT JOIN przemobb2_users AS u ON (p.pic_user_id = u.user_id)
LEFT JOIN przemobb2_album_rate AS r ON (p.pic_id = r.rate_pic_id)
LEFT JOIN przemobb2_album_comment AS c ON (p.pic_id = c.comment_pic_id)
WHERE p.pic_cat_id = '16' AND p.pic_approval = 1
GROUP BY p.pic_id
ORDER BY
LIMIT 0
Line : 345 File : album_cat.php
Jeśli nie potrafisz znaleźć rozwiązania tego problemu, możesz spróbować poszukać, lub zadać pytanie na forum: http://www.przemo.org/phpBB2/ |
|
|