For some reason I can’t access my SQLite Spiceworks database through the Firefox plugin anymore. Nor can I get to it through the SQLite DB manager. It was working fine yesterday & now the service will intermittently stop/crash.
I ran the integrity check & it came out ok so I’m somewhat stumped. Any help would be appreciated. 
2 Spice ups
Do you have a backup from yesterday? Did you change anything in the database yesterday/today?
Modifying the SQLite database directly with the firefox plugin or SQLite editor is not supported by Spiceworks although they will try their best to help. You may have to send your logs and database to Spiceworks for them to clean the database and reconstruct it if needed.
I didn’t have a backup. All I did yesterday was add some custom reports people had written to check them out.
I never modify anything in the sqlite database but I do run select statements on it to see what I can build report-wise.
I just had some issues caused by one of the SW admin email not responding. Each of the email this person had created got Non Delivery Receipt of a mile long 15 to 20 times. The spiceworks server disk became full ! The backups went from 10MB to 1000G. All emails are kept in a seperate folder (c:\program files (x86) \spiceworks\ data\ data \ uploads \ ticket )
The database was not corrupt but the lack of soace made it impossible to run. The server was in a endless backup loop.
