Recorded TV display problem (1 Viewer)

[afidel]

TV-Server Version: 1.0.2.0
MediaPortal Version: 1.0.2.0

I recently had to rescan my channels and now all of my old Recorded TV shows don't appear and new ones that belong to an existing series show up as folder icons but the folders are empty. I looked at the MpTvDb and everything is still present in dbo.Recording but it's not displaying correctly in Recorded TV. I assume this is due to the old programs having an invalid idChannel record but I'm not quite sure how to fix it as I don't really understand the relationships between the tables.

Does anyone know how to fix this, or know where I can locate a database schema that explains the table relationships?

 

[afidel]

Ok went for broke and after taking a SQL backup did an UPDATE dbo.Recording SET idChannel=187 (smallest value in dbo.Channel table) where idChannel<187;
It updated 324 rows and now I have all my programs back!
So if playing with your tuners results in all your old recordings going away or your Recorded TV display being messed up that's the fix.