TV Groups are not showing up in TVServer Setup (1 Viewer)

neo2001

Portal Member
December 26, 2008
37
0
Germany Germany
The MySQL command line client should also do it.

Something like this (Didn't test it! I'm using SQL Server):
Code:
mysql -uroot -p MyTvDb -e "DELETE FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)"
 

SpudR

Documentation Group
  • Team MediaPortal
  • July 27, 2007
    2,632
    702
    Yorkshire, UK
    England England
    Country flag
    It works ALMOST!

    you need to run this in the "Program Files\MySQL\MySQL Server 5.0\bin" folder...
    Code:
    mysql -uroot -p MpTvDb -e "DELETE FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)"
    (note the db is named mpTvDb - not myTvDb) :)

    THANKS!!!! :D

    Also - I'm now running this http://www.heidisql.com/ to manage my Database
     

    4roma

    MP Donator
  • Premium Supporter
  • April 16, 2009
    133
    3
    Groningen
    Netherlands Netherlands
    Great. After replacing my TV card, I also have no option to create or modify groups in TV Config anymore. So channels are a mess :mad:

    Now reading the above "workaround" does not help me much since I see no way to enter the command in the Microsoft SQL Server management app. There is no option I see to enter free text or anything.

    How come this is no bug? I had the option to create groups and/or to sort my channels. I still have a link in the config tool, though it's just not showing the options it should. It's gone, it was there, in my vocabulary this is called a bug.

    If someone can point me in the right direction how to enable this little, but oh so important modification option, I'd be very thankfull.

    MP 1.0.2 with the TV server that came with it and Microsoft SQL Server 2005.
     

    chemelli

    Retired Team Member
  • Premium Supporter
  • September 28, 2006
    6,159
    2,264
    46
    Milano, Italy
    Italy Italy
    Country flag
    Now reading the above "workaround" does not help me much since I see no way to enter the command in the Microsoft SQL Server management app. There is no option I see to enter free text or anything.
    You have to download and install SQL Server Management Studio and then select "new query".

    Simone
     

    4roma

    MP Donator
  • Premium Supporter
  • April 16, 2009
    133
    3
    Groningen
    Netherlands Netherlands
    Now reading the above "workaround" does not help me much since I see no way to enter the command in the Microsoft SQL Server management app. There is no option I see to enter free text or anything.
    You have to download and install SQL Server Management Studio and then select "new query".

    Simone
    Installed SQL SMS and entered the query. Got this back:

    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'groupmap'.
     

    infinite.loop

    Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Austria Austria
    Now reading the above "workaround" does not help me much since I see no way to enter the command in the Microsoft SQL Server management app. There is no option I see to enter free text or anything.
    You have to download and install SQL Server Management Studio and then select "new query".

    Simone
    Installed SQL SMS and entered the query. Got this back:

    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'groupmap'.
    Did you enter the MpTvDb? ;)
     

    Schwabe78

    Portal Member
    April 22, 2009
    17
    0
    Germany Germany
    Hi

    so, i invested some time to fix my TVserver prob. I download MYSQL SMS Express and try to enter the query. I got this back:

    Meldung 102, Ebene 15, Status 1, Zeile 1
    Falsche Syntax in der Nähe von 'uroot'.

    Pleas need some help....

    Greetings

    Schwabe
     

    neo2001

    Portal Member
    December 26, 2008
    37
    0
    Germany Germany
    Hi

    so, i invested some time to fix my TVserver prob. I download MYSQL SMS Express and try to enter the query. I got this back:

    Meldung 102, Ebene 15, Status 1, Zeile 1
    Falsche Syntax in der Nähe von 'uroot'.

    Pleas need some help....

    Greetings

    Schwabe
    The line (thx for correction BTW @SpudR)
    Code:
    mysql -uroot -p MpTvDb -e "DELETE FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)"
    is supposed to call the MySQL(!) command line client and execute the sql-query.

    If you are using Microsoft SQL Server, you should open the Management Studio, connect to the server and type (copy'n'paste):
    Code:
    USE MpTvDb; -- or the name of your database if different
    DELETE FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel);
    GO;
    and run the query (press F5).
     

    Schwabe78

    Portal Member
    April 22, 2009
    17
    0
    Germany Germany
    Hi

    i tested your new commandline. You must delete the last Go- Command ! Then it works great. I´m happy, thats it works. Thank´s a lot !!

    :D:D:D
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    K How to turn off "All channels" groupe in Radio? MediaPortal 1 Talk 3
    N [Finished] [MP2-781] Enable one-click deletion of grouped TV recordings MediaPortal 2 70
    HTPCSourcer [Rejected] Replace "Filter by" by "Group by" MediaPortal 2 14
    N [Rejected] Rename "Filter" to "Group by" Feature Requests 3
    N HD Channels of RTL Channel Group not working anymore Television (MyTV frontend and TV-Server) 6
    Frans Nijhuis [further infos missing] Deleting all TV channels and all channel groups in "MP 2 TV configuration" fails 2.2 Archive 1
    toricred Only Show Actual Recordings General 1
    R MP 2.2.3 Search TV program only with the correct begin of show title General 7
    F Show Player info while skipping Feature Requests 0
    P Recordings not showing up unless re-imported and not possible to delete General 0
    C Imported media doesn't show up immediately? General 1
    mrmojo666 [Tv Server Plugin ]Direct Show Video Control Plugin 0.0.0.1 for Hauppauge PVR cards MediaPortal 1 Plugins 0
    tano_grasa Movie cover not showing when starting a movie aMPed 0
    M [Rejected] Always show full hours in TV Guide Feature Requests 2
    J Understanding what EPG shows about schedules General 8
    J Show media item location Feature Requests 4
    ratata Non present codecs is still showing... MediaPortal 1 Talk 2
    C Recording back to back shows from IPTV streams General Support 8
    J Resume from Standby Last Module TV Showing TV Server Settings Television (MyTV frontend and TV-Server) 2
    K Genres in MovingPictures not show ... Fanart Handler 12
    G How best to get cover art for tracks to show up on the Audio Menu (Latest Added, Unplayed)? General 9
    Lehmden Manual schedule: Possibility to enter a show name Feature Requests 1
    N [Finished] [MP2-806] Playing a recorded radio program does not show screen to allow skipping forward, etc MediaPortal 2 141
    B Media info shows audio is 5.1 MP shows 2.0 Watch / Listen Media 2
    ge2301 [Finished] [MP2-782] Show mouse cursor only if it was moved more than 10 pixels MediaPortal 2 13
    Similar threads

























    Top Bottom