LogoManager 1.0.0.3 [27-11-2022] (2 Viewers)

[Vasilich]

pls replace LogoManager.dll with attached, try to grab logo for group "All Channels", then for "MTV", and then post logs here

 

[Ede]

Good morning,

no success. Thank you for your support!

 

[Vasilich]

pls same as before with attached version - i am still trying to localize the place in code where your error happens...

 

[Ede]

Thank you, but no success.
As more you are investigating, the more I hope, that there is not one stupid setting on my side.
I did a clean reinstall of MP 1.7 today. Only my mysql db is the old one.

 

[Vasilich]

if you know how to write SQL commands, can you pls test following request
"select c.* from channel c inner join groupmap gm on (c.idChannel = gm.idChannel and gm.idGroup = 1) order by gm.SortOrder asc"
and post the result here?
We have found the code line causing problems, but still cannot understand why your MP has problems with it.

 

[Ede]

I had to adjust the query to case sensitive.

select c.* from Channel c inner join GroupMap gm on (c.idChannel = gm.idChannel and gm.idGroup = 1) order by gm.SortOrder asc

I had to

 

[Ede]

The Problem seems to be the case sensitive part. As I can see in the query log, the query doesn´t come case sensitive, all lower case. As mysql, in my case mariadb, on unix like systems works case sensitive, the query will result an error. On windows it may work.
See:
https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names

 

[Edalex]

Yeah, Vasilich told me this. I have no idea how did you move TV Server database on linux but let's ask [USERGROUP=39]@Developers[/USERGROUP] if they consider it as TVBusinessLayer bug
https://github.com/MediaPortal/Medi...atabase/TvBusinessLayer/BusinessLayer.cs#L484
I tried to build TVBusinessLayer with fixed query.
UPD Put it in Mediaportal folder

 

[Ede]

The query is still:

select c.* from channel c inner join groupmap gm on (c.idChannel = gm.idChannel and gm.idGroup =7) order by gm.SortOrder asc

It has to be:

select c.* from Channel c inner join GroupMap gm on (c.idChannel = gm.idChannel and gm.idGroup = 1) order by gm.SortOrder asc

 

[Edalex]

Maybe I did smth wrong. @Sebastiii help me