SqliteError "no such table"

[k1ngrnbz]

Hey Guys,
i just created an exe of my electron project. After running the exe i get this Error in my console:

SqliteError
code: "SQLITE_ERROR"
message: "no such table: settings"
stack: "SqliteError: no such table: settings↵ 

i used electron-packager ./ DC --platform=win32 --arch=x64 for building my exe.

[JoshuaWise]

This probably means you opened up a new (empty) database because there was no existing database at the file path you specified.

Try adding the option { fileMustExist: true } when opening the database. This will confirm or deny my theory.

[JoshuaWise]

@k1ngrnbz Any progress on this issue?

[k1ngrnbz]

Hey @JoshuaWise my electron app does connect to an sqlite3 database which already exists and is full of data which works. But when i'm trying to create my windows exe file the same database is in the resources folder. But i get this error. There is no database which is empty.

[JoshuaWise]

@k1ngrnbz Since better-sqlite3 doesn't do anything fancy with file paths, it seems that this issue is related to electron-packager, and not better-sqlite3 itself. I'll close this issue, but feel free to look for support in the dedicated electron help thread.

[i-chaochen]

I had the same issue, fixed it by change the db connection by path

const db = new Database(path.resolve(__dirname, 'myDB.db'), {fileMustExist: true});