home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Quality Assurance
Bugreports
Archive
EPG Genre Issue
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mm1352000" data-source="post: 1200746" data-attributes="member: 82144"><p>For anybody reading this thread in future, we found that there is indeed a bug. It's a case sensitivity problem. An example with category/genre "Test"...</p><p></p><p>The tvguide.xml contains programs with categories "Test" and "test". These categories are imported into the database correctly as "Test" and "test" respectively. However only "Test" OR "test" is available to map in TV Server Config -> EPG Genre Map. This is due to a MySQL case sensitivity quirk (MySQL DISTINCT is not case sensitive).</p><p></p><p>One workaround (probably only suitable for experts) is to manually map the required category by editing the corresponding "genreMapEntry..." setting in the database Setting table. The contents of the "genreMapEntry..." settings is a '{' separated list. So, if you wanted to map "Test" and "test" to the 3rd genre, you'd set the "genreMapEntry2" setting value to "Test{test".</p><p></p><p>Another possible workaround (again, probably only suitable for experts) may be to try to configure your database with a case-sensitive collation.</p><p><a href="http://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html" target="_blank">http://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html</a></p><p></p><p>A final workaround would be to ensure that your tvguide.xml doesn't contain category names that only differ in case.</p></blockquote><p></p>
[QUOTE="mm1352000, post: 1200746, member: 82144"] For anybody reading this thread in future, we found that there is indeed a bug. It's a case sensitivity problem. An example with category/genre "Test"... The tvguide.xml contains programs with categories "Test" and "test". These categories are imported into the database correctly as "Test" and "test" respectively. However only "Test" OR "test" is available to map in TV Server Config -> EPG Genre Map. This is due to a MySQL case sensitivity quirk (MySQL DISTINCT is not case sensitive). One workaround (probably only suitable for experts) is to manually map the required category by editing the corresponding "genreMapEntry..." setting in the database Setting table. The contents of the "genreMapEntry..." settings is a '{' separated list. So, if you wanted to map "Test" and "test" to the 3rd genre, you'd set the "genreMapEntry2" setting value to "Test{test". Another possible workaround (again, probably only suitable for experts) may be to try to configure your database with a case-sensitive collation. [URL]http://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html[/URL] A final workaround would be to ensure that your tvguide.xml doesn't contain category names that only differ in case. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Quality Assurance
Bugreports
Archive
EPG Genre Issue
Contact us
RSS
Top
Bottom