search

publiclab / plots2

a collaborative knowledge-exchange platform in Rails; we welcome first-time contributors! :balloon:
https://publiclab.org
GNU General Public License v3.0
957 stars 1.84k forks source link

ActiveRecord::StatementInvalid: Mysql2::Error #5592

Open siaw23-retired opened 5 years ago

siaw23-retired commented 5 years ago

https://sentry.io/share/issue/0abeb7d376b2479a9ebbdd9f64d04a50/

Two possible solutions to this:

  1. Sanitise (scrub) data before they are saved to DB.
  2. Set the encoding at DB level (this can be done with a migration) to accommodate values that trigger this error.

Anyone wants a shot at this?

grvsachdeva commented 5 years ago

+1 for sanitizing data

damiecode commented 3 years ago

Hi, @gauravano @jywarren I want to work on this issue.