epg working but empy "on now" (1 Viewer)

[gjstroom]

MediaPortal Version: 1.1.0.0RC6
MediaPortal Skin: Blue3Wide
Windows Version: Windows 7 X64
CPU Type: E6600
HDD: 2*250G raid0, 2*1T raid0, 80G SSD
Memory: 4GB
Motherboard: Asus P5B
Video Card: NVidia GT7600
Video Card Driver: Latest
Sound Card: Onboard
Sound Card AC3: Onboard
Sound Card Driver: Latest
1. TV Card: KNC-One
1. TV Card Type: DVB-C
1. TV Card Driver: 2.1.202.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: MS-DTV
MPEG2 Audio Codec: MS-DTV
h.264 Video Codec: MS-DTV
Satelite/CableTV Provider: Ziggo
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

Hi I use MediaPortal on my Windows PC with the MySQL on a Linux server, when using this setup everything works exept the On Now, that's displaying "Now: No data available". When I use the MySQL on my Windows pc it works fine.
I did some reinstalls and database drops, but still I get "Now: No data available".
For the database creation I used on the Linux server:
CREATE DATABASE MpTvDb_e6600;
GRANT ALL ON MpTvDb_e6600.* TO root@192.168.0.10 IDENTIFIED BY 'MediaPortal';
GRANT ALL ON mysql TO root@192.168.0.10 IDENTIFIED BY 'MediaPortal';

I Also use this MySQL server for another MediaPortal machine with it's own database, that also has the same problem.

# mysql -V
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0

 

[gjstroom]

Some additional logging with remote mysql database (no miniguide):

2010-07-21 19:58:08.093659 [Debug][MPMain(1)]: TvMiniGuide: All controls are reset after 0ms
2010-07-21 19:58:08.094659 [Debug][MPMain(1)]: TvMiniGuide: GetChannelListByGroup returning cached version of channels.
2010-07-21 19:58:08.115660 [Debug][MPMain(1)]: TvMiniGuide: FillChannelList retrieved 0 programs for 166 channels in 19 ms
2010-07-21 19:58:08.732696 [Debug][MPMain(1)]: TvMiniGuide: FillChannelList - 1 channel states for group retrieved in 616 ms
2010-07-21 19:58:08.746696 [Debug][MPMain(1)]: TvMiniGuide: State check + filling completed after 616 ms
2010-07-21 19:58:08.747696 [Debug][MPMain(1)]: TvMiniGuide: FillGroupList finished after 0 ms

with local mysql database:

2010-07-21 20:08:07.774764 [Debug][MPMain(1)]: TvMiniGuide: All controls are reset after 0ms
2010-07-21 20:08:07.807766 [Debug][MPMain(1)]: TvMiniGuide: GetChannelListByGroup caching channels from DB.
2010-07-21 20:08:08.131785 [Debug][MPMain(1)]: TvMiniGuide: FillChannelList retrieved 165 programs for 166 channels in 323 ms
2010-07-21 20:08:09.297851 [Debug][MPMain(1)]: TvMiniGuide: FillChannelList - 1 channel states for group retrieved in 1165 ms
2010-07-21 20:08:09.320853 [Debug][MPMain(1)]: TvMiniGuide: State check + filling completed after 1165 ms
2010-07-21 20:08:09.326853 [Debug][MPMain(1)]: TvMiniGuide: FillGroupList finished after 0 ms

form tv.log:
2010-07-21 20:35:43.111900 [MPMain(1)]: BusinessLayer: GetNowNext failed Table 'MpTvDb_e6600.program' doesn't exist

When I rename the table Program to program:
2010-07-21 20:57:36.974048 [MPMain(1)]: BusinessLayer: GetNowNext failed Unknown column 'Program.endtime' in 'where clause'

So there's a fault somewhere which addresses the program table in lowercase. On a Windows MySQL this doesn't matter, but a Linux MySQL is case sensitve.

 

[Razorblade]

Hi gjstroom,

I have the same problem here.
Did you ever resolve this issue?

I also have MP on a Windows box and MySQL is running on my Linux server.
My EPG is full but the "on now" windows says "no data avilable"

 

[gjstroom]

put the following line in your /etc/my.cnf
lower_case_table_names=1
It sets your mysql in case insensitve mode, you need to drop the casesensitve tables and let mediaportal recreate the database.

 

[Razorblade]

Thank you for that suggestion.
But I was looking for something less destructive.

I don't want to lose my recordings and my channel mappings.
And there are other databases that might be affected on my server.

EDIT:
I submitted this issue/bug.

There seems to be a fix for this issue in the upcoming version 1.1.1 of MP. (didn't know about that)