error in console

[Acrenactive]

Hello guys!

how i fix this when player die i get this in console

mysql_real_query(): UPDATE `players` SET `deaths` = `deaths` + 1 WHERE id = 129; - MYSQL ERROR: Unknown column 'deaths' in 'field list' (1054)

 

[Zippiex]

You sure it will be like that? SET `de aths`

 

[Acrenactive]

You sure it will be like that? SET `de aths`

mysql_real_query(): UPDATE `players` SET `deaths` = `deaths` + 1 WHERE id = 129; - MYSQL ERROR: Unknown column 'deaths' in 'field list' (1054)

 

[Lucas CP]

The error occurs because there is no 'deaths' column in the 'players' table. To solve this run this query in phpMyAdmin:

ALTER TABLE players ADD COLUMN deaths int(11) DEFAULT 0;

Sorry for my English, I'm using google translate.

 

[Acrenactive]

now i only got this bug mysql_real_query(): UPDATE `players` SET `frags` = `frags` + 1 WHERE id = 53; - MYSQL...t' (1054)

Thanks for death column <3

The error occurs because there is no 'deaths' column in the 'players' table. To solve this run this query in phpMyAdmin:

ALTER TABLE players ADD COLUMN deaths int(11) DEFAULT 0;

Sorry for my English, I'm using google translate.

 

[Lucas CP]

now i only got this bug mysql_real_query(): UPDATE `players` SET `frags` = `frags` + 1 WHERE id = 53; - MYSQL...t' (1054)

Thanks for death column <3

Do the same to the deaths, now switches to frags.