All geek questions in one place

PHPMyAdmin 4.0.5 - Grid editing, checkbox, editing, copying and deleting not available

I see this warning in PHPMyAdmin 4.0.5 "does not contain a unique column. Grid editing, checkbox, editing, copying and deleting are not available." In PHPMyAdmin 3.5.1, these parameters are displayed correctly using the same database. Can you fix it? How? thanks in advance Fabian.

+6
source share
2 answers

To fix this, select the appropriate column in the table and create a unique index on it (or on them). Version 4.0 added this check to avoid other problems if the intended line was not changed or deleted.

See http://en.wikipedia.org/wiki/Unique_key .

[EDIT] However, version 4.5.0 contains an improvement in this regard, see https://github.com/phpmyadmin/phpmyadmin/issues/11061

+16
source

You should be able to assign a primary key to the table. Just click the “Structure” tab when viewing the table you are trying to edit, select the field that you want to be the primary key, and there is a button to designate it as the primary key in one of the columns. Return to the view tab, and now you can edit the table.

+2
source

Source: https://habr.com/ru/post/953646/

More articles:


All Articles