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
Development
Submit: code patches (MediaPortal/TV-Server/etc.)
TvPlugin ZapOsd Patch
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="Neos" data-source="post: 723329" data-attributes="member: 67572"><p>The tables do not contain any corrupted data, if there is corruption mysql will simply refuse to load that particular table until it's repaired <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /> . I'll rescan my cards in a bit to see of the channels are added to the groupmap again. Before doing so I will of course truncate all the channel related tables and the group table. (I also use mysql for other projects; I'm not an SQL expert but can write more complicated queries.)</p><p></p><p>The query I ran first was: <strong>SELECT * FROM groupmap LEFT JOIN channel ON channel.channelId = groupmap.channelId WHERE channel.isRadio = 1;</strong> which is identical to the one you posted (I think) except that I used an explicit join and you did not. Afterwards I just ran the same query without the channel.isRadio = 1 clause sorting by sortOrder to get a nice view of how the groupmap object inside mediaportal would look <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" />.</p><p></p><p>I also have one analogue card installed but I do not receive any radio through this card.</p></blockquote><p></p>
[QUOTE="Neos, post: 723329, member: 67572"] The tables do not contain any corrupted data, if there is corruption mysql will simply refuse to load that particular table until it's repaired ;) . I'll rescan my cards in a bit to see of the channels are added to the groupmap again. Before doing so I will of course truncate all the channel related tables and the group table. (I also use mysql for other projects; I'm not an SQL expert but can write more complicated queries.) The query I ran first was: [B]SELECT * FROM groupmap LEFT JOIN channel ON channel.channelId = groupmap.channelId WHERE channel.isRadio = 1;[/B] which is identical to the one you posted (I think) except that I used an explicit join and you did not. Afterwards I just ran the same query without the channel.isRadio = 1 clause sorting by sortOrder to get a nice view of how the groupmap object inside mediaportal would look ;). I also have one analogue card installed but I do not receive any radio through this card. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Submit: code patches (MediaPortal/TV-Server/etc.)
TvPlugin ZapOsd Patch
Contact us
RSS
Top
Bottom