Sorting pictures in the Album

[slim]

Hey guys,

I was trying to sort the album by "Last Pic" and got the following error...

Could not query users

DEBUG MODE

SQL Error : 1054 Unknown column 'last_pic' in 'order clause'

SELECT u.username, u.user_id, u.user_regdate, MAX(p.pic_id) as pic_id, p.pic_title, p.pic_user_id, COUNT(p.pic_id) AS pics, MAX(p.pic_time) as pic_time FROM phpbb_users AS u, phpbb_album as p WHERE u.user_id <> -1 AND u.user_id = p.pic_user_id AND p.pic_cat_id = 0 GROUP BY user_id ORDER BY last_pic ASC LIMIT 0, 50

Line : 151

File : album_personal_index.php

Sounds like a typo or a DB structure problem to me but what do I know?

Stuart