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

WHM: Create user for cPanel

If you have just installed cPanel and you want to access it, you need to create user first. How...

WHM/cPanel installiation and first login

<official cPanel install guide>...

Backup and restore in cPanel

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

DirectAdmin

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

DirectAdmin License update \ip change

DirectAdmin will not be running, as the license file will be invalid. Get the new license file...