What is wrong with writing a user to the database?

Question

PHP

What is wrong with writing a user to the database?

$steamid = $steamprofile['steamid'];
        $nickname = $steamprofile['personaname'];
        $current_date = date("l dS of F Y h:i:s A");

        $query = "INSERT INTO users (steamid, nickname, joined, balance, totalBought, banned, admin) VALUES ('$steamid', '$nickname', '$current_date', '0', '0', '0', '0') ON DUPLICATE KEY UPDAYE nickname = '$nickname'";
        $userInfo = mysqli_query($connect, $query);

Doesn't throw an error.
Here is phpMyAdmin: https://gyazo.com/dc0c1fd3053d01fec6d4f97790e48a08

Answer 1

Your request says:
Check if this is the issue?

Answer 2

steamid, nickname, joined, balance, totalBought, banned, admin -- 7 columns
'$steamid', '$nickname', '$current_date', '0', '0', '0' -- 6 values