Import Database failure (1 Viewer)

[baffledboy]

I've just done a complete reinstall of XP & MP RC2. Traditionally all my TV recordings have been on a separate drive (F. I've setup MP to record TV shows on F: as usual, but now I can't seem to import any of the old recorded TV shows back into Mediaportal. When I go to the import database tab in TV Server setup, it allows me to choose F: but doesn't show any files. Any ideas?

TV-Server Version: MP1 RC2
MediaPortal Version: MP1 RC2
MediaPortal Skin: BlueTwo Wide
Windows Version: XP Pro SP3
CPU Type: AMD 3800
HDD: Samsung SP250 SATA
Memory: 512mb ddr
Motherboard: Asus P4P800s-x
Video Card: Nvidia Geforce 6200
Video Card Driver:
Sound Card:
Sound Card AC3: Coaxial out
Sound Card Driver:
1. TV Card: Hauppauge WinTV Nova -PCI
1. TV Card Type: DBV-T
1. TV Card Driver:
2. TV Card: Hauppauge WinTV Nova PCI
2. TV Card Type: DBV-T
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: Nvidia
MPEG2 Audio Codec: Nvidia
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case: Ahanix D.Vine 5
Cooling:
Power Supply:
Remote: MCE
TV: Samsung LCD 32"
TV - HTPC Connection: DVI-HDMI

 

[Jiv]

Someone on the forum has already mentioned that this is the case because the recordings are already listed in the table of the TV database. And to correct it you must manually delete the corresponding entry from the table in order for the Database Import function to see it (TV-Server Configuration -> Recording settings -> Database Import).

So, here are some SQL commands to do it:

; Assuming you're using Microsoft SQL Express.
C:\> sqlcmd -S localhost\SQLExpress

use MpTvDb
select idRecording, title from dbo.Recording
go

; Look for the title you want to re-import, then remember the corresponding idRecording number.
; Now, delete the entry.
delete from dbo.Recording where idRecording = <the number you got from previous command>
go

; if you have many entries you want to delete then you can try the command below.
; Replace the list of numbers inside the brackets with your own.
delete from dbo.Recording where idRecording in (134, 170, 234, 250, 300)
go

; Now, go to your TV-Server configuration and you should see a list of recordings to import.