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

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

zpanel guide

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

Virtualmin

Virtualmin is a Webmin module for managing multiple virtual hosts through a single interface,...

Uploading files in cPanel

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

DirectAdmin License update \ip change

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