miniGuide/EPG no data (1 Viewer)

[MrAlan]

TV-Server Version: 1.0 RC3
MediaPortal Version: 1.0 RC3
MediaPortal Skin: XFace 1.6
Windows Version: WindowsXP SP3
CPU Type: Intel Q6600 2.4GHz
HDD: Samsung 640GB
Memory: 2GB DDR2 800
Motherboard: Gigabyte GA-EG45M-DS2H
Video Card: Onboard
Video Card Driver:
Sound Card: Onboard
Sound Card AC3: Optical Out
Sound Card Driver:
1. TV Card: Hauppauge Nova-T 500
1. TV Card Type: DVB-T
1. TV Card Driver:
2. TV Card: Hauppauge Nova-S Plus
2. TV Card Type: DVB-S
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: PowerDVD8
MPEG2 Audio Codec: AC3Filter
h.264 Video Codec: PowerDVD8
Satelite/CableTV Provider: Optus D1
HTPC Case: Antec Fusion
Cooling:
Power Supply:
Remote: Microsoft MCE Remote
TV: Sony Bravia
TV - HTPC Connection: Sub-D


I've managed to get my RC3 successfully installed and working but I am still having a problem with the mini EPG it reports there is no data available despite the fact that the TV guide is working flawlessly. I had this problem with RC2 as well. I've attached logs but can't seem to find anything in them regarding the miniEPG.

It's showing the 'next' show information incorrectly as it's showing what is going to be on in 21 hours from now. The 'now' info reports No data available.

If I press 'Y' on a channel it brings up the correct show information and tells me the accurate next show data. So why does the mini EPG act so differently from the rest of the mediaportal?

Fixed: Seems my remote linux server had some time sync issues. Maybe the mini guide could be updated to use it's local time and not the time of a remote computer.

 

[Pirppuli]

Fixed: Seems my remote linux server had some time sync issues. Maybe the mini guide could be updated to use it's local time and not the time of a remote computer.

This was the newest report of the issue I seem to be having with MP version 1.0.2.0, as well. How did you change the time settings? I'm using MySQL (5.1.something, I believe; will check later, in necessary) on a QNAP TS-439 NAS. I have the device set to the correct time zone and it synchronises automatically with my ISP's NTP server. Full EPG works fine but all channels show "No data available" in the miniguide.

 

[Pirppuli]

I think I have found the problem. I turned on MySQL query logging to see what's happening. The query MP used to populate the Miniguide was:

(SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=1 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=2 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=8 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=9 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=3 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=10 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=4 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=21 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=14 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=16 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=12 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=28 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=25 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=40 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=29 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=24 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=35 AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  (SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel=18 AND (Program.endtime >= NOW()) order by starttime limit 2)

Trying to run this directly on the server produced the following error:

#1146 - Table 'MpTvDb.program' doesn't exist

Replacing "program" with "Program" enables the query to work, as all table names in the DB are actually mixed case. Looking at BusinessLayer.cs there are several places where the table name is incorrectly lowercase:

Line 1815:

completeStatement = "SELECT * FROM program WHERE 0=1";

Line 1825:

"(SELECT idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel={0} AND (Program.endtime >= NOW()) order by starttime limit 2)  UNION  ",

Line 1835:

//  sbSelect.AppendFormat("(SELECT TOP 2 idChannel,idProgram,starttime,endtime,title FROM program WHERE idChannel={0} AND (Program.endtime >= getdate()))  UNION ALL  ", ch.IdChannel);

Maybe a dev could take a look at this?

 

[Pirppuli]

I managed to implement a workaround by following this guide:

MySQL :: MySQL 5.1 Reference Manual :: 8.2.2 Identifier Case Sensitivity

First, I manually converted all database and table names to lowercase. Then I added the following statement into the my.cnf configuration file:

lower_case_table_names=1

This workaround may be too much trouble if you're already running other databases on the same Linux/Unix server.

 

[chschs]

AW: miniGuide/EPG no data

I managed to implement a workaround by following this guide:

MySQL :: MySQL 5.1 Reference Manual :: 8.2.2 Identifier Case Sensitivity

First, I manually converted all database and table names to lowercase. Then I added the following statement into the my.cnf configuration file:

lower_case_table_names=1

This workaround may be too much trouble if you're already running other databases on the same Linux/Unix server.

Thanks for the good analysis.
What is not clear for me:

1) I have the same problem since I installed RC3 and/or ForTheRecord 1.5. Does that mean this is still not fixed?
(of course MySQL is causing here a problem)

2) How or where would I put the variable lower_case_table_names=1.
I can't find the file if it is really my.cnf.
Please give some hints.

Thanks.

 

[chschs]

AW: miniGuide/EPG no data

Well my problem has looked alike, but complete different reason (I think).
I just installed FTR 1.5 which causes a identical symptom.

Solved with new TVPlugin.dll from FTR.