[GH-ISSUE #10] Unable to install #11

New issue

Closed

opened 2026-02-26 05:32:59 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 05:32:59 +03:00

Owner

Originally created by @razzam21 on GitHub (Sep 2, 2018).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/10

I have tried installing this on Mysql 5.7 and Mysql 8.0 (both support JSON columns). When the container first loads it is in a 'starting' state. When I look at the logs it is filled with this error:

migration failed with error: create table auth (id int unsigned not null auto_increment primary key, created_on datetime not null, modified_on datetime not null, user_id int unsigned not null, type varchar(30) not null, secret varchar(255) not null, meta json not null default '{}', is_deleted int unsigned not null default '0') - ER_BLOB_CANT_HAVE_DEFAULT: BLOB, TEXT, GEOMETRY or JSON column 'meta' can't have a default value,
migration file "20180618015850_initial.js" failed

How can I get this to work? I have tried relaxing the sql_mode of Mysql in the hopes of letting it go in and then put that back but that doesn't seem to have an effect.

Originally created by @razzam21 on GitHub (Sep 2, 2018). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/10 I have tried installing this on Mysql 5.7 and Mysql 8.0 (both support JSON columns). When the container first loads it is in a 'starting' state. When I look at the logs it is filled with this error: migration failed with error: create table `auth` (`id` int unsigned not null auto_increment primary key, `created_on` datetime not null, `modified_on` datetime not null, `user_id` int unsigned not null, `type` varchar(30) not null, `secret` varchar(255) not null, `meta` json not null default '{}', `is_deleted` int unsigned not null default '0') - ER_BLOB_CANT_HAVE_DEFAULT: BLOB, TEXT, GEOMETRY or JSON column 'meta' can't have a default value, migration file "20180618015850_initial.js" failed How can I get this to work? I have tried relaxing the sql_mode of Mysql in the hopes of letting it go in and then put that back but that doesn't seem to have an effect.

kerem closed this issue

2026-02-26 05:32:59 +03:00

kerem commented

2026-02-26 05:32:59 +03:00

Author

Owner

@jc21 commented on GitHub (Sep 3, 2018):

To be honest I've done most of my testing with the latest Maria database engine which looks like supports default blob values of any string whereas mysql JSON data types only accept default values written as expressions. The KnexJS library doesn't know how to handle the different between them yet so I've updates the migration to remove these and handle defaults in a different way.

Pull the docker image again to get it working.

@jc21 commented on GitHub (Sep 3, 2018): To be honest I've done most of my testing with the latest Maria database engine which looks like supports default blob values of any string whereas mysql JSON data types only accept default values written as expressions. The KnexJS library doesn't know how to handle the different between them yet so I've updates the migration to remove these and handle defaults in a different way. Pull the docker image again to get it working.

kerem referenced this issue

2026-02-26 07:33:52 +03:00

[GH-ISSUE #3009] Internal Error when requesting SSL certificate, challenges failed #2057

kerem referenced this issue

2026-02-26 07:36:04 +03:00

[GH-ISSUE #3928] Internal error when creating an access list #2576

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/nginx-proxy-manager-NginxProxyManager#11

No description provided.

Rows
Columns