Already posted this under general, but I believe it's a bug.
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".
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
from 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.
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".
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
from 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.