database disk image is malformed [SQLiteException] Mod: InsertHistoryItem(History hist) Line:258:21267195

Question

database disk image is malformed [SQLiteException] Mod: InsertHistoryItem(History hist) Line:258:21267195

Opened this issue 8 months ago · 6 comments

I often get this error:
database disk image is malformed [SQLiteException] Mod: InsertHistoryItem(History hist) Line:258:21267195

what does that mean?

Answer 1 · 2023-12-03T21:51:12.000Z

Never seen it.

First keep an eye on drive space. Clean out your temp folder once and a while. Low drive space could be causing it.

Restart the machine or just AITOOL once and a while

Does your machine unexpectedly reboot sometimes due to some hardware issue? This could be causing corruption in the database.

Run chkdsk c: /f at a command prompt once and a while (let it reboot to fix)
Close AITOOL and delete \_Settings\Aitool.Database.* files once and a while

Answer 2 · 2023-12-04T04:59:39.000Z

Where is the temp folder located? I have restarted ai tool and I have enough storage.

…

On Mon, Dec 4, 2023, 01:51 VorlonCD ***@***.***> wrote: Never seen it. First keep an eye on drive space. Clean out your temp folder once and a while. Low drive space could be causing it. Restart the machine or just AITOOL once and a while Does your machine unexpectedly reboot sometimes due to some hardware issue? This could be causing corruption in the database. Run chkdsk c: /f at a command prompt once and a while (let it reboot to fix) Close AITOOL and delete \_Settings\Aitool.Database.* files once and a while — Reply to this email directly, view it on GitHub <#343 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEJTZP2BLRLZPXD5AYP25B3YHTX5VAVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZXGYYTAOJSGU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

Answer 3 · 2023-12-04T14:28:03.000Z

In FILE explorer address window, type %TEMP% and press enter. you should see 1000's of files/folders you can delete. Also Start menu > type "Disk Cleanup" should do the same.

If doesnt help, try the other suggestions

Answer 4 · 2023-12-05T05:40:47.000Z

Ah you meant windows temp files. I don't think it is related but I will try. It seems it is more to do with the database. Is it possible to clear it but keep my config (masks, paths etc...) ?

…

On Mon, Dec 4, 2023, 18:28 VorlonCD ***@***.***> wrote: In FILE explorer address window, type %TEMP% and press enter. you should see 1000's of files/folders you can delete. Also Start menu > type "Disk Cleanup" should do the same. If doesnt help, try the other suggestions — Reply to this email directly, view it on GitHub <#343 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEJTZP2NMAVDHJAMUONL7ODYHXMX7AVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZYG42TANJRHE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

Answer 5 · 2023-12-05T13:57:31.000Z

deleting the database does not delete the settings. ONLY the history tab contents. But you basically have the same thing in BI anyway.

anything filling the hard drive too much such as temp files could have caused the database corruption

Answer 6 · 2023-12-05T14:02:56.000Z

Ok thx. Can you point me the path of the database? I will also check for my harddrive. Thx for the help

…

On Tue, Dec 5, 2023, 17:57 VorlonCD ***@***.***> wrote: deleting the database does not delete the settings. ONLY the history tab contents. But you basically have the same thing in BI anyway. anything filling the hard drive too much such as temp files *could* have caused the database corruption — Reply to this email directly, view it on GitHub <#343 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEJTZP77LC53YL3DF5PZMNDYH4R5LAVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBQHA2DINBQGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>