slim Posted October 11, 2007 Share Posted October 11, 2007 Hey guys, I was trying to sort the album by "Last Pic" and got the following error... Could not query usersDEBUG 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 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.