Code: Select all
SQL ERROR [ mysql4 ]
Unknown column 'last_pic' in 'order clause' [1054]
SQL
SELECT u.username, u.user_id, u.user_regdate, MAX(p.image_id) as image_id, p.image_name, p.image_user_id, COUNT(p.image_id) AS pics, MAX(p.image_time) as image_time FROM phpbb_users AS u, phpbb_gallery_images as p WHERE u.user_id <> 1 AND u.user_id = p.image_user_id AND p.image_album_id = 0 GROUP BY user_id ORDER BY last_pic ASC LIMIT 0, 15
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: gallery/album_personal_index.php
LINE: 97
CALL: dbal_mysql->sql_query()
Does anyone know what needs to be done to fix this?
