Editting MOTD/Server_Settings via PhpMyAdmin

Results 1 to 3 of 3
  1. #1
    Member obblebobble is offline
    MemberRank
    Mar 2012 Join Date
    43Posts

    Support Editting MOTD/Server_Settings via PhpMyAdmin

    Hi there RageZone,

    It's been a while since I've posted yet I'm having some issues with the MOTD. I am unable to edit the server_settings in the database via PhpMyAdmin because of this error:

    "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available."

    I have managed to edit the Credit/Pixel/Timer areas as they are integers, not actual text. I am unsure how to actually edit this, and it is become quite annoying, any help would be much appreciated.


    Here is an image displaying what's going on:




    EDIT: Also, I have tried editing the MOTD via House Keeping yet that does not display any success message and takes me to the next page (/motd2) without images...


  2. #2

    Re: Editting MOTD/Server_Settings via PhpMyAdmin

    I have the same issue, if you fixed it help is needed!

  3. #3
    www.Epic Hosts.co.uk Terrum is offline
    Grand MasterRank
    Jun 2008 Join Date
    EpicHosts,co.ukLocation
    1,322Posts

    Re: Editting MOTD/Server_Settings via PhpMyAdmin

    To fix this, pick a suitable column(s) in your table and create a unique index on it (or on them). Version 4.0 added this verification to avoid other problems when not the intended row is modified or deleted.

    See http://en.wikipedia.org/wiki/Unique_key.

    ( http://stackoverflow.com/questions/1...ures-are-not-a )



Advertisement