mapknitter icon indicating copy to clipboard operation
mapknitter copied to clipboard

Database error due to unicode (Thai) string in map location field: "อำเภอปากช่อง นครราชสีมา"

Open sentry[bot] opened this issue 4 years ago • 2 comments

Sentry Issue: MAPKNITTER-4N

Mysql2::Error: Incorrect string value: '\xE0\xB8\xAD\xE0\xB8\xB3...' for column 'location' at row 1
  app/controllers/maps_controller.rb:48:in `create'
    if @map.save
...
(139 additional frame(s) were not displayed)

ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect string value: '\xE0\xB8\xAD\xE0\xB8\xB3...' for column 'location' at row 1: INSERT INTO `maps` (`name`, `lat`, `lon`, `created_at`, `updated_at`, `description`, `author`, `zoom`, `location`, `license`, `user_id`, `slug`) VALUES ('baan1699', 14.555765, 101.307485, '2021-05-04 07:30:53', '2021-05-04 07:30:53', 'yo', 'huirantoh', 14.0, '169 Moo 10, Gudkla-Phansuk Rd, Tambon Moosi, Pak Chong, อำเภอปากช่อง นครราชสีมา 30130, Thailand', 'publicdomain', 5550, 'baan1699')

sentry[bot] avatar May 04 '21 14:05 sentry[bot]

We may have to migrate like we did with Plots2, since this DB is a lot smaller it should be easier.

icarito avatar May 04 '21 15:05 icarito

OK!

This failed due to the unicode text in the location field:

"169 Moo 10, Gudkla-Phansuk Rd, Tambon Moosi, Pak Chong, อำเภอปากช่อง นครราชสีมา 30130, Thailand"

jywarren avatar May 04 '21 15:05 jywarren