swee revised this gist 14 hours ago. Go to revision
1 file changed, 1 insertion
shell
| @@ -10,5 +10,6 @@ sqlite> PRAGMA table_info(messages); | |||
| 10 | 10 | 3|time|INTEGER|0||0 | |
| 11 | 11 | 4|type|TEXT|0||0 | |
| 12 | 12 | 5|msg|TEXT|0||0 | |
| 13 | + | sqlite> .exit | |
| 13 | 14 | $ thelounge -v | |
| 14 | 15 | v4.4.3 | |
swee revised this gist 14 hours ago. Go to revision
2 files changed, 15 insertions
shell(file created)
| @@ -0,0 +1,14 @@ | |||
| 1 | + | $ sqlite3 swee.sqlite3 | |
| 2 | + | SQLite version 3.50.4 2025-07-30 19:33:53 | |
| 3 | + | Enter ".help" for usage hints. | |
| 4 | + | sqlite> .tables | |
| 5 | + | messages migrations options rollback_steps | |
| 6 | + | sqlite> PRAGMA table_info(messages); | |
| 7 | + | 0|id|INTEGER|0||1 | |
| 8 | + | 1|network|TEXT|0||0 | |
| 9 | + | 2|channel|TEXT|0||0 | |
| 10 | + | 3|time|INTEGER|0||0 | |
| 11 | + | 4|type|TEXT|0||0 | |
| 12 | + | 5|msg|TEXT|0||0 | |
| 13 | + | $ thelounge -v | |
| 14 | + | v4.4.3 | |
the_error(file created)
| @@ -0,0 +1 @@ | |||
| 1 | + | Jan 31 11:04:17 thelounge daemon[80436]: node:internal/process/promises:394 triggerUncaughtException(err, true /* fromPromise */); ^ [Error: SQLITE_ERROR: no such column: "message" - should this be a string literal in single-quotes?] { errno: 1, code: 'SQLITE_ERROR' } Node.js v24.12.0 | |
Newer
Older