search

fief-dev / fief

Users and authentication management SaaS
https://www.fief.dev
Other
486 stars 42 forks source link

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

Closed lifeiteng closed 10 months ago

lifeiteng commented 10 months ago

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] commented 10 months ago

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 ⭐️

star-fief

Farewell!

frankie567 commented 10 months ago

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.