[email protected] <\/a><\/p>\nThey should be able to get you going again, but you will more than likely need to send them your database and log files.<\/p>","upvoteCount":0,"datePublished":"2010-07-14T12:10:48.000Z","url":"https://community.spiceworks.com/t/i-have-a-corrupted-database/56329/5","author":{"@type":"Person","name":"craigm","url":"https://community.spiceworks.com/u/craigm"}},"suggestedAnswer":[{"@type":"Answer","text":"
I have been told my Spiceworks database is corrupt. Help Desk works, but Inventory functions seem to be broken. I sent in a backup of our database and was told it was irreparable.<\/p>\n
Problems started only a few days ago when I upgraded our Spiceworks and deleted our Spiceworks inventory to get a fresh take of our current software inventory environment. I don’t know which of these two things was the culprit, but i have several backups to draw from if necessary.<\/p>\n
At least if someone could point me in the direction of instructions for repairing a Spiceworks SQLite db, that would be helpful.<\/p>\n
Thanks!<\/p>","upvoteCount":1,"datePublished":"2010-07-14T11:38:32.000Z","url":"https://community.spiceworks.com/t/i-have-a-corrupted-database/56329/1","author":{"@type":"Person","name":"rannsanders","url":"https://community.spiceworks.com/u/rannsanders"}},{"@type":"Answer","text":"
We had effectively the same thing happen for exactly the same reasons. We had to roll back our install to before the upgrade/inventory deletion and then everything started working again.<\/p>","upvoteCount":0,"datePublished":"2010-07-14T11:47:50.000Z","url":"https://community.spiceworks.com/t/i-have-a-corrupted-database/56329/2","author":{"@type":"Person","name":"kelly","url":"https://community.spiceworks.com/u/kelly"}},{"@type":"Answer","text":"
Were you able to reset your software inventory after that? If so, how?<\/p>\n
Thanks Sosipater.<\/p>","upvoteCount":0,"datePublished":"2010-07-14T11:52:24.000Z","url":"https://community.spiceworks.com/t/i-have-a-corrupted-database/56329/3","author":{"@type":"Person","name":"rannsanders","url":"https://community.spiceworks.com/u/rannsanders"}},{"@type":"Answer","text":"
After that I’ve only dared to delete small bunches of items. I think there is an issue with using the bulk delete on more than just a few items that causes the corruption. This is just my surmise at this point, but the evidence seems to point in that direction. Dumping the inventory using that doesn’t seem to work as far as I know. I’m probably going to end up using the Firefox SQLite plugin to do my dirty work, just haven’t had the time.<\/p>","upvoteCount":0,"datePublished":"2010-07-14T11:57:56.000Z","url":"https://community.spiceworks.com/t/i-have-a-corrupted-database/56329/4","author":{"@type":"Person","name":"kelly","url":"https://community.spiceworks.com/u/kelly"}}]}}
I have been told my Spiceworks database is corrupt. Help Desk works, but Inventory functions seem to be broken. I sent in a backup of our database and was told it was irreparable.
Problems started only a few days ago when I upgraded our Spiceworks and deleted our Spiceworks inventory to get a fresh take of our current software inventory environment. I don’t know which of these two things was the culprit, but i have several backups to draw from if necessary.
At least if someone could point me in the direction of instructions for repairing a Spiceworks SQLite db, that would be helpful.
Thanks!
1 Spice up
kelly
July 14, 2010, 11:47am
2
We had effectively the same thing happen for exactly the same reasons. We had to roll back our install to before the upgrade/inventory deletion and then everything started working again.
Were you able to reset your software inventory after that? If so, how?
Thanks Sosipater.
kelly
July 14, 2010, 11:57am
4
After that I’ve only dared to delete small bunches of items. I think there is an issue with using the bulk delete on more than just a few items that causes the corruption. This is just my surmise at this point, but the evidence seems to point in that direction. Dumping the inventory using that doesn’t seem to work as far as I know. I’m probably going to end up using the Firefox SQLite plugin to do my dirty work, just haven’t had the time.
craigm
July 14, 2010, 12:10pm
5
Contact Spiceworks directly at support@spiceworks.com
They should be able to get you going again, but you will more than likely need to send them your database and log files.
