-4

My Sql Query:

SELECT game_id, game_name_tr, game_name_en, game_url_tr, game_url_en, game_small_image, category_name_tr, category_name_en, category_url_tr, category_url_en, user_name, user_url, score_point FROM web_game_scores
                                                           INNER JOIN web_users ON web_game_scores.score_user_id=web_users.user_id 
                                                           INNER JOIN web_game_categories ON web_game_scores.score_game_category_id=web_game_categories.category_id
                                                           INNER JOIN web_games ON web_games.game_id=web_game_scores.score_game_id  
                                                           GROUP BY web_games.game_id ORDER BY web_game_scores.score_date DESC LIMIT 5

I get this error:

Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mysqldbase.web_game_categories.category_name_tr' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Please help me.

I try everyhing. Anything

Php Master
  • 1
  • 2

1 Answers1

0

I solved my problem myself. I added all the database fields in the SELECT partition to the GROUP BY partition and the problem went away.

Php Master
  • 1
  • 2
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 28 '23 at 17:50