OT don't record Deaths..?? :S

[picachu]

[29/10/2009 11:52:31] mysql_real_query(): INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (2624, 1256824351, 206, '', ''); - MYSQL ERROR: Unknown column 'time' in 'field list' (1054)
[29/10/2009 11:52:31] mysql_real_query(): INSERT INTO `player_deaths` (`player_id`, `date`, `level`) VALUES (2624, 1256824351, 206) - MYSQL ERROR: Duplicate entry '1588' for key 1 (1062)

My server doesn't record the deaths of players, when player die i get this error in the code!

 

[Scofield]

Seems like the table not exist or damages , Try to reimport you table or the databse if the OT still in test stage

 

[Valania]

Just add yourself a query with 'time' or delete your player deaths and paste in your sql this:

CREATE TABLE IF NOT EXISTS `player_deaths` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `level` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=468 ;

Then go to your script and change 'time' to 'date'

Rep me++

 

[picachu]

Thank you Valania, i already fixed it :s
I just create a table named 'time' xD
but ty!

 

[Valania]

Rep me