NextPVR Forums - TV Guide empty in EWA, fine in PVRX2.exe

When I try to look at the TV Guide in EWA, it is empty. There are no shows or channels listed, although the TV Guide tab is there. Here is a screenshot:
[ATTACHMENT NOT FOUND]
The statistics tab shows "EPG Remaining:Unable To Determine Amount Of Guide Data Left". Here is the log file, from the link on the statistics page:

Code:
2008-10-23 21:19:08.186    VERBOSE    [4]    installDirectory is C:\Program Files\Devnz\GBPVR\

2008-10-23 21:19:08.186    VERBOSE    [4]    configurationFile is config.xml

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/DatabaseConnectionString

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/DatabaseConnectionString : Data Source=".\gbpvr.db3";Version=3;New=True;

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/DatabaseIdentityQuery

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/DatabaseIdentityQuery : select last_insert_rowid()

2008-10-23 21:19:08.233    VERBOSE    [4]    databaseConnectionString is Data Source="C:\Program Files\Devnz\GBPVR\gbpvr.db3";Version=3;New=True;

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/DatabaseProviderFactory

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/DatabaseProviderFactory : System.Data.SQLite.SQLiteFactory

2008-10-23 21:19:08.233    VERBOSE    [4]    ...using System.Data.SQLite.SQLiteFactory DB Provider Factory

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/LoggingLevel

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/LoggingLevel : Debug

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/LoggingForceFlush

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/LoggingForceFlush : true

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/LoggingMaxSize

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/LoggingMaxSize : 1000000

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/LogSQL

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/LogSQL : false

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/AntiAlias

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/AntiAlias : true

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/EPGProcessingMode

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/EPGProcessingMode : normal

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/TvShape

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/TvShape : 16x9

2008-10-23 21:19:08.233    VERBOSE    [4]    User is running Windows version newer than XP (maybe Vista?)

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/WebServerNMTStreamingEnabled

2008-10-23 21:19:08.233    VERBOSE    [4]    getValue: /settings/WebServerNMTStreamingEnabled : true

2008-10-23 21:19:08.279    VERBOSE    [4]    RecorderHelperConfig: LoadFromFile()

2008-10-23 21:19:10.963    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/PluginsEnabled

2008-10-23 21:19:10.963    VERBOSE    [4]    getValue: /settings/PluginsEnabled : true

2008-10-23 21:19:10.963    INFO    [4]    loadOldStylePlugins()...

2008-10-23 21:19:10.963    VERBOSE    [4]    creating DirectRecordingSource

2008-10-23 21:19:10.963    VERBOSE    [4]    Loading DirectRecordingSource Configuration : 1

2008-10-23 21:19:10.978    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/PreferAlternatingCaptureSources

2008-10-23 21:19:10.978    VERBOSE    [4]    getValue: /settings/PreferAlternatingCaptureSources : false

2008-10-23 21:19:10.978    VERBOSE    [4]    About to connect to remote recording service

2008-10-23 21:19:10.978    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/RecordingServiceLocation

2008-10-23 21:19:10.978    VERBOSE    [4]    getValue: /settings/RecordingServiceLocation : tcp://127.0.0.1:7968/RecordingRemote

2008-10-23 21:19:10.994    VERBOSE    [4]    RecordingFactory.loadSchedule()

2008-10-23 21:19:10.994    VERBOSE    [4]    getValue() loading new key/value into cache: /settings/AutoRemoveMissingRecordings

2008-10-23 21:19:10.994    VERBOSE    [4]    getValue: /settings/AutoRemoveMissingRecordings : true

2008-10-23 21:19:10.994    VERBOSE    [4]    Purging any stale logically deleted recordings

2008-10-23 21:19:17.281    VERBOSE    [4]    RecordingFactory.loadSchedule()

2008-10-23 21:19:17.281    VERBOSE    [4]    getValue cached value: /settings/AutoRemoveMissingRecordings : true

2008-10-23 21:19:30.494    VERBOSE    [14]    RecordingFactory.loadSchedule()

2008-10-23 21:19:30.494    VERBOSE    [14]    getValue cached value: /settings/AutoRemoveMissingRecordings : true

2008-10-23 21:22:00.425    VERBOSE    [4]    RecordingFactory.loadSchedule()

2008-10-23 21:22:00.425    VERBOSE    [4]    getValue cached value: /settings/AutoRemoveMissingRecordings : true

2008-10-23 21:22:28.521    INFO    [4]    Using wmi for free space determination.....

2008-10-23 21:22:29.129    INFO    [4]    Using wmi for free space determination.....

2008-10-23 21:22:29.145    VERBOSE    [4]    RecordingFactory.loadSchedule()

2008-10-23 21:22:29.145    VERBOSE    [4]    getValue cached value: /settings/AutoRemoveMissingRecordings : true

2008-10-23 21:22:29.207    ERROR    [4]    System.InvalidCastException: Specified cast is not valid.

   at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)

   at System.Data.SQLite.SQLiteDataReader.GetDateTime(Int32 i)

   at gbweb.Migrated_Info.GetEPGRemaining(DbConnection aConnection) in c:\Program Files\Devnz\GBPVR\web\Info.aspx.cs:line 350

   at gbweb.Migrated_Info.Page_Load(Object sender, EventArgs e) in c:\Program Files\Devnz\GBPVR\web\Info.aspx.cs:line 82

I reinstalled EWA v77, from a zip just downloaded from the wiki, but it didn't help.

The problem started shortly after I started using the SchedulesDirect Utilities, but I don't know if that has anything to do with it.

I am using GB-PVRv1.2.13, on Vista Home Premium 32bit. I usually use FF 3.0.3, but I tried it with IE 7.0.6001.18000, and the guide is empty with that, too.

Are you using Access as you Database or SQLite?

UncleJohnsBand Wrote:Are you using Access as you Database or SQLite?

I don't know, how do I tell?

4zm4r3d02 Wrote:I don't know, how do I tell?

Run this program that is in the gbpvr directory....it will let you switch to the SQLite database from Access.

ChangeDatabase.exe

I ran the ChangeDatabase program, and it said there's no gbpvr.mdb file. But there is a gbpvr.db3 file, so I guess I'm already using sqlite?

I don't know if this is related, but the guide on my mvp, which I just started using again after getting a new pc with Vista, is also empty.

It sounds to me like you've somehow installed an old patch meant for a previous version, or something similiar.

Do you get any epg in the PVRX2? Try it, then zip and attach the PVRX2.exe.log.

sub Wrote:It sounds to me like you've somehow installed an old patch meant for a previous version, or something similiar.

Do you get any epg in the PVRX2? Try it, then zip and attach the PVRX2.exe.log.

Yes, guide has info in PVRX2. Log attached, with zipcode hashed (#####) out.

I don't know if this has anything to do with this issue, but as an experiment I ran pvrx2.exe as an administrator and the guide showed "no show details" instead of program info. It returned to normal when I unchecked "run as administrator".

Looking at the files in the gbpvr folder, and in the web\bin folder, some are "owned" by SYSTEM, some by Administrators, and some by my user name. Is this normal?