OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) Part 1 - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: Raspberry Pi (https://forum.kodi.tv/forumdisplay.php?fid=166) +---- Thread: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) Part 1 (/showthread.php?tid=211501) Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - menakite - 2014-12-23 What about https://github.com/anaconda/xbmc/commit/d5e83ffd5280762256ec1fd3cff908e34f39e957 No dirty regions, no disappearing labels on OS X. Works for the RSS ticker too. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-23 (2014-12-23, 17:32)menakite Wrote: What about https://github.com/anaconda/xbmc/commit/d5e83ffd5280762256ec1fd3cff908e34f39e957 Excellent, I think you've nailed it - that tests perfectly here! Now, if only I wasn't using an FTP server located in North Korea... RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - vbat99 - 2014-12-23 Hey Milhouse Thanks for all the hard work and advise you've been giving us Raspberry Pi users. @popcornmix Thanks for keeping us Pi users on the edge with all your newclock work. Just want to say Merry Christmas to both of you. Cheers. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-23 Many thanks, and a Merry Christmas to you all. New builds might be a bit sporadic over the next 7-10 days, not least because of the ongoing server outage but also family commitments etc. Expect normal service to be resumed early 2015. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - popcornmix - 2014-12-23 (2014-12-23, 19:07)vbat99 Wrote: Hey Milhouse Yes, thanks to Milhouse for the continued builds (and tracking down of regressions) and all the testers who have been reporting problems. Helix has just gone stable and I think it's looking pretty good for Pi users. There should be stable releases for Openelec and raspbmc real soon now. (although I'd like some testers to stick with newclock4 builds to make the Helix+1 release even better!) Happy Christmas! RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-23 New OpenELEC I****** build: #1222 (Supercedes previous build) Code: # uname -a Based on tip of OpenELEC master (9d468222, changelog) and tip of XBMC master (45ef5532, changelog) with the following modifications:
RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Heiko123 - 2014-12-23 Hello, New download server url, hosted by OpenELEC (many thanks!) Code: http://milhouse.openelec.tv/builds/master Is this path in the actually version or must I change? RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-23 If you're using the OpenELEC Updater addon you may need to wait for an update (I've PM'd Leopold), otherwise there's nothing to change if you're downloading manually. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-23 New OpenELEC I****** build: #1223 (Supercedes previous build) Code: # uname -a Based on tip of OpenELEC master (c75631bf, changelog) and tip of XBMC master (a7ded2fd, changelog) with the following modifications:
RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-24 Possibly (probably?) I had some junk in my actors/actorlinkepisode tables which I've now resolved manually, and the upgrade works fine. This is well worth testing - if it goes horribly wrong all is not lost, just downgrade and delete the new v91 database and report the error. Hopefully though it was just a one-off with my database. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - virtuallysafe - 2014-12-24 (2014-12-24, 02:19)Milhouse Wrote: Possibly (probably?) I had some junk in my actors/actorlinkepisode tables which I've now resolved manually, and the upgrade works fine. This is well worth testing - if it goes horribly wrong all is not lost, just downgrade and delete the new v91 database and report the error. Hopefully though it was just a one-off with my database. The upgrade from v90 to v91 failed for me also. Quote:ERROR: SQL: Undefined MySQL error: Code (1062) Log can be found here. Can I please ask what you did to resolve? As always, many thanks. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-24 (2014-12-24, 02:40)virtuallysafe Wrote: The upgrade from v90 to v91 failed for me also. Thanks, keep an eye on PR5653. (2014-12-24, 02:40)virtuallysafe Wrote: Can I please ask what you did to resolve? It was a bit of a pain in the arse, to be honest. In the v90 database I had to work out which actors were duplicates: Code: select strActor from actors group by strActor having count(*) > 1 then decide which of the duplicates I wanted to keep, and for those I wanted to delete I had to correct the "link" tables (in my case, all in actorlinkepisode). Take for example Wil Wheaton, who appears twice in actors: Code: 10630 Wil Wheaton <thumb>http://thetvdb.com/banners/actors/84601.jpg</thumb> Then I looked at actorlinkepisode: Code: select * from actorlinkepisode where idActor in (10630, 32018) order by idEpisode and there are several rows for idActor=10630, but only one row for 32018. As long as the idEpisode is unique, a quick fix is: Code: update actorlinkepisode set idActor=10630 where idActor=32018 Once you've fixed actorlinkepisode, you can remove the actor from actors: Code: delete from actors where idActor = 32018 Then repeat for all of your other duplicate actors. Did I say it was a PITA? It may be possible to simply delete the actors that were duplicates and leave it at that, but I've not looked into how the actorlinkepisode table is being carried across so wanted to fix the problem there in case more junk appeared in the v91 database. It's not entirely clear how these duplicate actors have occurred, as the actor insertion code shouldn't be inserting duplicates, unless it originated from a much older database, perhaps one that has been upgraded several times. I think mine dates back to v75/78, how old is yours? I've got the duplicate actors in v75, so for me that's the source. Unfortunately I dropped all earlier databases so can't say when the dupes first appeared. Alternatively wait until there's a proper automated fix, assuming this isn't an isolated problem. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - f1vefour - 2014-12-24 Thanks for getting the updated build out Milhouse, Merry Christmas to you and yours. Thanks Menakite for fixing the scrolling issue, hope to see it in xbian soon as well. RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - virtuallysafe - 2014-12-24 (2014-12-24, 03:10)Milhouse Wrote: Did I say it was a PITA? Nasty , thanks for the detailed info. After cleaning up 18 actors the upgrade has completed successfully. Basically I performed the following: Found duplicate entries in 'actors' table: Code: mysql> select strActor from actors group by strActor having count(*) > 1: Determined the multiple 'idActor' values: Code: mysql> select * from actors where strActor = "INSERT ACTOR NAME HERE"; Updated the 'actorlinkepisode' table to a single 'idActor' vlaue: Code: mysql> update actorlinkepisode set idActor=12345 where idActor=67890; Deleted the no longer required entry in 'actors' table: Code: mysql> delete from actors where idActor = 67890; Unfortunately I too have dropped a bunch of old databases recently (since the Kodi rename), however, have been using the same DB and upgrading for years. My DB backups indicate since at least v77... RE: OpenELEC Testbuilds for RaspberryPi (Kodi 15.0) - Milhouse - 2014-12-24 I'd actually suggest that anyone else with duplicate actors does NOT manually fix the problem, in case there is an automated solution that requires testing. I don't particularly fancy going back to v89 just to test this... |