Error TVServer 1.2 Beta (1 Viewer)

[cartucho]

MediaPortal Version: 1.2 Beta
MediaPortal Skin: StreamedMP
Windows Version: W7 SP1
CPU Type: Athlon II X2 240e 2.8Ghz
HDD: 2Tb WD Caviar green
Memory: 2GB
Motherboard: Gygabite
Video Card: ATI Radeon HD 4250
Video Card Driver: Ati 8.821
Sound Card: Realtek
Sound Card AC3:
Sound Card Driver:
1. TV Card: BlackGold
1. TV Card Type: DVB-S2/DVB-T
1. TV Card Driver:
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:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

Hi,
I post here because I don't have permisson to post on the development forum.

On TVServer Configuration, when I try to do "Test Channels" o "Manual Control" appears an "unknown error" message.
On the err.lof I have seen this line:

Gentle.Common.GentleException: select cm.* from channelmap cm where cm.idChannel =223 and cm.idCard=5 and cm.epgOnly=0 ---> MySql.Data.MySqlClient.MySqlException: Table 'MpTvDb.channelmap' doesn't exist
en MySql.Data.MySqlClient.MySqlStream.OpenPacket()
en MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
...

I use a MySQL 5.1.49 DB on Linux, and the table name is "ChannelMap". In linux mysql is case sensitive, so if I change the name to lowercase the error disappears, but the "Channels" tab of the "TV Channels" option doesn't load the channels.

The TV Server works fine, I can see the TV on the client.

Ander

 

[mm1352000]

Hi Ander

Thanks for reporting
Can you please post the full error.log and tv.log?

mm

 

[Vasilich]

Ander,
this was fixed long ago:

Revision: 27856
Author: blackbird99
Date: 04.05.2011 11:13:11
Message:
Mantis 3508
Case sensitive installations of mySql cannot select channel.
-------------------------------
M : /trunk/TvEngine3/TVLibrary/TVDatabase/TvBusinessLayer/BusinessLayer.cs

so i guess you 'd better upgrade to new MP 1.2RC1 and report back if you still have that issue.

 

[mm1352000]

Hi again Ander

Now that I've had the chance to search the code properly I concur with Vasilich - the issue was present in MP 1.2.0b, but it was fixed for MP 1.2.0rc.

mm

 

[cartucho]

Hi,

Already there is another version? I finished the new installation the past weekend .
I will install the RC and I will post if it works fine.

Thanks