TimPrimmer / parktime-app

Group project for UT Full Stack Web Dev bootcamp
3 stars 3 forks source link

Bug/saving park #128

Closed emholmes closed 3 years ago

emholmes commented 3 years ago

Getting the error when trying to save: _sqlState: '42000', sqlMessage: "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'parktime_db.saved_parks.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", sql: "SELECT id, user_id, park_id FROM saved_parks AS saved_parks WHERE saved_parks.user_id = '3' AND saved_parks.park_id = '384' GROUP BY user_id, park_id;",_

I'm not sure that the group by clause is necessary, but could be wrong. Found this article about the error that I think it helpful: https://www.aaronsaray.com/2019/expression-1-not-in-group-by and the top answer on this post is also helpful: https://stackoverflow.com/questions/38705315/mysql-error-select-list-is-not-in-group-by-clause I tested with this clause commented out and the saving worked as expected. **also fixed styling on the Save/Saved text so that the clickable portion is contained to the text only