Recordings not showing in "Recorded TV" screen (1 Viewer)

[doveman]

Recordings are being made OK, but for some reason nothing shows up in the Recorded TV screen. I first noticed this using my chosen skin Purevision HD v2.2 but I've now tested with the non-HD Purevision and Blue3 and Blue3wide and it's the same in all of them.

Everything else in MP seems to be working fine. I just installed For The Record, but the problem was present already, so it's nothing to do with that. Can't think of anything else to add that might help but please let me know if you need me to do anything to help track down the cause of this problem.

TV-Server Version: v1.0.0.21720
MediaPortal Version: v1.0.0.21720
MediaPortal Skin: PureVision HD
Windows Version: XP Pro SP3
CPU Type: Intel P4 2.8Ghz Northwood (non-HT)
HDD: 1*500GB and 1*640GB Western Digital SATA
Memory: 1.5GB DDR
Motherboard: Gigabyte 8i848-PM
Video Card: Leadtek FX5600 256MB VIVO
Video Card Driver: 93.71
Sound Card: onboard Realtek AC97 (ALC655)
Sound Card AC3: no AC3
Sound Card Driver: 5.10.0.6300
1. TV Card: Hauppauge Nova-T 500
1. TV Card Type: DVB-T
1. TV Card Driver: 4.3.25080.0
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: MPC (Gabest)
MPEG2 Audio Codec: MPC
h.264 Video Codec: ffdshow
Satelite/CableTV Provider:
HTPC Case: Custom
Cooling: Nexus 120mm Intake Fan, Accelero S2, Mini Ninja
Power Supply: FSP 300W
Remote: Nova-T 500
TV: Sony XBR800 36"
TV - HTPC Connection: DVI

 

[Paranoid Delusion]

For The Record - View topic - Binaries for MediaPortal 1.0 SVN 21720 (and 21688)

Have you got the relevant files from above post.

 

[doveman]

Yes thanks, I installed those straight after installing FTR.

Well I uninstalled FTR and recordings are being shown now. As I said, the problem was present before I installed FTR but I also upgraded with the latest MP SVN after I installed FTR and I'm using the PureVision HDX skin now as well but I've tested and it's working in Purevision HD v2.2 as well, so I don't know what fixed it but something has!

 

[doveman]

hmm, I've come up against the same problem again.

I haven't re-installed FTR but I have upgraded to SVN 21813. It seems to only show recordings made with this SVN.
It might be a bug with this SVN, but I wanted to check that there isn't another explanation before reporting it as such.

For my old recordings, Mediaportal.log shows:

---
2009-03-04 23:16:31.328125 [Warn.][MPMain]: TVRecorded: Error building item from recording D:\TVRecord\Hunter S Thompson_ The Final 24 - SKY THREE - 2009-02-17.ts
Error: UnexpectedRowCountUnclassified
Gentle.Common.GentleException: The number of returned rows 0 did not match the expected count of 1.
If concurrency control is enabled this may indicate that the record was updated or deleted by another process.
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Common.Check.Verify(Boolean condition, Error error, Object[] args)
at Gentle.Framework.ObjectFactory.GetInstance(Type type, SqlResult sr, Key key)
at Gentle.Framework.PersistenceBroker.RetrieveInstance(Type type, Key key, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.RetrieveInstance[T](Key key)
at Gentle.Framework.Broker.RetrieveInstance[T](Key key)
at TvDatabase.Channel.Retrieve(Int32 id)
at TvDatabase.Recording.ReferencedChannel()
at TvPlugin.TvRecorded.BuildItemFromRecording(Recording aRecording)
2009-03-04 23:16:31.328125 [Warn.][MPMain]: TVRecorded: Error building item from recording D:\TVRecord\Iran and Britain - BBC FOUR - 2009-02-14.ts
Error: UnexpectedRowCountUnclassified
Gentle.Common.GentleException: The number of returned rows 0 did not match the expected count of 1.
If concurrency control is enabled this may indicate that the record was updated or deleted by another process.
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Common.Check.Verify(Boolean condition, Error error, Object[] args)
at Gentle.Framework.ObjectFactory.GetInstance(Type type, SqlResult sr, Key key)
at Gentle.Framework.PersistenceBroker.RetrieveInstance(Type type, Key key, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.RetrieveInstance[T](Key key)
at Gentle.Framework.Broker.RetrieveInstance[T](Key key)
at TvDatabase.Channel.Retrieve(Int32 id)
at TvDatabase.Recording.ReferencedChannel()
at TvPlugin.TvRecorded.BuildItemFromRecording(Recording aRecording)
---

and so on. It also shows entries for files that I've deleted from the recording folder, so I don't know why it's trying to build items for those, or even where it's getting those filenames from!

---
2009-03-04 23:16:31.343750 [Warn.][MPMain]: TVRecorded: Error building item from recording D:\TV-MP-Record\UEFA Champions League_ Inter... - ITV1 - 2009-02-24.ts
Error: UnexpectedRowCountUnclassified
Gentle.Common.GentleException: The number of returned rows 0 did not match the expected count of 1.
If concurrency control is enabled this may indicate that the record was updated or deleted by another process.
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Common.Check.Verify(Boolean condition, Error error, Object[] args)
at Gentle.Framework.ObjectFactory.GetInstance(Type type, SqlResult sr, Key key)
at Gentle.Framework.PersistenceBroker.RetrieveInstance(Type type, Key key, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.RetrieveInstance[T](Key key)
at Gentle.Framework.Broker.RetrieveInstance[T](Key key)
at TvDatabase.Channel.Retrieve(Int32 id)
at TvDatabase.Recording.ReferencedChannel()
at TvPlugin.TvRecorded.BuildItemFromRecording(Recording aRecording)
---

However, it does create thumbs for most of my recordings (including most of those for which the log shows "Error building item") in C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\Thumbs\TV\Recorded

For some though, it has a problem even doing that, and again is trying to do so for recordings which I've deleted

2009-03-04 23:16:31.921875 [Info.][PoolThread19]: RecordedTV: No thumbnail created for Hunter S Thompson_ The Final 24 - SKY THREE - 2009-02-17.ts
2009-03-04 23:16:32.593750 [Info.][PoolThread19]: RecordedTV: No thumbnail created for Iran and Britain - BBC FOUR - 2009-02-14.ts
2009-03-04 23:16:33.265625 [Info.][PoolThread19]: RecordedTV: No thumbnail created for UEFA Champions League_ Inter... - ITV1 - 2009-02-24.ts

I saw another thread https://forum.team-mediaportal.com/...-support-53/my-tv-recorded-tv-database-54708/ where someone got their Recordings to show up by switching to blue3wide skin, but I've tried that and it didn't work and the same errors show up in the log. Nothing's showing up in the "Recorded files which are currently not present in your database:" box in TV Server config.

 

[rtv]

- Open SQL Server Management Studio
- Open a new query on your MpTvDb
- Execute this command "delete from recording"
- Open SetupTv.exe
- Reimport your recordings
- For greyed items: wait for some feature I still have to implement or edit the xml file so it contains a channel which is present in your DB.

 

[doveman]

rtv.
I didn't have SQL Server Management Studio but I downloaded the Express version and it's done the job. Imported everthing that was in my recordings folder and no greyed items left over.

Did I do something stupid that caused this problem or is there something I should be aware of to try and avoid it happening in future?

 

[rtv]

Did I do something stupid that caused this problem or is there something I should be aware of to try and avoid it happening in future?

I am not sure about that. Somehow your recording DB had references to non existing channels. This could be:
- deleting a channel after you already had recorded from it (although that case should have been handled)
- an external plugin (4TR, some webinterface, etc) directly manipulating the DB / recordings / channels
- an issue related to changes that allow "channel merging" for those stupid broadcasters in the USA.

Just bump this thread if it happens again, please.

 

[doveman]

Will do, thanks.

In this case, I suspect it was something to do with 4TR as I had been messing about with that.

If it's not stupidly complicated to do, is it worth considering integrating the "delete from recording" command in MP config to make it a bit easier to use when necessary, or does this problem occur too rarely to justify that?

 

[wouter1971]

Had the same issue too...same error messages. rtv's solution is correct. SQL management studio did the trick. The relation channels, which i cleared and recordings gives a mismatch i think. Would be nice if you could delete the recordings table from inside mediaportal. Is that possible rtv? I got all the errors at the moment i first installed mediaportal and imported all the channels. For a less experienced mp user this could be someting to turn away from mediaportal.

 

[gumbyk]

Hi, I've got the same problem, but using the solution that RTV gave isn't working for me.
I'm runnning MP 1.0.2.0.

Ive tried moving the recordings to a different folder, and updating the database in mediaportal, then moving them back, and updating the database as well.

Still no joy.

Any other ideas?