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

Unable to update the row: ApolloError: no rows were updated #230

Closed amirsaam closed 1 week ago

amirsaam commented 2 weeks ago

This is my error when trying to edit a row value of a MariaDB database table. Can be edited in Adminer with no issue

hkdeman commented 2 weeks ago

Thank you for trying WhoDB! Could you please expand on what row value you were saving and what type it was. May be share the schema of the table or an obfuscated version of it?

amirsaam commented 1 week ago

Unfortunately I have removed WhoDB and rollback to Adminer for now because of limited server resources.

But as I remember there were no error log, the row was a string and I've give it none than a string, also the schema is a plain WordPress table.

hkdeman commented 1 week ago

Ohh I see. That is completely understandable. I hope Adminer was able to resolver your issues. I will be looking into it so that we can enhance your experience!

hkdeman commented 1 week ago

Thank you for waiting! We have merged the fix for this: https://github.com/clidey/whodb/pull/239

Hope it helps! This should be available as the latest version when the Clidey Flow finishes: Clidey build status

amirsaam commented 1 week ago

@hkdeman Thanks for your effort, I'll check it out as soon as I can.

hkdeman commented 1 week ago

Feel free to open the issue if it persists!