Home    Forum    Search    FAQ   
Register    Log in
Critical Information
SQL ERROR [ mysql4 ]

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'guardian_foros.p.pic_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]


SELECT c.cat_id, p.pic_id, COUNT(p.pic_id) AS pic_total FROM ip_album AS p, ip_album_cat AS c WHERE c.cat_id IN (1) AND p.pic_cat_id = c.cat_id AND p.pic_time >= 1540042560 GROUP BY c.cat_id


FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/album_mod/album_hierarchy_sql.php
LINE: 584
CALL: sql_db->sql_query()

FILE: includes/album_mod/album_hierarchy_functions.php
LINE: 230
CALL: album_no_newest_pictures()

FILE: includes/album_mod/album_hierarchy_functions.php
LINE: 1293
CALL: album_build_index()

FILE: album.php
LINE: 255
CALL: album_display_index()