jr web: design_docs table missing - View design docs link crashes

t-147·WorkTask·
·
·
·Omni/Jr/Web.hs
Created3 months ago·Updated3 months ago

Dependencies

Description

Edit

Error: SQLite3 returned ErrorError while attempting to perform prepare SELECT ... FROM design_docs: no such table: design_docs

Root cause: Database was migrated from older version before design_docs table was added. initTaskDb creates the table but wasn't re-run after migration.

Fix options: 1. Run initTaskDb on jr web startup to ensure schema is current (idempotent CREATE TABLE IF NOT EXISTS) 2. Add migration check in withDb that creates missing tables 3. Manual fix: sqlite3 ~/.local/share/jr/jr.db and run the CREATE TABLE statement

Recommended: Option 1 - call initTaskDb at web server startup in Web.run

Immediate workaround: Run jr task init to create missing tables

Timeline (0)

No activity yet.