mapknitter
mapknitter copied to clipboard
Database error due to unicode (Thai) string in map location field: "อำเภอปากช่อง นครราชสีมา"
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')
We may have to migrate like we did with Plots2, since this DB is a lot smaller it should be easier.
OK!
This failed due to the unicode text in the location field:
"169 Moo 10, Gudkla-Phansuk Rd, Tambon Moosi, Pak Chong, อำเภอปากช่อง นครราชสีมา 30130, Thailand"