SQLITE_ERROR: no such table: settings
What is changed this new version that not start correctly gancio?
We use a custom docker file and we store database, config, logs and uploads in other directory (ex: /data/)
Example : https://git.sindominio.net/siroco/gancio/src/branch/master/Dockerfile
We build gancio from last signed tag and
We start gancio using: gancio start --config /data/config.json
but.. there is some kind of error when initialize database and /data/db.sqlite is empty, like this issue #73 (closed)
Log:
gancio | 📅 gancio - v1.2.1 - A shared agenda for local communities (nodejs: v12.22.5)
gancio | ℹ > Reading configuration from: /data/config.json
gancio | ℹ Modern bundles are detected. Modern mode (server) is enabled now.
gancio | 2021-12-05T00:24:59.136Z info: Logging to /data/logs/gancio.log (level: debug)
gancio | 2021-12-05T00:25:00.939Z debug: Connecting to DB: {"dialect":"sqlite","storage":"/data/db.sqlite","logging":true}
gancio | 2021-12-05T00:25:02.399Z info: [TASK] Add CREATE_RECURRENT_EVENT (1800 seconds)
gancio | 2021-12-05T00:25:02.400Z info: [TASK] Add CLEAN_UNUSED_PLACES (86400 seconds)
gancio | 2021-12-05T00:25:02.401Z info: [TASK] Add CLEAN_UNUSED_TAGS (86400 seconds)
gancio |
gancio | ERROR (node:1) [SEQUELIZE0002] DeprecationWarning: The logging-option should be either a function or false. Default: console.log
gancio |
gancio | Executing (default): SELECT key, value, is_secret, createdAt, updatedAt FROM settings AS setting;
gancio | Executing (default): SELECT 1+1 AS result
gancio |
gancio | FATAL SQLITE_ERROR: no such table: settings
gancio |
gancio | at Query.formatError (node_modules/sequelize/lib/dialects/sqlite/query.js:403:16)
gancio | at Query._handleQueryResponse (node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
gancio | at afterExecute (node_modules/sequelize/lib/dialects/sqlite/query.js:238:27)
gancio | at Statement.errBack (node_modules/sqlite3/lib/sqlite3.js:14:21)
gancio |
gancio |
gancio | ╭───────────────────────────────────────────────────────────────────╮
gancio | │ │
gancio | │ ✖ Nuxt Fatal Error │
gancio | │ │
gancio | │ SequelizeDatabaseError: SQLITE_ERROR: no such table: settings │
gancio | │ │
gancio | ╰───────────────────────────────────────────────────────────────────╯
gancio |
Edited by les