Working with a fresh install of Spiceworks, I notice that the "pragma integrity_check" command returns errors immediately after installation, mostly "error 11" and "child page depth differs" errors. Nothing has been done with the database yet.

As Spiceworks runs, it gets worse and worse. Now, after two weeks, Spiceworks continues to run OK, but SQLite Maestro and SQLite Studio both report multiple "database image is malformed" errors, and neither will show records correctly - for instance both show only one ticket in the "tickets" table, although there are perhaps 10 in there.

This is a test platform, and the SQLite Maestro / Studio tools are being used in a read-only manner to explore the data structures and to help develop a set of scripts that will automatically delete e-mail signatures and image files embedded by Outlook / Exchange. These scripts have *not* been run against this database, and are therefore not related to these error messages in any way. *Only* Spiceworks has been running against this database.

Is this an issue of mis-matched versions of SQLite? I am running SpiceWorks alone on a Windows 7 Enterprise virtual machine, and nothing else is accessing the database at any time.

Thanks for your reply. This was a fresh OS the second time I installed Spiceworks.

Additionally, those two SQLite programs aren't really "install" types of programs, they are like SQLite itself in that they are just standalone executables that you unzip and run from a folder of your choosing.

I've had good luck with support in the past, so I'll take your advice and send them a message.

One thing to watch out for, apparently some of these 3rd-party SQLite tools use a "cache" when working with the database, and I wonder if that impacts queries and even non-row-returning statements like "pragma".

I cannot retest now, but I have seen instances where the latest data is not reflected in a query's result set until the tool is closed and re-opened, then they magically appear! The same might have held true for my first re-install of Spiceworks, if I left the 3rd-party tool open it may have been reporting corruption on some cached copy of the SQLite database.

Interestingly, and surprisingly, I don't believe I ever heard back from support...