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

Centos Web Panel

In this article we will use the main features of the Centos Web Panel.1. Create user accountIn...

Softaculous One click installer using under cPanel account . Example: how to install Wordpress

Once you've purchased a Shared Hosting account you are able to use Softaculous script installer...

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...

Backup and restore in cPanel

Backup and restore in cPanel is quite simple procedure. Backup Step 1. Go to Backup Wizard...

Webmin installiation and First Login

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