any idee what im doing wrong
thx Leto
- Code: Select all
General Error
SQL ERROR [ mysql4 ]
Unknown column 'pic_time' in 'order clause' [1054]
SQL
SELECT p.image_id, p.image_name, p.image_user_id, p.image_user_ip, p.image_username, p.image_time, p.image_album_id, p.image_view_count, p.image_lock, p.image_approval, u.user_id, u.username, r.rate_image_id, AVG(r.rate_point) AS rating, COUNT(c.comment_id) AS comments, MAX(c.comment_id) AS new_comment FROM phpbb_gallery_images AS p LEFT JOIN phpbb_users AS u ON p.image_user_id = u.user_id LEFT JOIN phpbb_gallery_rates AS r ON p.image_id = r.rate_image_id LEFT JOIN phpbb_gallery_comments AS c ON p.image_id = c.comment_image_id WHERE p.image_album_id = 2 GROUP BY p.image_id ORDER BY pic_time DESC LIMIT 15
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: gallery/mcp.php
LINE: 211
CALL: dbal_mysql->sql_query()
