[GH-ISSUE #557] SQLITE_ERROR: no such function: FROM_UNIXTIME #471

New issue

Closed

opened 2026-02-26 06:32:58 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 06:32:58 +03:00

Owner

Originally created by @throbbingcat on GitHub (Aug 13, 2020).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/557

I use the docker image with SQLite instead of mariadb or mysql.
This is a part of config.json

  "database": {
    "engine": "knex-native",
    "knex": {
      "client": "sqlite3",
      "connection": {
        "filename": "/data/database.sqlite"

It works so far but it seems the proper expiration date for a ssl cert cannot be saved. The expiration date shown in the backend is the date of generation and I found this in the log:

[8/13/2020] [4:39:00 PM] [SSL      ] › ✖  error     update `certificate` set `modified_on` = date('now'), `expires_on` = FROM_UNIXTIME(1605044184) where `id` = 1 and `provider` = 'letsencrypt' - SQLITE_ERROR: no such function: FROM_UNIXTIME

Originally created by @throbbingcat on GitHub (Aug 13, 2020). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/557 I use the docker image with SQLite instead of mariadb or mysql. This is a part of config.json ``` "database": { "engine": "knex-native", "knex": { "client": "sqlite3", "connection": { "filename": "/data/database.sqlite" ``` It works so far but it seems the proper expiration date for a ssl cert cannot be saved. The expiration date shown in the backend is the date of generation and I found this in the log: ``` [8/13/2020] [4:39:00 PM] [SSL ] › ✖ error update `certificate` set `modified_on` = date('now'), `expires_on` = FROM_UNIXTIME(1605044184) where `id` = 1 and `provider` = 'letsencrypt' - SQLITE_ERROR: no such function: FROM_UNIXTIME ```

kerem

2026-02-26 06:32:58 +03:00

closed this issue
added the
bug
label

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#471

No description provided.

Rows
Columns