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

CSF

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

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

Installing Softaculous

Installing Softaculous in cPanel. Source:...

Uploading files in cPanel

If you would like to upload some files to your server using cPanel, you can do so with built-in...