Skip to content

SQLITE_ERROR: no such function: FROM_UNIXTIME #557

@throbbingcat

Description

@throbbingcat

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions