On kodi standard skin estuary the problem is the same.
I have a shared MySQL libary where the RPI has no problem and the Vero1 in the past also had no problems like this.
So it looks like a Vero 4k problem or am I jumping to conclusoins ?
Tia
Leurb
With no log, it’s hard to speculate. The problem has been reported by OP on a Raspberry Pi, so it’s not likely to be specific to one device.
I would see if the issue arises with a new library first.
So I created a fresh libary on a new mysql (mariadb 10) server.
Exactly the same problem so here are the logs
https://paste.osmc.tv/ulagedumub
Hope you will find the problem because it’s still so strange for me that it works fine on RP1 and Vero1 (with the same dB)
Please logon to the database using something like:
mysql -u <user> -p MyVideos107
(I assume the user is osmc) and then run the following SQL query:
select idshow, c00, totalcount from tvshow_view;This Query gives the row count of 65 (wich is the total shows)
The show gives the correct number of episodes and or the empty shows is gives the total count of NULL.
For as far I can see are these the correct numbers.
Do you need a printscreen or something ?
Tia.
Leurb
Yes, please show the output from this query (and any future queries).
It would help greatly if you could do the follwing:
Open an SSH session and then run tail -f ~/.kodi/temp/kodi.log.
From the TV, enable debugging, then return to the main menu. Make a note of the time on the kodi log when you did this.
Go to TV shows and note the time on the Kodi log. Confirm that empty shows are listed.
Select a show you know is empty and again note the time on the Kodi log.
Back out to the main menu and note the time. Confirm that the empty show has disappeared.
In the SSH session, Ctrl-C the tail command and then run grab-logs -X. Provide the URL and the times from points 2-5 above.
I also did some log grepping, found the following:
When entering TV Shows from the main menu:
16:30:13.339 T:1958522880 DEBUG: OnKey: 11 (0x0b, obc244) pressed, action is Select
16:30:13.340 T:1958522880 DEBUG: Activating window ID: 10025
16:30:13.556 T:1958522880 DEBUG: ------ Window Deinit (Home.xml) ------
16:30:13.580 T:1958522880 DEBUG: ------ Window Init (MyVideoNav.xml) ------
16:30:13.581 T:1958522880 DEBUG: CGUIMediaWindow::GetDirectory (library://video/tvshows/titles.xml/)
16:30:13.581 T:1958522880 DEBUG: ParentPath = [library://video/tvshows/titles.xml/]
16:30:13.600 T:1958522880 DEBUG: RunQuery took 6 ms for 13 items query: SELECT * FROM tvshow_view
After selecting a show then pressing a back:
16:30:26.923 T:1958522880 DEBUG: OnKey: menu (0xd8) pressed, action is Back
16:30:26.926 T:1958522880 DEBUG: CGUIMediaWindow::GetDirectory (videodb://tvshows/titles/?xsp=%7b%22order%22%3a%7b%22direction%22%3a%22ascending%22%2c%22ignorefolders%22%3a0%2c%22method%22%3a%22sorttitle%22%7d%2c%22type%22%3a%22tvshows%22%7d)
16:30:26.927 T:1958522880 DEBUG: ParentPath = [videodb://tvshows/]
16:30:26.973 T:1008727024 DEBUG: RunQuery took 14 ms for 12 items query: SELECT * FROM tvshow_view WHERE totalCount IS NOT NULL AND totalCount > 0
So I can also see the different SQL query, on the first one that titles.xml is a bit suspicious for me.
The video/tvshows/titles.xml looks like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<node order="2" type="filter">
<label>369</label>
<icon>DefaultTVShowTitle.png</icon>
<content>tvshows</content>
<order direction="ascending">sorttitle</order>
</node>
Also what I found in video_flat/tvshows.xml is the visible attribute:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<node order="2" type="filter" visible="Library.HasContent(TVShows)">
<label>20343</label>
<icon>DefaultTVShows.png</icon>
<content>tvshows</content>
<order direction="ascending">sorttitle</order>
</node>That’s interesting but:
Could I please see the output of the first query that produces 65 rows?
I was hoping to see a Kodi log, instead of a few snippets, and a set of four times.
How many shows do you have and how many are empty? Initially you said you have 65 shows when you ran
select idshow, c00, totalcount from tvshow_view;
but I’m seeing
RunQuery took 6 ms for 13 items query: SELECT * FROM tvshow_viewThe count 65 was another user, I don’t have mysql server, but see the data from sqlite (I have 13 shows from which 1 is empty):
osmc@osmc:~/.kodi/userdata/Database$ sqlite3 MyVideos107.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
sqlite> select idshow, c00, totalcount from tvshow_view;
3|Californication|12
4|Downton Abbey|9
5|Dragon Ball Z|39
7|Halt and Catch Fire|10
16|The Sopranos|13
47|The Big Bang Theory|1
48|Brooklyn Nine-Nine|1
49|Rick and Morty|10
50|Mr. Robot|1
51|South Park|1
52|Stranger Things|
53|The Walking Dead|1
54|Strike Back|2
sqlite> select count(*) from tvshow_view;
13
sqlite> select count(*) from tvshow_view where totalcount is not null and totalcount > 0;
12
Full logs are here, see 16:30:13 and 16:30:26, although it is full of cec logs.
Sorry, you jumped in on the thread, so I thought you were @leurb. It therefore seems that the problem is not only with one person.
Anyway, your information is very useful.
According to the log, you selected “Mr. Robot” (idShow = 50), which has 1 episode. The empty show is “Stranger Things”, right?
Which skin were you using? Is the problem there with both Estuary and OSMC skins?
I was the OP, just came back after a while.
You’re correct, I’ve selected Mr. Robot, and Stranger Things is the empty one.
As I mentioned previously, only OSMC skin has the problem, Estuary is working fine, that hasn’t changed since.
So you were. Humble apologies. And I guess, welcome back!
Here are the logs from this request.
https://paste.osmc.tv/umuwaqopos
Recorded times:
2- 19.25
3- 19.26.37
4- 19.27.06
5- 19.27.37
And the complete output off the query requested before
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2608
Server version: 5.5.57-MariaDB Source distribution
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [MyVideos107]> select idshow, c00, totalcount from tvshow_view;
+--------+---------------------------------+------------+
| idshow | c00 | totalcount |
+--------+---------------------------------+------------+
| 473 | Lethal Weapon | 5 |
| 475 | The Grand Tour (2016) | NULL |
| 491 | The Girlfriend Experience | 2 |
| 505 | Homeland | NULL |
| 506 | The 100 | NULL |
| 476 | Marvel's Luke Cage | NULL |
| 492 | Westworld | NULL |
| 507 | Penny Dreadful | 9 |
| 477 | The Bridge (2011) | NULL |
| 489 | Marvel's Daredevil | NULL |
| 510 | Vikings | NULL |
| 513 | The Walking Dead | 3 |
| 481 | Lucifer | 37 |
| 515 | The Originals | NULL |
| 517 | Supernatural | 254 |
| 519 | American Horror Story | 10 |
| 520 | Sherlock | NULL |
| 527 | Doctor Who (2005) | NULL |
| 484 | Killjoys | 30 |
| 529 | Star Wars Rebels | 8 |
| 530 | The Flash (2014) | 5 |
| 532 | Arrow | 5 |
| 486 | Shadowhunters | 21 |
| 533 | Marvel's Agents of S.H.I.E.L.D. | NULL |
| 551 | Elementary | 24 |
| 487 | DC's Legends of Tomorrow | 5 |
| 555 | 12 Monkeys | NULL |
| 488 | Fear the Walking Dead | 37 |
| 495 | Halt and Catch Fire | 10 |
| 557 | Game of Thrones | 67 |
| 560 | Mr. Robot | 5 |
| 499 | Van Helsing | 19 |
| 525 | Jordskott | NULL |
| 526 | Evelien | 20 |
| 575 | The Magicians (2015) | 26 |
| 508 | Supergirl | 5 |
| 531 | The Expanse | NULL |
| 534 | Colony | 23 |
| 538 | Timeless (2016) | 16 |
| 535 | According to Jim | 182 |
| 543 | Follow The Money | NULL |
| 546 | Legion | NULL |
| 552 | Midnight Sun | NULL |
| 564 | Wynonna Earp | NULL |
| 554 | Marvel's Iron Fist | NULL |
| 566 | Travelers (2016) | 4 |
| 558 | The Last Ship | 10 |
| 559 | Marvel's Jessica Jones | NULL |
| 562 | The Shannara Chronicles | 6 |
| 563 | Stranger Things | 9 |
| 567 | Star Trek: Discovery | 8 |
| 568 | Marvel's Cloak & Dagger | NULL |
| 569 | The Sandhamn Murders | 15 |
| 570 | Marvel's The Defenders | NULL |
| 571 | Marvel's Inhumans | 8 |
| 573 | Rebecka Martinsson | NULL |
| 574 | Midnight, Texas | 10 |
| 576 | The Orville | 9 |
| 577 | The Sinner | 8 |
| 578 | Prisoners | NULL |
| 579 | Salvation | 13 |
| 581 | Marvel's The Punisher | NULL |
| 580 | Big Little Lies | 7 |
| 582 | Marvel's Runaways | NULL |
| 583 | The Gifted | 6 |
+--------+---------------------------------+------------+
65 rows in set (0.07 sec)
Hope you can find something
Tia
Leurb
Thanks for the log. It confirms what I expected to see and replicates the log from @NPeete, and also my own tests on a Vero4K.
Here’s what I believe is happening (using the times from this latest log):
19:26:37.533 When you enter the TV Shows menu it runs this SQL:
SELECT * FROM tvshow_view
and returns 65 rows. The SQL query is saying get everything from the tvshows_view, even though in doing so it will return all those shows with a totalcount of NULL. The totalcount column is, as the name suggests, the number of episodes recorded on the database for each TV series.
19:27:05.850 You choose 12 Monkeys (idShow = 555).
19:27:37.564 You return to the TV Shows menu and this time it runs this SQL:
SELECT * FROM tvshow_view WHERE totalCount IS NOT NULL AND totalCount > 0
and returns 38 rows. The code is now correctly excluding those shows with a totalcount of NULL (and also those with a totalcount < 1), which it should have done on the first query at 19:26:37.533.
I can also confirm that I was able to reproduce the same behaviour on my Vero4K and that the issue does not occur with the Estuary skin.
@sam so we found out what the problem is and nobody seems to fix it.
No reply in 2,5 weeks.
Can you do anything ?
No fix for this yet. I understand that changing the skin resolves this, so it may be an option for now
While we do understand the problem we do not yet know the cause
Sam