Database error when enabling app: 1067 Invalid default value for 'expires'

[Miesepies]

Nextcloud 14.0.4 docker image (official)
MariaDB docker image (official)

An exception occurred while executing 'ALTER TABLE oc_twofactor_admin_codes CHANGE expires expires BIGINT UNSIGNED DEFAULT NULL NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'expires'

Could it be that "DEFAULT NULL NOT NULL" is the issue here?

MariaDB [nextcloud]> describe oc_twofactor_admin_codes;                                                                                                                           
+---------+---------------------+------+-----+---------+-------+                                                                                                                  
| Field   | Type                | Null | Key | Default | Extra |                                                                                                                  
+---------+---------------------+------+-----+---------+-------+                                                                                                                  
| id      | bigint(20) unsigned | NO   | PRI | NULL    |       |                                                                                                                  
| user_id | varchar(64)         | NO   | PRI | NULL    |       |                                                                                                                  
| code    | varchar(6)          | NO   |     | NULL    |       |                                                                                                                  
| expires | bigint(20) unsigned | YES  |     | NULL    |       |                                                                                                                  
+---------+---------------------+------+-----+---------+-------+                                                                                                                  
4 rows in set (0.002 sec)                                          

Originally posted by @Miesepies in #20 (comment)

[ChristophWurst]

Please post the output of php occ migrations:status twofactor_admin

[Ryonez]

I have the same issue while trying to install. The command you want run outputs:

[ChristophWurst]

This is totally unrelated error. Please file a new ticket.

[Ryonez]

Then this is one being produced by the same error above.
I only ran the command because I have op's issue.

[ChristophWurst]

Got it. What version do you run? v0.2.0? Does https://github.com/ChristophWurst/twofactor_admin/blob/v0.2.0/lib/Migration/Version2Date20180926055748.php on your instance?

[Ryonez]

This happens on install:

Does https://github.com/ChristophWurst/twofactor_admin/blob/v0.2.0/lib/Migration/Version2Date20180926055748.php on your instance?

Are you asking if that file is present? (It is)

[Ryonez]

Opps, just noticed that it seems to be trying to install 0.1.0.

[Miesepies]

Yes, 0.1.0 for nc14, 0.2.0 for nc15 as listed on the app page:

[Ryonez]

Good to know, but isn't 15 a rc? It's not the latest stable branch.

[k0d3g3ar]

Same issue here. NC 15 and manually installed 0.2.0. When attempting to enable, I get this:
An exception occurred while executing 'ALTER TABLE oc_twofactor_admin_codes CHANGE expires expires BIGINT UNSIGNED DEFAULT NULL NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'expires'

This was on a completely brand new NC install of NC15 RC1, not any update to previous installation.

Also output of php occ migrations:status twofactor_admin is:

[ChristophWurst]

See #20 (comment)