| |
Could not get last pic information
DEBUG MODE
SQL Error : 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'alfaforum.p.pic_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT p.pic_id, p.pic_title, p.pic_user_id, p.pic_username, p.pic_time, p.pic_cat_id, u.user_id, u.username, COUNT(c.comment_id) AS comment_count
FROM phpbb_album AS p,
phpbb_album_comment AS c
LEFT JOIN phpbb_users AS u ON u.user_id = u.user_id
WHERE p.pic_cat_id = '1'
GROUP BY p.pic_time
ORDER BY p.pic_time DESC
LIMIT 1
Line : 206
File : album.php |
| |
|
