logo wikipedals
Search Brands Types Collections Pedalboards Sign Up Follow Us
Error in MySQL
Query: SELECT SQL_CALC_FOUND_ROWS * FROM user_to_buckets u RIGHT JOIN fx_to_bucket f ON f.utb_id = u.utb_id WHERE EXISTS ( SELECT count(*) as tots FROM fx_to_bucket fx WHERE fx.utb_id = u.utb_id HAVING tots > 1 ) AND (u.utb_collection = 0 OR u.utb_collection IS NULL) AND (u.utb_name != '' OR u.utb_desc != '') AND u.utb_live = 1 AND u.user_id = 9336 GROUP BY f.utb_id ORDER BY u.utb_date DESC LIMIT 6 OFFSET ?
Error
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wikipedals_db.f.ftb_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by