Indie game storeFree gamesFun gamesHorror games
Game developmentAssetsComics
SalesBundles
Jobs
Tags

Butler / Itch desktop app corrupts sqlite database?

A topic by Tjoeker created Sep 18, 2019 Views: 468 Replies: 3
Viewing posts 1 to 4

Hey,

I've been using butler to update my game for a while now and I love it.

But today we pushed another patch and I received a bug report from a user.
            System.Data.SQLite.SQLiteException (0x800007EF): database disk image is malformed
(which is our database, not something from Itch)

Is it possible that the butler updater / itch desktop app corrupts our database? (doesn't properly replace it or doesn't delete files I deleted from the folder?)

I tested the game on my system before pushing via butler and after updating via the itch desktop app. Both work fine on my system.

Today we released another patch, and it caused the same issue. May I suggest butler to replace all .sqlite files no matter what? (so completely remove the old file and put in the new file, even if there is no difference between the two.)

(+1)

Hey there,

I've identified a few bugs today, and this is one of them - you don't have to do anything, I'll release a fix in the coming week that will completely solve that issue.

I would still recommend putting save data somewhere else though - by putting it in the game folder, it'll get overwritten when the game updates (with the correct version, once this bug is fixed..), which may be bad for your players that want to hang on to their saves!

Thank you very much!

Putting our savedata elsewhere is indeed on our to do list. :)

But we're also using a separate sqlite database for storing somewhat customizable game objects.