Lua No frags after kill

[Dark ShaoOz]

This is the problem: When I kill someone, you get the white skulls and the msg: Unjustified Kill!
But frag doesnt save, because I use the command !frags, and says that I have 0 frags, I see the website on the top fragers section and nothing. So I think that maybe is a script that save the unjustified in the database, but I dont find that script... And when someone dies by anyone or a monster, deathlist shows nothing too..So can you please guys help me? Thanks.

 

[Limos]

In config.lua, make sure this is true and not false.

deathListEnabled = true

 

[Dark ShaoOz]

Everything is enabled..

 

[darcioantonio]

up

 

[roriscrave]

error in console?

 

[darcioantonio]

yes have erros
[10:32:25.023] mysql_real_query(): INSERT INTO `player_deaths` (`player_id`, `date`, `level`) VALUES (15, 1505917945, 1) - MYSQL ERROR: Field 'altkilled_by' doesn't have a default value (1364)

 

[Danger II]

Everyday the fucking same shit. What your the TFS version you use.
Do you think we can smell that?
Every version is different, and you asking OTLAND without reading the god damn Rules, they do exist for a reason.

 

[Raggaer]

I think the error is very descriptive: MYSQL ERROR: Field 'altkilled_by' doesn't have a default value (1364)

Maybe the field `altkilled_by` needs a default value, maybe.

 

[Danger II]

I think the error is very descriptive: MYSQL ERROR: Field 'altkilled_by' doesn't have a default value (1364)

Maybe the field `altkilled_by` needs a default value, maybe.

You will see him coming up with more errors, I know that for sure.

 

[darcioantonio]

ts 0.4
8.60

 

[Nekiro]

Everyday the fucking same shit. What your the TFS version you use.
Do you think we can smell that?
Every version is different, and you asking OTLAND without reading the god damn Rules, they do exist for a reason.

And this is exactly why I think we should drop support to tfs <1.x

 

[darcioantonio]

Resolved \/

in mysql delet 'killers'
and add new

DROP TABLE IF EXISTS `killers`;
CREATE TABLE `killers`
(
    `id` INT NOT NULL AUTO_INCREMENT,
    `death_id` INT NOT NULL,
    `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
    `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
    `war` INT NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

in mysql delet 'player_deaths'
and add new

DROP TABLE IF EXISTS `player_deaths`;
CREATE TABLE `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_deaths_ibfk_1` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;