Phpmyadmin Problem

[Netskyau]

Hi guys,

I'm trying to edit my server_settings table but I cannot. I get this, "This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available."

I've done some searching and there are some solutions, but I don't fully understand them. If anyone can help piece it together.

Thanks!

 

[Timothy]

Can u post a image of it. :L

 

[Netskyau]

Yup, 2 seconds.

Edit:
This only happens on server_settings and maybe a few others.

 

[Timothy]

Enter this sql;

--
-- Table structure for table `server_settings`
--

CREATE TABLE IF NOT EXISTS `server_settings` (
  `motd` text NOT NULL,
  `timer` int(11) NOT NULL DEFAULT '15',
  `pixels` int(11) NOT NULL DEFAULT '15',
  `credits` int(11) NOT NULL DEFAULT '75',
  `enable_chatlogs` enum('0','1') NOT NULL DEFAULT '1',
  `enable_roomlogs` enum('0','1') NOT NULL DEFAULT '1',
  `vipclothesforhcusers` enum('1','0') NOT NULL DEFAULT '1',
  `MaxRoomsPerUser` int(4) NOT NULL DEFAULT '50',
  `enable_externalchatlinks` enum('disabled','blacklist','whitelist') NOT NULL DEFAULT 'disabled',
  `enable_securesessions` enum('1','0') NOT NULL DEFAULT '1',
  `enable_cmdlogs` enum('0','1') NOT NULL DEFAULT '1',
  `allow_friendfurnidrops` enum('0','1') NOT NULL DEFAULT '1',
  `enable_cmd_redeemcredits` enum('0','1') NOT NULL DEFAULT '1',
  `points` int(11) NOT NULL DEFAULT '0',
  `pixels_max` int(15) NOT NULL DEFAULT '0',
  `credits_max` int(15) NOT NULL DEFAULT '0',
  `points_max` int(15) NOT NULL DEFAULT '0',
  `enable_antiddos` enum('0','1') NOT NULL DEFAULT '1',
  `MaxPetsPerRoom` int(2) NOT NULL DEFAULT '15',
  `MarketPlaceTax` int(2) NOT NULL DEFAULT '1',
  `MaxMarketPlacePrice` int(9) NOT NULL DEFAULT '10000',
  `unload_crashedrooms` enum('0','1') NOT NULL DEFAULT '1',
  `ShowUsersAndRoomsInAbout` enum('0','1') NOT NULL DEFAULT '1',
  `idlesleep` int(6) NOT NULL DEFAULT '300',
  `idlekick` int(6) NOT NULL DEFAULT '1200',
  `ip_lastforbans` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `server_settings`
--

INSERT INTO `server_settings` (`motd`, `timer`, `pixels`, `credits`, `enable_chatlogs`, `enable_roomlogs`, `vipclothesforhcusers`, `MaxRoomsPerUser`, `enable_externalchatlinks`, `enable_securesessions`, `enable_cmdlogs`, `allow_friendfurnidrops`, `enable_cmd_redeemcredits`, `points`, `pixels_max`, `credits_max`, `points_max`, `enable_antiddos`, `MaxPetsPerRoom`, `MarketPlaceTax`, `MaxMarketPlacePrice`, `unload_crashedrooms`, `ShowUsersAndRoomsInAbout`, `idlesleep`, `idlekick`, `ip_lastforbans`) VALUES
('Benvenuto su SeasonsCms v2.1!\r\n\r\nQuesto Hotel utilizza la versione Premium! \r\n\r\n:D', 15, 150, 900, '1', '1', '1', 50, 'disabled', '0', '1', '1', '1', 0, 0, 0, 0, '1', 15, 1, 10000, '1', '1', 300, 1200, '1');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

(You might have to change a few things on this )

 

[Netskyau]

Error
SQL query:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL said:

You must be registered for see links

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Sorry I'm really noob when it comes to phpmyadmin.

 

[Timothy]

Error
SQL query:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL said:

You must be registered for see links

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Sorry I'm really noob when it comes to phpmyadmin.

Got tv or join.me? =.=
Imma have to help you out later on today. Got school. ;o

 

[Netskyau]

Nope, sorry. Perhaps you can read this and tone it down to standard steps?

You must be registered for see links

I tried doing the steps but didn't work.

 

[Netskyau]

Fixed.