Hi
I got some problem with drone when i try to upgrade our image from 1.6.5 to a newer version(1.10.1)
I got the following error
2021-05-06 12:55:55.807 UTC [41] ERROR: syntax error at or near “AUTOINCREMENT” at character 77
2021-05-06 12:55:55.807 UTC [41] STATEMENT:
CREATE TABLE IF NOT EXISTS users (
user_id INTEGER PRIMARY KEY AUTOINCREMENT
,user_login TEXT COLLATE NOCASE
,user_email TEXT
,user_admin BOOLEAN
,user_machine BOOLEAN
,user_active BOOLEAN
,user_avatar TEXT
,user_syncing BOOLEAN
,user_synced INTEGER
,user_created INTEGER
,user_updated INTEGER
,user_last_login INTEGER
,user_oauth_token TEXT
,user_oauth_refresh TEXT
,user_oauth_expiry INTEGER
,user_hash TEXT
,UNIQUE(user_login COLLATE NOCASE)
,UNIQUE(user_hash)
);
Is it a bug or do i miss configure something that change between these version,
Thanks
Herve