Issue with Background:System.Data.SQLite.SQLiteException

[netwrk219]

Hi Helpful Propeller heads!

I created a new project in Flare, then populated it with images and .htm pages I plan to use across multiple projects. The goal is to use this as a base file for all the docs I write for a specific department.

When I start Flare and select the project, I get the following in the messages field:

Code: Select all

Background:System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteScalar(CommandBehavior behavior)
   at B3.ContentAnalyzerKit.ContentDatabaseWrapper.GetFileId(IUrl url)
   at B3.ContentAnalyzerKit.ContentDatabaseWrapper.AddOrGetFileId(IUrl url)
   at B3.ContentAnalyzerKit.ContentScanner.ScanFile(IUrl url, Boolean& didScan, Nullable`1 outsideProgress, Boolean useIsFileUpToDateCheck)
   at B3.ContentAnalyzerKit.ContentScanner.ScanVariableFiles(UrlList variableFiles)
   at B3.ContentAnalyzerKit.ContentScanner.ScanProjectFiles(UrlList changedFiles)
   at B3.ContentAnalyzerKit.ContentScanner.Scan(UrlList changedFiles)
   at B3.ContentAnalyzerKit.AnalyzeContentBackgroundWorker.OnDoCustomWork(DoWorkEventArgs e)
   at B3.AppKit.CustomBackgroundWorker.OnDoWork(DoWorkEventArgs e)

I have looked through the forums and have seen people say that deleting the contents of the analyzer folder will resolve this. But it has not. I would appreciate any wisdom you may have on this.

[Catcha]

Hi
I have the same issue right now. Did you figure out how to solve it yet?
(or anybody else?)

[Fiona]

This is an issue for me too now...has anyone managed to resolve it?

Background:System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed
database disk image is malformed
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteScalar(CommandBehavior behavior)
at B3.ContentAnalyzerKit.ContentDatabaseWrapper.GetFileId(IUrl url)
at B3.ContentAnalyzerKit.ContentDatabaseWrapper.AddOrGetFileId(IUrl url)
at B3.ContentAnalyzerKit.ContentScanner.ScanFile(IUrl url, Boolean& didScan, Nullable`1 outsideProgress, Boolean useIsFileUpToDateCheck)
at B3.ContentAnalyzerKit.ContentScanner.ScanContentFiles(UrlList scanFiles, Boolean useIsFileUpToDateCheck)
at B3.ContentAnalyzerKit.ContentScanner.ScanProjectFiles(UrlList changedFiles)
at B3.ContentAnalyzerKit.ContentScanner.Scan(UrlList changedFiles)
at B3.ContentAnalyzerKit.AnalyzeContentBackgroundWorker.OnDoCustomWork(DoWorkEventArgs e)
at B3.AppKit.CustomBackgroundWorker.OnDoWork(DoWorkEventArgs e)

[Fiona]

MadCap tech support contacted me with a fix...posting it here for anyone else who experiences this issue.

"Please clean the Flare project so we can rule out any temporary files that may be causing issues.
→ Close Flare
→ Browse to the folder with your Flare project using Windows Explorer
→ Delete the Analyzer and Output folder (or move the Output folder to a different location if you do not want to lose any previously built outputs)
→ Browse into your Project folder and delete the "Users" folder inside
→ Re-open Flare and your project
→ Check to see if you are still experiencing the issue"

Thank you MadCap