JSON-related error while editing the row

[ArtikTheOnlyOne]

Adminer version: 5.3.0
Compiled: single file
Driver: PostgreSQL
Database version: PostgreSQL 16.9
Plugins used: None

Good day. I have a column, which holds a JSON with a list of phone numbers, and Adminer is not capable of displaying it. Please find the archive with the screenshot and the SQL dump file attached. The issue occurs in different forms on almost every row while attempting to edit it.

adminer.zip

I am relatively new to databases, so I admit that it might be a user error. I would appreciate any help. Thank you

[vrana]

You don't have primary or unique key defined on the table. Adminer then needs to compare all fields which fails for JSON.

[ArtikTheOnlyOne]

Good day Thank you for your response I see. Is there anything I can do to fix this without changing the table structure? Thank you ср, 18 черв. 2025 р., 10:02 користувач Jakub Vrána ***@***.***> пише:

…

Closed #1107 <#1107> as completed via 2b52a9b <2b52a9b> . — Reply to this email directly, view it on GitHub <#1107 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5VZUY4F7QJGJW7W7DES2W33EEFGXAVCNFSM6AAAAAB6LILMKGVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJYGIYDIMBWGEYDMMA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[vrana]

Wait for the next Adminer release where this is fixed. You can also manually remove the column from the the edit URL.