Reply to thread

Message

This is very strange because the databases have been created correctly and all of the tables and indexes look right. They are generated using SQLite Client. The bit that goes wrong is the bit that gets data from the database and that uses EntityFramework. Now I know that the database is empty but the code that accesses the database is using LINQ to get any existing data in the database to place it is a cache. The failure occurs is in executing that fetch.

The config file looks correct as well but there has to be a problem with the set-up. Could you make sure that the following files exist in C:\Program Files (x86)\Team MediaPortal\MediaPortal:

EntityFramework.dll
SQLite.Interop.dll
System.Data.SQLite.dll
System.Data.SQLite.EF6.dll
System.Data.SQLite.Linq.dll

When I tested renaming any of these, MP1 crashed out rather than hanging. But if you can check anyway then I can definitely rule that out.

I know it's a pain, but would you please try the following. Instead of copying your current configuration to the partition, would you please install a fresh single seat installation of MP1.29, then run the BAT file and then delete the databases and run the GUI. By doing this, you will be mirroring exactly what I have been doing and we will identify whether you are using something that isn't compatible with the refactored version.

If you've already done that then let me know and we'll have to start going through the files one at a time.

I've performed this procedure on over five separate machines and it's never gone wrong for me. Therefore, I suspect there may be a basic configuration difference between your initial set-up and a fresh install of 1.29.

Thanks.

Tony

<blockquote data-quote="Anthony Vaughan" data-source="post: 1288486" data-attributes="member: 153283">This is very strange because the databases have been created correctly and all of the tables and indexes look right. They are generated using SQLite Client. The bit that goes wrong is the bit that gets data from the database and that uses EntityFramework. Now I know that the database is empty but the code that accesses the database is using LINQ to get any existing data in the database to place it is a cache. The failure occurs is in executing that fetch.The config file looks correct as well but there has to be a problem with the set-up. Could you make sure that the following files exist in C:\Program Files (x86)\Team MediaPortal\MediaPortal:EntityFramework.dllSQLite.Interop.dllSystem.Data.SQLite.dllSystem.Data.SQLite.EF6.dllSystem.Data.SQLite.Linq.dllWhen I tested renaming any of these, MP1 crashed out rather than hanging. But if you can check anyway then I can definitely rule that out.I know it's a pain, but would you please try the following. Instead of copying your current configuration to the partition, would you please install a fresh single seat installation of MP1.29, then run the BAT file and then delete the databases and run the GUI. By doing this, you will be mirroring exactly what I have been doing and we will identify whether you are using something that isn't compatible with the refactored version.If you've already done that then let me know and we'll have to start going through the files one at a time.I've performed this procedure on over five separate machines and it's never gone wrong for me. Therefore, I suspect there may be a basic configuration difference between your initial set-up and a fresh install of 1.29.Thanks.Tony</blockquote>

[QUOTE="Anthony Vaughan, post: 1288486, member: 153283"] This is very strange because the databases have been created correctly and all of the tables and indexes look right. They are generated using SQLite Client. The bit that goes wrong is the bit that gets data from the database and that uses EntityFramework. Now I know that the database is empty but the code that accesses the database is using LINQ to get any existing data in the database to place it is a cache. The failure occurs is in executing that fetch. The config file looks correct as well but there has to be a problem with the set-up. Could you make sure that the following files exist in C:\Program Files (x86)\Team MediaPortal\MediaPortal: EntityFramework.dll SQLite.Interop.dll System.Data.SQLite.dll System.Data.SQLite.EF6.dll System.Data.SQLite.Linq.dll When I tested renaming any of these, MP1 crashed out rather than hanging. But if you can check anyway then I can definitely rule that out. I know it's a pain, but would you please try the following. Instead of copying your current configuration to the partition, would you please install a fresh single seat installation of MP1.29, then run the BAT file and then delete the databases and run the GUI. By doing this, you will be mirroring exactly what I have been doing and we will identify whether you are using something that isn't compatible with the refactored version. If you've already done that then let me know and we'll have to start going through the files one at a time. I've performed this procedure on over five separate machines and it's never gone wrong for me. Therefore, I suspect there may be a basic configuration difference between your initial set-up and a fresh install of 1.29. Thanks. Tony [/QUOTE]