search

clidey / whodb

A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface
https://whodb.clidey.com
GNU General Public License v3.0
1.9k stars 56 forks source link

Update data failed with "Unable to update the row: ApolloError: Error 1292 (22007): Truncated incorrect DOUBLE value: 'id'" #229

Open gebing opened 3 weeks ago

gebing commented 3 weeks ago

When i edit the value for MYSQL field in data grid and submit to database, whodb popup an error message of "Unable to update the row: ApolloError: Error 1292 (22007): Truncated incorrect DOUBLE value: 'id'".

It seems whodb failed when trying convert MYSQL's table primary key of int type.

hkdeman commented 2 weeks ago

Thank you for pointing the bug out! Let us see why the casting is failing. Will get back soon. :)