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

CSF

ConfigServer Security & Firewall (CSF) is a powerful iptables configuration tool....

Centos Web Panel

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

Vesta panel

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

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 license issue

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