Changes in WebPush may require removing the DB

Connected Devices Project Link
#1

Hello folks,

yesterday, Andrew landed a patch to update the WebPush implementation against the newest standard (thank you, Andrew!). This patch included a change in the WebPush DB that might cause the following error:

thread '<unnamed>' panicked at 'calledResult::unwrap()on anErrvalue: SqliteFailure(Error { code: Unknown, extended_code: 1 }, Some("table subscriptions has 3 columns but 4 values were supplied"))', ../src/libcore/result.rs:746

To fix this, you just need to remove the WebPush DB from your profile folder (most likely located at ~/.local/shared/foxbox).

You won’t see this error if you had no previous WebPush DB.

Cheers,

/ Fernando

1 Like
#2

That completely blind sided me. Mainly because I am constantly deleting the database file just as quick way to clear out my subscriptions. Thanks for pointing this out!

#3

We don’t have to deal cleanly with db upgrades yet, but this is something to keep in mind before we hit a real release.