"FOREIGN KEY constraint failed" error after update

[thomz92]

Description

I started FrappeBooks and notification popped up to "restart FrappeBooks to install update". I did that, and after a restart got an error that says "FOREIGN KEY constraint failed". Then it returns to the home screen.

Steps to Reproduce

I see my database listed still, but every time I click on it it gives me the same error. I'm at a standstill unfortunately until this is resolved.

Info

Error: DatabaseError: Error
FOREIGN KEY constraint failed

Stack:

Error: FOREIGN KEY constraint failed
    at client.transaction.connection (C:\Program Files\Frappe Books\resources\app.asar\node_modules\knex\lib\dialects\sqlite3\schema\ddl.js:359:21)

Version: 0.28.0
Platform: win32
Path: /index.html
Language: -

[akshayitzme]

@thomz92
I tried updating from v0.27 to v0.28 but couldn't catch the error. Did you upgrade from v0.27 or earlier version ?.

[thomz92]

@akshayitzme I honestly don't remember what version. I've been updating pretty much every time it prompted me, so likely v0.27 I would think?

[dakshhmehta]

I am facing same issue. Upgraded day before yesterday