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

DirectAdmin

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

cPanel/WHM: error "Sorry, you are not allowed to add any more than (0) parked domains!"

If you face the next issue with cPanel: "Sorry, you are not allowed to add any more than (0)...

Backup and restore in cPanel

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

Vesta panel

Vesta is a Simple & Clever Web Hosting Control Panel. All the details can be found at the...