EPG Empty and update

[nv40]

I have been having issues with GBPVR recording things an hour early since the daylight savings time switchover. After searching on here....i patched my xp rig, but i'm trying to empty the EPG data, but nothing happens. I have 2 pvr-150 cards....does that matter. I hit empty under both...but when i pull up gbpvr, there' still guide data??

[sub]

You should be able to hit empty EPG on each of your capture sources, then start GB-PVR and view the TV Guide.

Dont leave GB-PVR running while you do this though, since it caches the data.

[nv40]

You should be able to hit empty EPG on each of your capture sources, then start GB-PVR and view the TV Guide.

Dont leave GB-PVR running while you do this though, since it caches the data.

Well....I got further this way....I have no pending recordings listed now, but i still have tv guide data.

[pastro]

Well....I got further this way....I have no pending recordings listed now, but i still have tv guide data.

If you quit GBPVR and empty both from the config app and reload from the tray application, it seems to fix everyone's problem. If the guide is still an hour early, the patch probably isn't right.

If you are using winxp you can check if the patch worked by double clicking on the date/time and on the main page at the bottom it lists the current timezone.

[sub]

Do you still have full listings?

Do the 'empty epg' on each capture source then post your config.exe.log and I'll take a look.

[nv40]

Do you still have full listings?

Do the 'empty epg' on each capture source then post your config.exe.log and I'll take a look.

wasn't sure what log to give ya.

[sub]

3/14/2007 10:14:19 PM.312 ERROR [1] Error int emptyEPG(captureSource): SQLite error
no such table: REMINDER
3/14/2007 10:14:19 PM.328 ERROR [1] Stack:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.xbdfb880686f2538b.x6b08755638c97238(xda34526142ca690b

Its not deleting because you've got an error in your database.

It looks like you've got a database from a previous release copied onto a v0.99.12 release.

[nv40]

Its not deleting because you've got an error in your database.

It looks like you've got a database from a previous release copied onto a v0.99.12 release.

hmmm....this is a pretty fresh install. Wonder what happened. well, is there a way for me to fix this?

[sub]

The easiest way to fix it is copy empty.db3 over gbpvr.db3, but this will start you from an empty database.

Otherwise, you'd need to download a SQLite tool, like SQLite Spy, and execute the following statements:

Code:

create table REMINDER (programme_oid int)
alter table RECORDING_SCHEDULE add column priority int
alter table RECORDING_SCHEDULE add column conversion_profile VARCHAR(50)
update RECORDING_SCHEDULE set priority = oid where recording_type > 0
alter table CAPTURE_SOURCE add column allocation_order int
update CAPTURE_SOURCE set allocation_order=oid
create table PREVIOUS_EPISODE (recording_group int, unique_identifier VARCHAR(50), create_date DATETIME)
create table YOUTUBE_VIDEO (filename VARCHAR(255), youtube_identifier VARCHAR(50), title VARCHAR(255), description VARCHAR(255), author VARCHAR(50), thumbnail_url VARCHAR(255),  create_date DATETIME, keep char(1))

[nv40]

Thanks sub...i ran the code. Nothing different appeared to happen in config ( i expected to see all the channels disappear when i hit empt epg, but they didn't. However, when i loaded up gbpvr, the tv guide was indeed empty. Should i be concerned about anything else since my database seems to have something strange going on with it?