mySQL (phpMyAdmin) error : This table does not contain a unique column

If you face this error in phpMyAdmin and you can't change/edit the table fields.

If you sure you got error like this : 

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

 

So please execute next SQL query:

ALTER TABLE [tablename] add newid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

You can execute the query from GUI of phpMyAdmin or from SSH CLI using mysql command first.

Was this answer helpful?

 Print this Article

Also Read

Virtualmin

Virtualmin is a Webmin module for managing multiple virtual hosts through a single interface,...

DirectAdmin

LoginUse the next link for DA access:<Your_IP>:2222user admin. The password for admin user...

WHM/cPanel license issue

You have ordered a license and see a next warn:  "Trial LicenseThis copy of cPanel & WHM is...

Webmin installiation and First Login

We reccomend you to install webmin reffering on the official WebMin install GUI:...

How to change the WHM/cPanel main IP address [cPanel/WHM: List Account shows the incorrect IP]

If you can't change the ip for some user account in usual way (WHM->List account -> Ichange...