Central Searchers Forum Index
  Home Page  •  Forum  •  Chatroom  •  Search  •  Album  •  Register  •  Profile  •  Log in to check your private messages  •  Log in
General Error
Could not query users


SQL Error : 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centrals_phpbb.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, 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 user_regdate ASC LIMIT 0, 50

Line : 151
File : album_personal_index.php

Powered by phpBB © 2001, 2005 phpBB Group