Adding a team fails due to lack of SCORE and PENALTY

[kernel-sanders]

ctf_marker/admin.php

Line 132 in 5135484

$team_scoreboard_add = mysqli_query($connection, "INSERT INTO scoreboard (TEAM, TEAMNAME) VALUES ('$team_create_count','$team_create')");

ctf_marker/admin.php

Lines 920 to 926 in 5135484

	$sql_create_score = "CREATE TABLE `scoreboard` (
	`ID` int(2) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`TEAM` int(2) NOT NULL,
	`TEAMNAME` varchar(15) NOT NULL,
	`SCORE` double NOT NULL,
	`PENALTY` double NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

Field 'SCORE' doesn't have a default value

Perhaps not every single field in all tables should be NOT NULL?

[rgajendran]

Are you using phpMyAdmin? If the field is either int or double. phpMyAdmin automatically marks its as 0 if the value is NULL. If you are using different database then you need to set the value for score and penalty as "0".

[kernel-sanders]

The 'Add Team' page was failing for me with no useful output, so I took the SQL statement from admin.php and ran it manually in phpMyAdmin which returned the error

Field 'SCORE' doesn't have a default value

Token generation is also non-function probably due to the same NOT NULL errors.