TV Groups are not showing up in TVServer Setup (4 Viewers)

[neo2001]

The MySQL command line client should also do it.

Something like this (Didn't test it! I'm using SQL Server):

mysql -uroot -p MyTvDb -e "DELETE FROM groupmap WHERE NOT EXISTS (SELECT * FROM channel WHERE channel.Idchannel = groupmap.Idchannel)"

 

[SpudR]

It works ALMOST!

you need to run this in the "Program Files\MySQL\MySQL Server 5.0\bin" folder...

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!!!!

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

 

[4roma]

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

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]

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]

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]

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?

 

[4roma]

Did you enter the MpTvDb?

Learning every day....

Thanks guys, I'm happy now

 

[Schwabe78]

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]

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)

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):

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]

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 !!