starred/karakeep

Fork 0

mirror of https://github.com/karakeep-app/karakeep.git synced 2026-04-25 16:06:04 +03:00

[GH-ISSUE #1897] SqliteError: table bookmarkLinks has no column named content #1177

New issue

Closed

opened 2026-03-02 11:55:32 +03:00 by kerem · 1 comment

kerem commented

2026-03-02 11:55:32 +03:00

Owner

Originally created by @Crazzygamerr on GitHub (Sep 7, 2025).
Original GitHub issue: https://github.com/karakeep-app/karakeep/issues/1897

Describe the Bug

Hi all, I'm a big fan of Karakeep and have been running it on my server for a good while now.
Last weekend, I was running v26 temporarily while testing and have since rolled back to 24.1. Seeing an Sqlite related error when trying to save/view bookmarks.

Steps to Reproduce

Run Karakeep on 24.1
Update to 26 with the same db
Rollback to 24.1

Expected Behaviour

Ideally would expect rollbacks to be possible, would be interested to know why it's not supported

Screenshots or Additional Context

Sep 04 22:49:18 start-web[7437]: ▲ Next.js 14.2.25
Sep 04 22:49:18 start-web[7437]: - Local: http://localhost:3000
Sep 04 22:49:18 start-web[7437]: - Network: http://0.0.0.0:3000
Sep 04 22:49:18 start-web[7437]: ✓ Starting...
Sep 04 22:49:24 start-web[7437]: ✓ Ready in 31s
Sep 06 22:12:17 start-web[7437]: SqliteError: table bookmarkLinks has no column named content
Sep 06 22:12:17 start-web[7437]: at Database.prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
Sep 06 22:12:17 start-web[7437]: ... 6 lines matching cause stack trace ...
Sep 06 22:12:17 start-web[7437]: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
Sep 06 22:12:17 start-web[7437]: cause: SqliteError: table bookmarkLinks has no column named content
Sep 06 22:12:17 start-web[7437]: at Database.prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
Sep 06 22:12:17 start-web[7437]: at b.prepareQuery (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:49045)
Sep 06 22:12:17 start-web[7437]: at b.prepareOneTimeQuery (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:47915)
Sep 06 22:12:17 start-web[7437]: at QueryPromise._prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:106753)
Sep 06 22:12:17 start-web[7437]: at QueryPromise.all (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:106930)
Sep 06 22:12:17 start-web[7437]: at QueryPromise.execute (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:107064)
Sep 06 22:12:17 start-web[7437]: at QueryPromise.then (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:79304)
Sep 06 22:12:17 start-web[7437]: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
Sep 06 22:12:17 start-web[7437]: code: 'SQLITE_ERROR'
Sep 06 22:12:17 start-web[7437]: },
Sep 06 22:12:17 start-web[7437]: code: 'INTERNAL_SERVER_ERROR',
Sep 06 22:12:17 start-web[7437]: name: 'TRPCError'
Sep 06 22:12:17 start-web[7437]: }

Device Details

NixOS 25.05

Exact Karakeep Version

v0.24.1

Have you checked the troubleshooting guide?

I have checked the troubleshooting guide and I haven't found a solution to my problem

Originally created by @Crazzygamerr on GitHub (Sep 7, 2025). Original GitHub issue: https://github.com/karakeep-app/karakeep/issues/1897 ### Describe the Bug Hi all, I'm a big fan of Karakeep and have been running it on my server for a good while now. Last weekend, I was running v26 temporarily while testing and have since rolled back to 24.1. Seeing an Sqlite related error when trying to save/view bookmarks. ### Steps to Reproduce 1. Run Karakeep on 24.1 2. Update to 26 with the same db 3. Rollback to 24.1 ### Expected Behaviour Ideally would expect rollbacks to be possible, would be interested to know why it's not supported ### Screenshots or Additional Context Sep 04 22:49:18 start-web[7437]: ▲ Next.js 14.2.25 Sep 04 22:49:18 start-web[7437]: - Local: http://localhost:3000 Sep 04 22:49:18 start-web[7437]: - Network: http://0.0.0.0:3000 Sep 04 22:49:18 start-web[7437]: ✓ Starting... Sep 04 22:49:24 start-web[7437]: ✓ Ready in 31s Sep 06 22:12:17 start-web[7437]: SqliteError: table bookmarkLinks has no column named content Sep 06 22:12:17 start-web[7437]: at Database.prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) Sep 06 22:12:17 start-web[7437]: ... 6 lines matching cause stack trace ... Sep 06 22:12:17 start-web[7437]: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { Sep 06 22:12:17 start-web[7437]: cause: SqliteError: table bookmarkLinks has no column named content Sep 06 22:12:17 start-web[7437]: at Database.prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) Sep 06 22:12:17 start-web[7437]: at b.prepareQuery (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:49045) Sep 06 22:12:17 start-web[7437]: at b.prepareOneTimeQuery (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:47915) Sep 06 22:12:17 start-web[7437]: at QueryPromise._prepare (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:106753) Sep 06 22:12:17 start-web[7437]: at QueryPromise.all (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:106930) Sep 06 22:12:17 start-web[7437]: at QueryPromise.execute (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:107064) Sep 06 22:12:17 start-web[7437]: at QueryPromise.then (/nix/store/95b25kwy0lnwrynlkr80fsx5094p5qsa-karakeep-0.24.1/lib/karakeep/apps/web/.next/standalone/apps/web/.next/server/chunks/8195.js:67:79304) Sep 06 22:12:17 start-web[7437]: at process.processTicksAndRejections (node:internal/process/task_queues:105:5) { Sep 06 22:12:17 start-web[7437]: code: 'SQLITE_ERROR' Sep 06 22:12:17 start-web[7437]: }, Sep 06 22:12:17 start-web[7437]: code: 'INTERNAL_SERVER_ERROR', Sep 06 22:12:17 start-web[7437]: name: 'TRPCError' Sep 06 22:12:17 start-web[7437]: } ### Device Details NixOS 25.05 ### Exact Karakeep Version v0.24.1 ### Have you checked the troubleshooting guide? - [x] I have checked the troubleshooting guide and I haven't found a solution to my problem

kerem

2026-03-02 11:55:32 +03:00

closed this issue
added the
bug

status/untriaged
labels

kerem commented

2026-03-02 11:55:34 +03:00

Author

Owner

@MohamedBassem commented on GitHub (Sep 7, 2025):

Rollbacks today are not supported because the orm we’re currently using doesn’t support rollbacks. So db migrations can only go forward (as of today). When you rollback, the code runs against the new schema and that’s not always backward compatible.

@MohamedBassem commented on GitHub (Sep 7, 2025): Rollbacks today are not supported because the orm we’re currently using doesn’t support rollbacks. So db migrations can only go forward (as of today). When you rollback, the code runs against the new schema and that’s not always backward compatible.

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/karakeep#1177

No description provided.

Rows
Columns