SetupTV: delete radio channel fails with exeption (1 Viewer)

[Olodin]

TV-Server Version: tvengine3-10-02-2007--01-22h--Rev16086
MediaPortal Version: Media Portal 0.2.3.0 RC2 with MediaPortal-svn--10-02-2007--01-02-Rev16086
MediaPortal Skin: ReVision
Windows Version: Windows XP Pro SP2 with latest patches
CPU Type: Celeron-M 350
HDD: Samsung SpinPoint T166 500GB (HD501LJ)
Memory: 2 x 512MB Infineon DDR
Motherboard: Asus P4P800 SE
Motherboard Chipset: Intel 865G
Motherboard Bios:
Video Card: nVIDIA GeForce FX 5200
Video Card Driver: 84.21
Sound Card: SoundMax AD1985 (onboard)
Sound Card AC3: coaxial out
Sound Card Driver: WDM 5150
1. TV Card: FireDTV Floppy DVB-S-CI
1. TV Card Type: DVB-S
1. TV Card Driver: 4.2.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: Nvidia Purevideo
MPEG2 Audio Codec: Nvidia Purevideo
Satelite/CableTV Provider: Astra
HTPC Case: Silverstone LC-10B
Cooling:
Power Supply: Coba 350W
Remote: Logitech Harmony 525
TV: Samsung LE-27T51B LCD
TV - HTPC Connection: Sub-D

Tested with tvengine3-10-02-2007--01-22h--Rev16086.zip:

-Open SetupTV.exe
-Go to Radio Channels
-Delete a DVB-S radio channel

Deleting a radio channel via SetupTV.exe has no success. Application continues running and writes in error log:

Gentle.Common.GentleException: delete from RadioChannelMap WHERE idChannel=473 ---> MySql.Data.MySqlClient.MySqlException: #42S02Table 'tvlibrary.radiochannelmap' doesn't exist

Maybe a problem with the database restructuring mentioned in [Announcement] TvPlugin -> MyRadio "Reloaded"?

Attached are the logs. Can someone confirm this?

Edit:
I failed to report in the right subforum, sorry. (Has anyone ever counted those? - Just did: found 99 subforums.):
It has been already reported in Problems with Radio stations in Config, but the attached log can confirm this problem.

 

[ronilse]

Hi,
This it's a TVE3 problem & should be posted there instead
I'll move it there.

Regards
Roy

 

[Olodin]

Hi,
This it's a TVE3 problem & should be posted there instead
I'll move it there.

Regards
Roy

Sorry, thought that there was only one subforum to report bugs.

Well, if I had found this subforum I would have seen the thread Problems with Radio stations in Config which reports exactly the same problem as I do, but there are no logs available.

So please merge threads or close one.

 

[jcm]

This problem is caused by TvDatabase.Channel.Delete() as it tries to delete a row in a table called RadioChannelMap which doesn't exist. The table is not created in the create or upgrade script or used anywhere else (at least not in SetupTv =)).

TVLibrary\TVDatabase\Channel.cs Line 595

 

[ASiDiE]

This has been added to the Mantis bug tracker.

Thanks

http://mantis.team-mediaportal.com/view.php?id=1120

 

[gemx]

Resolved in rev. 16171

 

[ASiDiE]

Just loaded on 16172 and am still getting this error.

http://pastebin.team-mediaportal.com/pastebin.php?show=13098

I created a brand new database... go into radio channels, add a channel and then try to delete it right away. Comes up with the pastebin.

 

[gemx]

Yep, you are right.
My mistake
Please try rev 16174

 

[ASiDiE]

That works... Thanks!

 

[Nemulate]

Excellent news! Thanks gemx!