Perplexica: SQLite Errors & No Chat History

Describe the bug App is throwing SQLite errors regarding chat history in docker deployment.

To Reproduce Execute search, console displays SQLite error.

Expected behavior A chat history to be present.

Console Output SqliteError: no such table: chats at ew.prepareQuery (.next/server/chunks/979.js:13:21127) at QueryPromise._prepare (.next/server/chunks/979.js:13:15114) at QueryPromise.executeRaw (.next/server/chunks/979.js:13:16113) at QueryPromise.execute (.next/server/chunks/979.js:13:16184) at QueryPromise.then (.next/server/chunks/979.js:13:668) { code: 'SQLITE_ERROR'

Additionally, post search query complete:

SqliteError: no such table: messages at ew.prepareQuery (.next/server/chunks/979.js:13:21127) at ew.prepareOneTimeQuery (.next/server/chunks/979.js:13:19998) at QueryPromise._prepare (.next/server/chunks/979.js:13:11567) at QueryPromise.run (.next/server/chunks/979.js:13:11714) at QueryPromise.execute (.next/server/chunks/979.js:13:11889) at EventEmitter.<anonymous> (.next/server/app/api/chat/route.js:1:3097) at z.handleStream (.next/server/chunks/911.js:62:2899) { code: 'SQLITE_ERROR'

Additional context Causes blank/error page when opening “Library” tab with `Application error: a client-side exception has occurred while loading insert server IP here (see the browser console for more information).’ No info in browser console.

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Reactions: 3
  • Comments: 24 (9 by maintainers)

Most upvoted comments

I solved this by a workaround:

  1. Set docker compose to use the docker volume
  2. Started docker and copied db.sqlite out to the host (created correctly)
  3. Put file in place in ./data
  4. Changed docker compose to use bind mount