highscores/account dont work on page!

[IMac]

my highscores or access account by page wont work this is errors i get

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'skulltime' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:112 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(112): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Player.php(140): OTS_Player->load('3') #2 C:\xampp\htdocs\highscores.php(90): OTS_Player->find('Wasted') #3 C:\xampp\htdocs\index.php(160): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 112

 

[Acubens]

you need add this columns in your table

make a sql query

ALTER TABLE players ADD `skulltime` BIGINT NOT NULL DEFAULT 0
ALTER TABLE players ADD `redskulltime` BIGINT NOT NULL DEFAULT 0

rep++ me

 

[IMac]

how i do that?:wub: how do i add em

 

[Acubens]

in phpmyadmin, into of your database select "SQL" and execute the query

 

[IMac]

this is what i get the first line worked but not the 2nd 1

SQL query:

ALTER TABLE players ADD `redskulltime` BIGINT NOT NULL DEFAULT 0

MySQL said: Documentation
#1060 - Duplicate column name 'redskulltime'

 

[Acubens]

this is what i get the first line worked but not the 2nd 1

dont worry, redskulltime already exist ;d this inst problem