The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by nootkan, Jan 22, 2014.

  1. nootkan

    nootkan Well-Known Member

    Joined:
    Oct 25, 2006
    Messages:
    129
    Likes Received:
    2
    Trophy Points:
    18
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. nootkan

    nootkan Well-Known Member

    Joined:
    Oct 25, 2006
    Messages:
    129
    Likes Received:
    2
    Trophy Points:
    18
    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.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page