This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features ar

nootkan

Well-Known Member
Oct 25, 2006
134
5
168
After trying to make changes to settings in the backend of my topsites I was given the don't have permission to access server even though I am admin. So I went into cPanel and opened phpmyadmin to make the changes there and now apparently mysql won't allow me to edit the tables like I used to. What is going on? Why would an update stop me from editing tables like before?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Re: This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features

Hello :)

The error message you provided yields the following result on a search engine:

MySQL Error - Table Does Not Contain a Unique Column

You could try the solution offered at this external URL, however keep in mind this is not supported by cPanel. You may want to backup the database before making any changes to it.

Thank you.
 

nootkan

Well-Known Member
Oct 25, 2006
134
5
168
Re: This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features

Thanks for that. I had already searched google for answers but couldn't fine anything that I understood as database queries are something I don't understand how to write. I knew it had something to do with the primary key but I just couldn't figure it out. I installed a fresh version of the program and it too has the exact same table structure so I am assuming it is either an old way to create it (as the program is no longer supported) or something to do with security maybe. In either case I just made the changes in the downloaded sql file and dropped the existing database and imported the modified one which worked just fine.

I realize that you don't support mysql but I thought I'd check to see if anyone else had this issue. Thanks again for your reply.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Re: This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features

I am happy to see you were able to find a solution. Thank you for updating this thread with the outcome.