RC3 database update problem (2 Viewers)

[blaudden]

SQL is a standard. Just because MySQL can be configured not to follow it, I don't think every such case should be handled.

It would be possible to have a check for this (maybe in the setup tool) that kindly informs the user about the detected problem.


In your case, you could setup a MySQL Proxy on your machine that converts all incoming SQL to lowercase(or uppercase) before it's executed against you MySQL Server on linux. The lua script to do that would be trivial.

/ Magnus

 

[EgoManiac]

if it is possible to get the SQL command fixed for the mini-EPG (I believe it is the case issue as well, as others have mentioned) that would be great

 

[Pacif13r]

SQL is a standard. Just because MySQL can be configured not to follow it, I don't think every such case should be handled. <snip>

/ Magnus

Does ANSI/ISO SQL define case insensitivity as part of the standard?

 

[noonereallycares]

Does ANSI/ISO SQL define case insensitivity as part of the standard?

SShhhhhh!!!!

You're using logic. Stop it!!!!!

Clearly MySQL support is not high on the list of priorities. It is a shame that something as simple as a change in naming convention can render the program unusable.

What surprises me is that none of the members of the development team are running a Linux-based MySQL install.

 

[frys_assassi]

I hardly believe that expecting people to change their SQL server setup is considered an acceptable requirement for installation.

using an external SQL-Server running on Linux can not be considered to be a common usecase.

but we will look into it. allready sent a pm to the developers.

For me its also the use case, so please get this issue fixed for the final release.
I don't want to re-configure my database, to get the RC3 running.
Also, it would be clean programming if the casing of the names is consistently

Edith: Just fixed the issue by executing the statements manually. But it seems that I can't import an existing record (from the record-folder) into the TvServer. Dunno if this issue has something to do with the case-sensitive problem - it doesn't matter that much. I'm waiting eagerly für 1.0.0.0

 

[noonereallycares]

Edith: Just fixed the issue by executing the statements manually. But it seems that I can't import an existing record (from the record-folder) into the TvServer. Dunno if this issue has something to do with the case-sensitive problem - it doesn't matter that much. I'm waiting eagerly für 1.0.0.0

I copied my RC2 settings and database back into RC3. This appeared to retain all important information.

I did have problems with TV tuning until I rescanned on each tuner.

The only remaining issue that I can notice is one that seems to stop me from suspending,

 

[MrAlan]

Well I've reconfigured my database so it's now case insensitive. Everything is working fine except for the mini EPG issue. It says no data available for the current show and the next show is listed but is 21 hours ahead of where it should be.

 

[rtv]

Well I've reconfigured my database so it's now case insensitive. Everything is working fine except for the mini EPG issue. It says no data available for the current show and the next show is listed but is 21 hours ahead of where it should be.

Most likely it's another date then.

 

[MrAlan]

Well I've reconfigured my database so it's now case insensitive. Everything is working fine except for the mini EPG issue. It says no data available for the current show and the next show is listed but is 21 hours ahead of where it should be.

Most likely it's another date then.

How would I go about changing that?
My TV Guide shows the correct time and show information. Pressing 'Y' when watching TV will show the correct description of the currently playing program and the correct info for the next show. The only aspect of the guide that isn't functioning correctly is the mini guide.

I'm struggling to find any information/documentation regarding the mini guide.

Update* Seems my linux server was configured with the wrong date. Now the mini guide is working perfectly. Still confused as to why the mini guide is using my remote servers time rather than the local time?

 

[god_md5]

i have a error with the edit server ,and rc3 client

epg.log
2008-10-20 15:17:59.515985 [EPG Update thread]: -> 10/20/2008 3:00:00 PM-10/20/2008 3:50:00 PM 無間音樂
2008-10-20 15:17:59.516985 [EPG Update thread]: -> 10/20/2008 3:50:00 PM-10/20/2008 4:00:00 PM 金曲挑戰站
2008-10-20 15:17:59.516985 [EPG Update thread]: -> 10/20/2008 4:00:00 PM-10/20/2008 4:50:00 PM 冒險王
2008-10-20 15:17:59.517985 [EPG Update thread]: -> 10/20/2008 4:50:00 PM-10/20/2008 5:45:00 PM 微笑PASTA
2008-10-20 15:17:59.518985 [EPG Update thread]: -> 10/20/2008 5:45:00 PM-10/20/2008 6:15:00 PM 皇家雙妹嘜
2008-10-20 15:17:59.519985 [EPG Update thread]: -> 10/20/2008 6:15:00 PM-10/20/2008 6:45:00 PM 衝鋒21
2008-10-20 15:17:59.519985 [EPG Update thread]: -> 10/20/2008 6:45:00 PM-10/20/2008 7:00:00 PM 搞邊科?
2008-10-20 15:17:59.520985 [EPG Update thread]: -> 10/20/2008 7:00:00 PM-10/20/2008 8:00:00 PM 世界正美麗
rc3 clone error.log
2008-10-20 18:18:13.077985 [ERROR][MPMain]: Exception ystem.IndexOutOfRangeException: 索引在陣列的界限之外。
於 MediaPortal.GUI.Library.GUIFont.findDirections(String inLTRText)
2008-10-20 18:18:13.077985 [ERROR][MPMain]: Exception :索引在陣列的界限之外。
2008-10-20 18:18:13.078985 [ERROR][MPMain]: site ystem.String findDirections(System.String)
2008-10-20 18:18:13.078985 [ERROR][MPMain]: source :Core
2008-10-20 18:18:13.081985 [ERROR][MPMain]: stacktrace: 於 MediaPortal.GUI.Library.GUIFont.findDirections(String inLTRText)
2008-10-20 18:18:13.082985 [ERROR][MPMain]: Exception ystem.IndexOutOfRangeException: 索引在陣列的界限之外。
於 MediaPortal.GUI.Library.GUIFont.findDirections(String inLTRText)
2008-10-20 18:18:13.084985 [ERROR][MPMain]: Exception :索引在陣列的界限之外。
2008-10-20 18:18:13.084985 [ERROR][MPMain]: site ystem.String findDirections(System.String)
2008-10-20 18:18:13.085985 [ERROR][MPMain]: source :Core