HostOnNet Blog

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

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 hostonnet2

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.

  • Masud Rana

    Very helpful.Thanks.

  • MihanTranslate.com

    Thank you so much