Logos 4b fails on startup "Could not load file or assembly 'System.Data.SQLite"

Page 1 of 1 (8 items)
This post has 7 Replies | 1 Follower

Posts 26
Ian Shepard | Forum Activity | Posted: Tue, Mar 16 2010 4:57 PM

I've tried just about everything I can think of to get this working.  Logos was working fine for me up until I updated it today.  Pertinent information:

What I did: 

  1. Launch Logos, allow auto-update
  2. Received "Logos Bible Software 4 has encountered a problem and needs to close" message from Windows.  Clicked [Don't Send]
  3. Tried it again, same problem
  4. Launched installer again (manually from temp files), chose [Repair] - launched again, same problem
  5. Hit the forums, deleted the keymanager.db and catalog.db - relaunched, same problem
  6. Renamed the ..\Data\<gibberish>.<more>\ and ..\Downloads\<gibberish>.<more>\ directories, launched again, same problem
  7. Forced Windows Update, updated .NET framework, reboot, launched again, same problem

As of right now, there's not a lot that I can think of and I can't see anything in the forums that relate directly to this issue.

The log says this and I'm positive that's the problem:

  • Error ID: 7948
    Error detail: FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.65.1010, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Thoughts?  7522.Logos4.log1261.Logos4Crash.txt

Posts 24926
Forum MVP
Dave Hooton | Forum Activity | Replied: Tue, Mar 16 2010 6:54 PM

This is rather complex but the crash appears to be connected to the statistics database:-

C:\Documents and Settings\Owner\Local Settings\Application Data\Logos4\Data\h4wybzsg.tyx\Statistics\Statistics.db

Rename this eg. to Statistics.old and restart L4.

When you launch L4 do you have to sign-in?

 

Dave
===

Windows & Android

Posts 26
Ian Shepard | Forum Activity | Replied: Tue, Mar 16 2010 7:10 PM

It opens a new statistics.db and a lock file (literally "Statistics.lock") right next to it, then fails. 

No, I don't have to sign in.  I've also tried the "Blank Profile" thing that didn't work either.

Posts 8010
LogosEmployee

IanShepard:

The log says this and I'm positive that's the problem:

  • Error ID: 7948
    Error detail: FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.65.1010, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

It looks like the update didn't replace all the files on your system (I'm not sure why). Try this:

1. Delete the file C:\Documents and Settings\Owner\Local Settings\Application Data\Logos4\System\System.Data.SQLite.dll

2. Right-click the file C:\Documents and Settings\Owner\Local Settings\Application Data\Logos4\Install\Installers\Logos4.msi, choose Repair.

Posts 26
Ian Shepard | Forum Activity | Replied: Tue, Mar 16 2010 10:01 PM

Deleting the files went without issue.  The installer didn't want to repair.  I then updated my other Windows machine in the house (without issue) and copied its ..\Logos4\System directory (except the *.config files) to a thumbdrive and put them on this system. 

Same problem.

So I deleted the statistics.db file and tried again - same problem.

2010-03-17 00:57:43.8585 1 Info LocalFileDatabase Found existing database at C:\Documents and Settings\Owner\Local Settings\Application Data\Logos4\Data\h4wybzsg.tyx\Statistics\Statistics.db
2010-03-17 00:57:44.1085 1 Info LocalFileDatabase Creating new database at C:\Documents and Settings\Owner\Local Settings\Application Data\Logos4\Data\h4wybzsg.tyx\Statistics\Statistics.db
2010-03-17 00:57:44.4522 1 Error OurApp Unhandled exception: System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.65.1010, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite, Version=1.0.65.1010, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.62.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite, Version=1.0.62.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'

And on that bombshell, goodnight.

If anyone else has any ideas, I'll start on those after I get home from work tomorrow. 

Posts 8010
LogosEmployee
Bradley Grainger (Faithlife) | Forum Activity | Replied: Tue, Mar 16 2010 10:11 PM

IanShepard:

So I deleted the statistics.db file and tried again - same problem.

It may actually be a problem with the Logos4.exe.config file--the program should be looking for v1.0.65.1011, not 1.0.65.1010 or 1.0.62.0. Try replacing that file with the copy from the other computer and see if that helps.

My other thought is that perhaps some other program has installed v1.0.62.0 in the GAC (Global Assembly Cache) and that's interfering with Logos 4. Our program should be loading the DLL from its installation folder, so I'm not sure this is actually the problem. Do you have the same programs installed on both computers, or are they set up fairly differently?

Posts 26
Ian Shepard | Forum Activity | Replied: Tue, Mar 16 2010 10:25 PM

That made a lot of sense.  I checked the file and, sure enough, it was looking for the 1.0.65.1010 file as the new file.  Put the new config files in place and all is well.  Thank you!  I really appreciate your help!

Posts 47
Jeffrey S Gordon | Forum Activity | Replied: Fri, Mar 19 2010 3:51 PM

This was a very useful thread.  I just got the same crash problem, edited the aforementioned config file directly (changing 1010 to 1011) and it seems to be starting up. 

Page 1 of 1 (8 items) | RSS