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/cPanel installiation and first login

<official cPanel install guide>...

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

WHM/cPanel license issue

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

Uploading files in cPanel

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

zpanel guide

In this guide we will create domain, ftp account and mailbox using zpanel. How to install...