Home   |   Menu   |   Discuss   |   Search   |   Join   |   Log in   

General Error
General Error

Could not query users


SQL Error : 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'allyie_nature.p.pic_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT u.username, u.user_id, u.user_regdate, COUNT(p.pic_id) AS pics, p.pic_title, p.pic_time, MAX(p.pic_id) AS last_pic FROM orion_users AS u, orion_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 DESC LIMIT 0, 24

Line : 424
File : album.php

site build by matt j
based on phpBB/ cback orion