Delete Recorded TV Problem (1 Viewer)

[talltobes]

Hi All,

Just wondering if anyone has come across this problem.

When I have viewed my recorded TV show, I then use the menus to delete that program. This has been working fine since in setup my MP PC.

But this morning when I went to delete the TV show - the TV show remains in the list of recorded Programs, but has been deleted from the file system.

I have just looked at the logs and these errors are generated.

2006-10-20 07:30:27.781250 [Info.][MPMain]: WindowManager:route MediaPortal.GUI.TV.GUIRecordedTV:603->MediaPortal.Dialogs.GUIDialogMenu:2012
2006-10-20 07:30:27.781250 [Info.][MPMain]: window:MediaPortal.Dialogs.GUIDialogMenu init
2006-10-20 07:30:29.875000 [Info.][MPMain]: WindowManager:unroute to MediaPortal.Dialogs.GUIDialogMenu:2012->MediaPortal.GUI.TV.GUIRecordedTV:603
2006-10-20 07:30:29.921875 [Info.][MPMain]: WindowManager:route MediaPortal.GUI.TV.GUIRecordedTV:603->MediaPortal.Dialogs.GUIDialogYesNo:100
2006-10-20 07:30:29.937500 [Info.][MPMain]: window:MediaPortal.Dialogs.GUIDialogYesNo init
2006-10-20 07:30:31.953125 [Info.][MPMain]: WindowManager:unroute to MediaPortal.Dialogs.GUIDialogYesNo:100->MediaPortal.GUI.TV.GUIRecordedTV:603
2006-10-20 07:30:32.015625 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:delete from recorded where idRecorded=9
2006-10-20 07:30:32.031250 [Info.][MPMain]: TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:delete from recorded where idRecorded=9 stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.RemoveRecordedTV(TVRecorded record)
2006-10-20 07:30:32.031250 [Info.][MPMain]: opening tvdatabase
2006-10-20 07:30:32.046875 [Info.][MPMain]: tvdatabase opened
2006-10-20 07:30:41.312500 [Info.][MPMain]: WindowManager:route MediaPortal.GUI.TV.GUIRecordedTV:603->MediaPortal.Dialogs.GUIDialogMenu:2012
2006-10-20 07:30:41.312500 [Info.][MPMain]: window:MediaPortal.Dialogs.GUIDialogMenu init
2006-10-20 07:30:43.250000 [Info.][MPMain]: WindowManager:unroute to MediaPortal.Dialogs.GUIDialogMenu:2012->MediaPortal.GUI.TV.GUIRecordedTV:603
2006-10-20 07:30:43.296875 [Info.][MPMain]: WindowManager:route MediaPortal.GUI.TV.GUIRecordedTV:603->MediaPortal.Dialogs.GUIDialogYesNo:100
2006-10-20 07:30:43.312500 [Info.][MPMain]: window:MediaPortal.Dialogs.GUIDialogYesNo init
2006-10-20 07:30:45.234375 [Info.][MPMain]: WindowManager:unroute to MediaPortal.Dialogs.GUIDialogYesNo:100->MediaPortal.GUI.TV.GUIRecordedTV:603
2006-10-20 07:30:45.281250 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:delete from recorded where idRecorded=10
2006-10-20 07:30:45.281250 [Info.][MPMain]: TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:delete from recorded where idRecorded=10 stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.RemoveRecordedTV(TVRecorded record)

I even shut down MP, restarted and try to delete another TV show with the same problem.

Any help would be appreciated. I am happy to edit the TV database file, but would like to know what caused this in the first place.

Cheers

Tobby

 

[rich110]

*bump*

This problem has just started to happen to my system. I delete the recordings in the RecordedTV section, and even though they are actually deleted from the hardrive, they shows still remain in the RecordedTV list.

I've tried rebooting the machine, but no joy. Any ideas?

Cheers
Rich

 

[gemx]

Do you use TVEngine3 or just MediaPortal?

 

[NickName]

Go into MP setup and try emptying the database through the TV guide section. This will delete your TV guide data only. This may (?) fix it.
This fixes my TV guide issues and 'yes' I know you are talking about Recorded TV but it's worth a try as it's the same database... It may fix any corruptions you have in there.
For what it's worth, I have the opposite of you. I delete recordings and they appear deleted in MP until I actually check the Recorded TV folder through explorer and some (butu not all) are still there. It's not a big issue for me so I just live with it.

Cheers,

Nick Name.

 

[rich110]

gemx - I use the regular MP TV engine (v.2) currently running SVN 14506.

NickName Thanks for the suggestion, I'll give it a try. I realise that it's not a very big deal, but if this continues my RecordedTV list will end up being half populated by tv shows that no longer exist and browsing will become a nightmare.

Thanks again.