starred/nginx-proxy-manager-NginxProxyManager
1
0
Fork 0
mirror of https://github.com/NginxProxyManager/nginx-proxy-manager.git synced 2026-04-25 17:35:52 +03:00
Code Issues 937 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #1121] Install bug on RPi4 version 2.9.3 #922

New issue
Closed
opened 2026-02-26 06:34:58 +03:00 by kerem · 1 comment
kerem commented 2026-02-26 06:34:58 +03:00
Owner
Copy link

Originally created by @ACNiC03 on GitHub (May 24, 2021).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/1121

Checklist

  • Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
    • No
  • Are you sure you're not using someone else's docker image?
    • Yes
  • Have you searched for similar issues (both open and closed)?
    • Yes

Describe the bug
NPM container is unhealthy, i will put the logs under this bug. Also Bad Gateway when trying to log in

Nginx Proxy Manager Version
2.9.3

To Reproduce
Steps to reproduce the behavior:

install steps:

sudo -i
mkdir NginxProxyManager
cd NginxProxyManager
nano docker-compose.yml

inside file:

version: "3"
services:
  app:
    image: 'jc21/nginx-proxy-manager:latest'
    restart: always
    ports:
      # Public HTTP Port:
      - '80:80'
      # Public HTTPS Port:
      - '443:443'
      # Admin Web Port:
      - '81:81'
    environment:
      # These are the settings to access your db
      DB_MYSQL_HOST: "db"
      DB_MYSQL_PORT: 3306
      DB_MYSQL_USER: "<OWN NAME>"
      DB_MYSQL_PASSWORD: "<SAME AS MYSQL_PASSWORD>"
      DB_MYSQL_NAME: "npm"
      # If you would rather use Sqlite uncomment this
      # and remove all DB_MYSQL_* lines above
      # DB_SQLITE_FILE: "/data/database.sqlite"
      # Uncomment this if IPv6 is not enabled on your host
      DISABLE_IPV6: 'true'
    volumes:
      - ./data/nginx-proxy-manager:/data
      - ./letsencrypt:/etc/letsencrypt
    depends_on:
      - db
  db:
    image: ghcr.io/linuxserver/mariadb
    restart: unless-stopped
    environment:
      PUID: 1001
      PGID: 1001
      TZ: "Europe/Amsterdam"
      MYSQL_ROOT_PASSWORD: "<OWN ROOT PASSWORD (WITHOUT SPECIAL CHARACTERS)"
      MYSQL_DATABASE: "npm"
      MYSQL_USER: "<OWN NAME>"
      MYSQL_PASSWORD: "<RANDOM PASSWORD>"
    volumes:
      - ./data/mariadb:/config

Expected behavior
healthy container and no bad gateway at login page

Screenshots
image
image

Operating System
RPi4 With Portainer installed. RaspberryPi_OS NPM installed on CLI

NOTE
In the bug it says "migrate" or something, this is a fresh install of NPM. I tried same steps on a different clean installed RPi4 and the same thing is happening

Additional context

Logs 
2021-05-24T23:30:30.747862448Z [5/24/2021] [11:30:30 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:30.777961760Z [5/24/2021] [11:30:30 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:30.782063918Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:30.782290304Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:30.798007239Z [5/24/2021] [11:30:30 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:31.807597987Z [5/24/2021] [11:30:31 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:31.826436091Z [5/24/2021] [11:30:31 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:31.829137412Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:31.829215523Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:31.841819437Z [5/24/2021] [11:30:31 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:32.858710365Z [5/24/2021] [11:30:32 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:32.887535857Z [5/24/2021] [11:30:32 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:32.891593515Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:32.891702255Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:32.901896789Z [5/24/2021] [11:30:32 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:33.918597851Z [5/24/2021] [11:30:33 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:34.093249547Z [5/24/2021] [11:30:34 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:34.099524847Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:34.099627031Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:34.229717429Z [5/24/2021] [11:30:34 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:35.242891292Z [5/24/2021] [11:30:35 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:35.273441988Z [5/24/2021] [11:30:35 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:35.278074918Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:35.278260749Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:35.288441283Z [5/24/2021] [11:30:35 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:36.305199238Z [5/24/2021] [11:30:36 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:36.338187759Z [5/24/2021] [11:30:36 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:36.344212951Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:36.344442041Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:36.354411929Z [5/24/2021] [11:30:36 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:37.362241672Z [5/24/2021] [11:30:37 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:37.378636007Z [5/24/2021] [11:30:37 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:37.380911352Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:37.380992685Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:37.392373021Z [5/24/2021] [11:30:37 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:38.409647067Z [5/24/2021] [11:30:38 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:38.442922640Z [5/24/2021] [11:30:38 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:38.446628784Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:38.446717376Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:38.455254003Z [5/24/2021] [11:30:38 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:39.469310329Z [5/24/2021] [11:30:39 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:39.497682660Z [5/24/2021] [11:30:39 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:39.501601616Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:39.501711263Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:39.513985608Z [5/24/2021] [11:30:39 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:40.528184101Z [5/24/2021] [11:30:40 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:40.560836662Z [5/24/2021] [11:30:40 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:40.564276365Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:40.564379660Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:40.575981216Z [5/24/2021] [11:30:40 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:41.592949958Z [5/24/2021] [11:30:41 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:41.627396315Z [5/24/2021] [11:30:41 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:41.632268686Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:41.632394592Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:41.643818576Z [5/24/2021] [11:30:41 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:42.651640608Z [5/24/2021] [11:30:42 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:42.670562656Z [5/24/2021] [11:30:42 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:42.672413006Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:42.672475875Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:42.682931222Z [5/24/2021] [11:30:42 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:43.699601824Z [5/24/2021] [11:30:43 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:43.733502576Z [5/24/2021] [11:30:43 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:43.738095025Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:43.738216894Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:43.750483331Z [5/24/2021] [11:30:43 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:44.758365663Z [5/24/2021] [11:30:44 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:44.776419406Z [5/24/2021] [11:30:44 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:44.778631734Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:44.778694974Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:44.786186705Z [5/24/2021] [11:30:44 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:45.800429728Z [5/24/2021] [11:30:45 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:45.829984713Z [5/24/2021] [11:30:45 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:45.834014465Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:45.834132889Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:45.843794245Z [5/24/2021] [11:30:45 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:46.857915179Z [5/24/2021] [11:30:46 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:46.889903619Z [5/24/2021] [11:30:46 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:46.893274840Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:46.893372173Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:46.904633677Z [5/24/2021] [11:30:46 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:47.912830827Z [5/24/2021] [11:30:47 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:47.929573400Z [5/24/2021] [11:30:47 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:47.932831790Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:47.932880919Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:48.082947468Z [5/24/2021] [11:30:48 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:49.097156222Z [5/24/2021] [11:30:49 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:49.130648997Z [5/24/2021] [11:30:49 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:49.134507305Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:49.134885801Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:49.147410032Z [5/24/2021] [11:30:49 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:50.160650484Z [5/24/2021] [11:30:50 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:50.189894195Z [5/24/2021] [11:30:50 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:50.193946113Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:50.194065222Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:50.204199480Z [5/24/2021] [11:30:50 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:51.217936595Z [5/24/2021] [11:30:51 PM] [Migrate  ] › ℹ  info      Current database version: none,
2021-05-24T23:30:51.243853825Z [5/24/2021] [11:30:51 PM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...,
2021-05-24T23:30:51.247546154Z migration file "20180618015850_initial.js" failed,
2021-05-24T23:30:51.247641449Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
2021-05-24T23:30:51.264079211Z [5/24/2021] [11:30:51 PM] [Global   ] › ✖  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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1,
Originally created by @ACNiC03 on GitHub (May 24, 2021). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/1121 **Checklist** - Have you pulled and found the error with `jc21/nginx-proxy-manager:latest` docker image? - No - Are you sure you're not using someone else's docker image? - Yes - Have you searched for similar issues (both open and closed)? - Yes **Describe the bug** NPM container is unhealthy, i will put the logs under this bug. Also Bad Gateway when trying to log in **Nginx Proxy Manager Version** 2.9.3 **To Reproduce** Steps to reproduce the behavior: install steps: ```commandline sudo -i mkdir NginxProxyManager cd NginxProxyManager nano docker-compose.yml ``` inside file: ```yml version: "3" services: app: image: 'jc21/nginx-proxy-manager:latest' restart: always ports: # Public HTTP Port: - '80:80' # Public HTTPS Port: - '443:443' # Admin Web Port: - '81:81' environment: # These are the settings to access your db DB_MYSQL_HOST: "db" DB_MYSQL_PORT: 3306 DB_MYSQL_USER: "<OWN NAME>" DB_MYSQL_PASSWORD: "<SAME AS MYSQL_PASSWORD>" DB_MYSQL_NAME: "npm" # If you would rather use Sqlite uncomment this # and remove all DB_MYSQL_* lines above # DB_SQLITE_FILE: "/data/database.sqlite" # Uncomment this if IPv6 is not enabled on your host DISABLE_IPV6: 'true' volumes: - ./data/nginx-proxy-manager:/data - ./letsencrypt:/etc/letsencrypt depends_on: - db db: image: ghcr.io/linuxserver/mariadb restart: unless-stopped environment: PUID: 1001 PGID: 1001 TZ: "Europe/Amsterdam" MYSQL_ROOT_PASSWORD: "<OWN ROOT PASSWORD (WITHOUT SPECIAL CHARACTERS)" MYSQL_DATABASE: "npm" MYSQL_USER: "<OWN NAME>" MYSQL_PASSWORD: "<RANDOM PASSWORD>" volumes: - ./data/mariadb:/config ``` **Expected behavior** healthy container and no bad gateway at login page **Screenshots** ![image](https://user-images.githubusercontent.com/64742934/119418661-c8b2bb80-bcf8-11eb-804c-0888adf2d675.png) ![image](https://user-images.githubusercontent.com/64742934/119418740-f992f080-bcf8-11eb-8600-7b8975034a8d.png) **Operating System** RPi4 With Portainer installed. RaspberryPi_OS NPM installed on CLI **NOTE** In the bug it says "migrate" or something, this is a fresh install of NPM. I tried same steps on a different clean installed RPi4 and the same thing is happening **Additional context** <details><summary>Logs</summary> ``` 2021-05-24T23:30:30.747862448Z [5/24/2021] [11:30:30 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:30.777961760Z [5/24/2021] [11:30:30 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:30.782063918Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:30.782290304Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:30.798007239Z [5/24/2021] [11:30:30 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:31.807597987Z [5/24/2021] [11:30:31 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:31.826436091Z [5/24/2021] [11:30:31 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:31.829137412Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:31.829215523Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:31.841819437Z [5/24/2021] [11:30:31 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:32.858710365Z [5/24/2021] [11:30:32 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:32.887535857Z [5/24/2021] [11:30:32 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:32.891593515Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:32.891702255Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:32.901896789Z [5/24/2021] [11:30:32 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:33.918597851Z [5/24/2021] [11:30:33 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:34.093249547Z [5/24/2021] [11:30:34 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:34.099524847Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:34.099627031Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:34.229717429Z [5/24/2021] [11:30:34 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:35.242891292Z [5/24/2021] [11:30:35 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:35.273441988Z [5/24/2021] [11:30:35 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:35.278074918Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:35.278260749Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:35.288441283Z [5/24/2021] [11:30:35 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:36.305199238Z [5/24/2021] [11:30:36 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:36.338187759Z [5/24/2021] [11:30:36 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:36.344212951Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:36.344442041Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:36.354411929Z [5/24/2021] [11:30:36 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:37.362241672Z [5/24/2021] [11:30:37 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:37.378636007Z [5/24/2021] [11:30:37 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:37.380911352Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:37.380992685Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:37.392373021Z [5/24/2021] [11:30:37 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:38.409647067Z [5/24/2021] [11:30:38 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:38.442922640Z [5/24/2021] [11:30:38 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:38.446628784Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:38.446717376Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:38.455254003Z [5/24/2021] [11:30:38 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:39.469310329Z [5/24/2021] [11:30:39 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:39.497682660Z [5/24/2021] [11:30:39 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:39.501601616Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:39.501711263Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:39.513985608Z [5/24/2021] [11:30:39 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:40.528184101Z [5/24/2021] [11:30:40 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:40.560836662Z [5/24/2021] [11:30:40 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:40.564276365Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:40.564379660Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:40.575981216Z [5/24/2021] [11:30:40 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:41.592949958Z [5/24/2021] [11:30:41 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:41.627396315Z [5/24/2021] [11:30:41 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:41.632268686Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:41.632394592Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:41.643818576Z [5/24/2021] [11:30:41 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:42.651640608Z [5/24/2021] [11:30:42 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:42.670562656Z [5/24/2021] [11:30:42 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:42.672413006Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:42.672475875Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:42.682931222Z [5/24/2021] [11:30:42 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:43.699601824Z [5/24/2021] [11:30:43 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:43.733502576Z [5/24/2021] [11:30:43 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:43.738095025Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:43.738216894Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:43.750483331Z [5/24/2021] [11:30:43 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:44.758365663Z [5/24/2021] [11:30:44 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:44.776419406Z [5/24/2021] [11:30:44 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:44.778631734Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:44.778694974Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:44.786186705Z [5/24/2021] [11:30:44 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:45.800429728Z [5/24/2021] [11:30:45 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:45.829984713Z [5/24/2021] [11:30:45 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:45.834014465Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:45.834132889Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:45.843794245Z [5/24/2021] [11:30:45 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:46.857915179Z [5/24/2021] [11:30:46 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:46.889903619Z [5/24/2021] [11:30:46 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:46.893274840Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:46.893372173Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:46.904633677Z [5/24/2021] [11:30:46 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:47.912830827Z [5/24/2021] [11:30:47 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:47.929573400Z [5/24/2021] [11:30:47 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:47.932831790Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:47.932880919Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:48.082947468Z [5/24/2021] [11:30:48 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:49.097156222Z [5/24/2021] [11:30:49 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:49.130648997Z [5/24/2021] [11:30:49 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:49.134507305Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:49.134885801Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:49.147410032Z [5/24/2021] [11:30:49 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:50.160650484Z [5/24/2021] [11:30:50 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:50.189894195Z [5/24/2021] [11:30:50 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:50.193946113Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:50.194065222Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:50.204199480Z [5/24/2021] [11:30:50 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:51.217936595Z [5/24/2021] [11:30:51 PM] [Migrate ] › ℹ info Current database version: none, 2021-05-24T23:30:51.243853825Z [5/24/2021] [11:30:51 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up..., 2021-05-24T23:30:51.247546154Z migration file "20180618015850_initial.js" failed, 2021-05-24T23:30:51.247641449Z 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, 2021-05-24T23:30:51.264079211Z [5/24/2021] [11:30:51 PM] [Global ] › ✖ 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, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1, ``` </details>
kerem 2026-02-26 06:34:58 +03:00
kerem commented 2026-02-26 06:34:59 +03:00
Author
Owner
Copy link

@chaptergy commented on GitHub (May 25, 2021):

Duplicate of https://github.com/jc21/nginx-proxy-manager/issues/896

<!-- gh-comment-id:847643537 --> @chaptergy commented on GitHub (May 25, 2021): Duplicate of https://github.com/jc21/nginx-proxy-manager/issues/896
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
develop
dependabot/npm_and_yarn/backend/liquidjs-10.25.7
dependabot/npm_and_yarn/frontend/prod-minor-updates-2a16bf3987
dependabot/npm_and_yarn/frontend/dev-patch-updates-754666cf41
dependabot/npm_and_yarn/backend/basic-ftp-5.3.0
dependabot/npm_and_yarn/test/follow-redirects-1.16.0
dependabot/npm_and_yarn/test/axios-1.15.0
dependabot/npm_and_yarn/frontend/lodash-4.18.1
dependabot/npm_and_yarn/backend/lodash-4.18.1
dependabot/npm_and_yarn/test/lodash-4.18.1
dependabot/npm_and_yarn/frontend/vite-7.3.2
dependabot/npm_and_yarn/backend/prod-minor-updates-5ec19a7f21
dependabot/npm_and_yarn/frontend/lodash-es-4.18.1
dependabot/npm_and_yarn/frontend/happy-dom-20.8.9
dependabot/npm_and_yarn/backend/path-to-regexp-8.4.0
dependabot/npm_and_yarn/frontend/picomatch-4.0.4
dependabot/npm_and_yarn/backend/picomatch-2.3.2
dependabot/npm_and_yarn/frontend/yaml-1.10.3
dependabot/npm_and_yarn/test/flatted-3.4.2
dependabot/npm_and_yarn/test/tar-7.5.11
dependabot/npm_and_yarn/frontend/immutable-5.1.5
master
dependabot/npm_and_yarn/test/glob-10.5.0
dependabot/npm_and_yarn/frontend/mdast-util-to-hast-13.2.1
dependabot/npm_and_yarn/test/form-data-4.0.4
v3-abandoned
bump-freedns
openidc
ssl-passthrough-hosts
static-content
v2.14.0
v2.13.7
v2.13.6
v2.13.5
v2.13.4
v2.13.3
v2.13.2
v2.13.1
v2.13.0
v2.12.6
v2.12.5
v2.12.4
v2.12.3
v2.12.2
v2.12.1
v2.12.0
v2.11.3
v2.11.2
v2.11.1
v2.11.0
v2.10.4
v2.10.3
v2.10.2
v2.10.1
v2.10.0
v2.9.22
v2.9.21
v2.9.20
v2.9.19
v2.9.18
v2.9.17
v2.9.16
v2.9.15
v2.9.14
v2.9.13
v2.9.12
v2.9.11
v2.9.10
v2.9.9
v2.9.8
v2.9.7
v2.9.6
v2.9.5
v2.9.4
v2.9.3
v2.9.2
v2.9.1
v2.9.0
v2.8.1
v2.8.0
v2.7.3
v2.7.2
v2.7.1
v2.7.0
v2.6.2
v2.6.1
v2.6.0
v2.5.0
v2.4.0
v2.3.1
v2.3.0
v2.2.4
v2.2.3
v2.2.2
v2.2.1
v2.2.0
v2.1.2
v2.1.1
v2.1.0
2.0.14
2.0.13
2.0.12
2.0.11
2.0.10
2.0.9
2.0.8
2.0.7
2.0.6
2.0.5
2.0.4
2.0.3
2.0.2
2.0.0
v2.0.0
1.1.2
1.1.1
1.0.1
Labels
Clear labels   
awaiting feedback

   
bug

   
cannot reproduce

   
dns provider request

   
duplicate

   
enhancement

   
enhancement

   
enhancement

   
good first issue

   
help wanted

   
invalid

   
need more info

   
no certbot plugin available

   
product-support

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
stale

   
troll

   
upstream issue

   
v2

   
v2

   
v2

   
v3

   
wontfix
No labels
awaiting feedback
bug
cannot reproduce
dns provider request
duplicate
enhancement
enhancement
enhancement
good first issue
help wanted
invalid
need more info
no certbot plugin available
product-support
pull-request
question
stale
troll
upstream issue
v2
v2
v2
v3
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
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#922
No description provided.