VorlonCD / bi-aidetection

Alarm system for Blue Iris based on Artificial Intelligence.
https://ipcamtalk.com/threads/tool-tutorial-free-ai-person-detection-for-blue-iris.37330/
GNU General Public License v2.0
206 stars 45 forks source link

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

Open yeahman45 opened 9 months ago

yeahman45 commented 9 months ago

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

what does that mean?

VorlonCD commented 9 months ago

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

yeahman45 commented 9 months ago

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 https://github.com/VorlonCD/bi-aidetection/issues/343#issuecomment-1837610925, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEJTZP2BLRLZPXD5AYP25B3YHTX5VAVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZXGYYTAOJSGU . You are receiving this because you authored the thread.Message ID: @.***>

VorlonCD commented 9 months ago

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

yeahman45 commented 9 months ago

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 https://github.com/VorlonCD/bi-aidetection/issues/343#issuecomment-1838750519, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEJTZP2NMAVDHJAMUONL7ODYHXMX7AVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZYG42TANJRHE . You are receiving this because you authored the thread.Message ID: @.***>

VorlonCD commented 9 months ago

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

yeahman45 commented 9 months ago

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 https://github.com/VorlonCD/bi-aidetection/issues/343#issuecomment-1840844404, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEJTZP77LC53YL3DF5PZMNDYH4R5LAVCNFSM6AAAAABAE7UAL2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBQHA2DINBQGQ . You are receiving this because you authored the thread.Message ID: @.***>