TV Recordings missing from DB, but still on HDD (1 Viewer)

[moviebuff03]

I took the step at adding my old recordings to the recordings table in MS SQL, despite knowing very little about db programming.
I am happy to say that all the info is still there, however, when I now go to Recorded TV in MP, ALL the previous entries (old and new db) have disappeared, despite still being on the HDD.

The error being shown on access is:
2007-12-17 14:59:39.595091 [ERROR][MPMain]: OnMessage exceptionystem.ArgumentException: Illegal characters in path.
at System.IO.Path.CheckInvalidPathChars(String path)
at System.IO.Path.ChangeExtension(String path, String extension)
at TvPlugin.TvRecorded.LoadDirectory()
at TvPlugin.TvRecorded.OnPageLoad()
at MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)

How can I correct this? What are the illegal characters???

Please help, as this is driving me nuts since the db upgrade!
Cheers
Darren

 

[level20peon]

I am happy to say that all the info is still there, however, when I now go to Recorded TV in MP, ALL the previous entries (old and new db) have disappeared, despite still being on the HDD.

This doesn't make sense, either the info is there or not. Where is it present, if not in the "recorded TV section" ?

How can I correct this? What are the illegal characters???

Nobody can tell you because we don't know what you entered into your database.


-level20peon

 

[moviebuff03]

ALL the recordings (old dvr.ms and new .ts) are in the recordings table of my SQL database, they just don't show within MP 'Recorded TV' menu. Prior to updating the table, the .ts files were listed in MP. Recordings since updating SQL are not shown.

I ask about the path/invalid characters as I am unsure whether MP is looking at the recording.dbo table within tvlibrary (SQL) correctly.

I have re-started the pc/sql/tv service, but still the same results.

 

[level20peon]

Well you obviously did not enter the information correctly into the table. Again, we cannot see WHAT you entered so you should provide a sample.


-level20peon

 

[Marcusb]

I think your best bet is to go through all the data you entered and look for any characters that are not standard text. For example &,*, etc as well as \ and any others.
I'm not sure which ones are illegal and a goolge didn't help much, but this would be the best place to start.

It seems pretty certain that something has snuck in and is causing the reading of this table to fail.

For the future, you should back up that table before modifying it, just in case. Simply right click and choose backup

 

[moviebuff03]

Thanks - for now I have re-installed MS SQL and at least new recordings are being shown in both SQL and MP - Recorded TV. I have backed up just in case and should have known better!!!!!

I intend to look at the 'old' dumped data, before I think about re-entering it into the new SQL...How tedious compared with the old db.