Runtime Error - System.Data.SqLite.dll (XMLTvExtras.exe)

[GoogleRocks!]

I'm running NPVR 3.1.1 R1a in a Windows 8.1 64 bit environment.

MS VS C++ Runtimes are installed - both 32 & 64 bit for 2008, 2010 and 2012 Redistributable packages.

The main mc2xml.exe file runs without issues, however the XmltvExtras.exe silently fails due to:

"This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded, exiting"

Help is always appreciated...

EDIT: System.Data.SqLite.dll Version is 1.0.85.0 (4/17/2013)
EDIT: XmltvExtras.exe Version is 3.1.2.16688 - mc2xml.exe Version is 1.2.0.0

For Increased visibility, same issue here: http://forums.nextpvr.com/showthread.php...-execution

[alibert]

Hi,

can you try if the attached version works for you? I've recompiled the utility with .net 4 to be compatible with npvr 3 (and the new sqlite dll).

-alibert

[GoogleRocks!]

Thanks for your reply, been out of town for a few.

Seems to have resolved original failure, however we now have a new issue/result:

...from the batch file result -

C:\WINDOWS\system32>C:

C:\WINDOWS\system32>cd "C:\Program Files (x86)\NPVR\mc2xml"

C:\Program Files (x86)\NPVR\mc2xml>XmltvExtras.exe

Error connecting to database: The type initializer for 'System.Data.SQLite.SQLit
eFactory' threw an exception.
Exiting.

C:\Program Files (x86)\NPVR\mc2xml>sc control "nDroid Service" 129

SERVICE_NAME: nDroid Service
TYPE : 110 WIN32_OWN_PROCESS (interactive)
STATE : 4 RUNNING
(STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

No difference when run without the nDroid Service call.

[GoogleRocks!]

I'm getting somewhere...

Placed the Sqlite.Interop.dll into the same directory as where the System.Data.Sqlite.dll file is (my mc2xml folder below the NPVR program directory), and re-ran the PostUpdate.bat file again (as Administrator - same as previous) and everything progressed until a new error occurred:

NOTE: that I've ran this a couple of times, hence no new outdated entries to update

C:\WINDOWS\system32>cd "C:\Program Files (x86)\NPVR\mc2xml"

C:\Program Files (x86)\NPVR\mc2xml>XmltvExtras.exe
Getting xmltv files from NPVR database...
Got 1 xmltv files from NPVR database.
Searching for outdated entries...
No outdated programme entries found in programme extras.
Reading c:\program files (x86)\npvr\mc2xml\xmltv.xml...
Found 0 programmes containing extra data.
Mapping xmltv channels to NPVR channels...
Mapped 511 xmltv channels to NPVR channels.
Mapping xmltv programmes to NPVR programmes...

Error mapping xmltv programmes to NPVR programmes: String was not recognized as
a valid DateTime.
Exiting.

C:\Program Files (x86)\NPVR\mc2xml>sc control "nDroid Service" 129

SERVICE_NAME: nDroid Service
TYPE : 110 WIN32_OWN_PROCESS (interactive)
STATE : 4 RUNNING
(STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

[alibert]

Hi,

thanks for the feedback. Can you try it again with the attached version, please?

-alibert

[SilverTiger]

Hi,

thanks for the feedback. Can you try it again with the attached version, please?

-alibert

I'm not the original poster, but I had the same problem with 3.1.1, so I tried this version and it seemed to work. Here is the output
Getting xmltv files from NPVR database...
Got 1 xmltv files from NPVR database.
Searching for outdated entries...
Found and removed 619 entries from programme extras.
Reading e:\nextpvr\mc2xml\xmltv.xml...
Found 28393 programmes containing extra data.
Mapping xmltv channels to NPVR channels...
Mapped 223 xmltv channels to NPVR channels.
Mapping xmltv programmes to NPVR programmes...
Mapped 0 xmltv programmes to NPVR programmes.
Adding programme extras from xmltv to TVListings database...
Updated 0 entries.
Finished.

The one on the WIKI does not work. Fails with the "SQLLite" issue.

[alibert]

Thanks for your feedback - I replaced the version at the wiki with the working one, too.

-alibert

[GoogleRocks!]

Hi,

thanks for the feedback. Can you try it again with the attached version, please?

-alibert

Hi alibert... I apologize for not being able to get back to this until now.

Yes, this new compiled version did the trick and ran successfully.

Thank you for your attention on this.