create/step4 "Invalid default value for 'authenticated_at'"

[lifeiteng]

http://localhost:8000/admin/workspaces/create/step4

(pymysql.err.OperationalError) (1067, "Invalid default value for 'authenticated_at'") [SQL: CREATE TABLE fief_authorization_codes ( id CHAR(36) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT now(), updated_at TIMESTAMP NOT NULL DEFAULT now(), code VARCHAR(255) NOT NULL, c_hash VARCHAR(255) NOT NULL, redirect_uri VARCHAR(2048) NOT NULL, scope JSON NOT NULL, authenticated_at TIMESTAMP NOT NULL, nonce VARCHAR(255), code_challenge VARCHAR(255), code_challenge_method VARCHAR(255), user_id CHAR(36) NOT NULL, client_id CHAR(36) NOT NULL, PRIMARY KEY (id), FOREIGN KEY(client_id) REFERENCES fief_clients (id) ON DELETE CASCADE, FOREIGN KEY(user_id) REFERENCES fief_users (id) ON DELETE CASCADE ) ] (Background on this error at: https://sqlalche.me/e/20/e3q8)

[fief-bailiff[bot]]

Hail, @lifeiteng 👋 Welcome to Fief's kingdom!

Our team will get back to you very soon to help.

In the meantime, take a minute to star our repository ⭐️

Farewell!

[frankie567]

Hi!

Which version of MySQL are you using? It looks like Fief is trying to use a syntax not available on older versions of MySQL.

[lifeiteng]

version 8.0