HostOnNet Blog

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available

Looking for Linux Server Admin or WordPress Expert? We can help.

After trying to install one of the classified script, i tried to login to admin area with default login details.

But it showing ‘Invalid username/password. Login failed’

So I went into cPanel and opened phpmyadmin to reset the password and now apparently mysql won’t allow me to edit the tables.

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

I fixed the issue using the below method.

Go to phpmyadmin -> password table – > Structure => click Unique (dropdown menu) and click Index.

Check screenshot for better understanding

phpmyadmin

About Sibi Antony

Bootstrap and Android LOVER. I've been creating things for the web for over 10 years, from the period of flash and table based layout web sites till mobile and tab friendly web sites.
Posted in MySQL. Bookmark the permalink.

2 Responses to This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.