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?
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.
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.
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.
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.
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.
I am happy to see you were able to find a solution. Thank you for updating this thread with the outcome.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| G | wpoq_users: Table doesn't exist | Databases | 3 | |
| M | Table in use The storage engine for the table doesn't support repair | Databases | 7 | |
| H | Table Name Does Not Exist Errors | Databases | 9 | |
| N | InnoDB tables exist but phpMyAdmin gives error #1146 Table xxx doesn't exist. | Databases | 12 | |
| T | MYSQL create table does not work | Databases | 1 |