Admin Server Query Error since Beta 23

[BaDaSS]

After the update I went to view Permissions/Server Groups/Admin Server Query and I get an error " database invalid constraint " and for some reason it shows me in the Home channel only with 2 server admin icons.

Any Idea's?

[R. Ludwig]

did you read the changelog ?

! clients added to serverquery groups need to be assigned to serverID == 0.
  If you have added any clients to one of your serverquery groups, you'll need
  to update your database manually to retain functionality. All serverquery
  group assignments are stored in a database table called
  "group_server_to_client". To update your existing serverquery group
  assignments, please execute this command on your database:
  UPDATE group_server_to_client SET server_id = 0 WHERE
    group_id = <YOUR_QUERY_GROUP_ID>;

[Marvman]

Hallo

I think my english is not good enough.... how i find my YOUR_QUERY_GROUP_ID what is this ??? dont understand it reight now !!!


Greetz Marv

[Jammet]

I've also updated and gotten a nice, friendly error.

~/teamspeak3-server_linux-x86> ./ts3server_minimal_runscript.sh
TeamSpeak Server 3.0.0-beta23 [Build: 11239]
(c)TeamSpeak Systems GmbH

Logging started
2010-06-02 23:28:51.814705|INFO |ServerLibPriv | | Server Version: 3.0.0-beta23 [Build: 11239], Linux
2010-06-02 23:28:51.816257|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2010-06-02 23:28:51.816843|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
2010-06-02 23:28:51.817816|INFO |DatabaseQuery | | checking database integrity (may take a while)
2010-06-02 23:28:51.861715|ERROR |DatabaseQuery | | db_exec failed index index_clients_uid already exists
2010-06-02 23:28:51.862342|ERROR |DatabaseQuery | | db_exec() CREATE INDEX index_clients_uid ON clients (client_unique_id, server_id error: index index_clients_uid already exists
2010-06-02 23:28:51.862624|ERROR |SQL | | database update to revision: 15 failed!

Is there somebody who can help and explain it to me?

[Tenefer]

I have the same problem Jammet

~/teamspeak/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh
TeamSpeak Server 3.0.0-beta23 [Build: 11239]
(c)TeamSpeak Systems GmbH

Logging started
2010-06-03 08:53:11.082164|INFO |ServerLibPriv | | Server Version: 3.0.0-beta23 [Build: 11239], Linux
2010-06-03 08:53:11.083260|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2010-06-03 08:53:11.083295|INFO |DatabaseQuery | | dbPlugin version: 1
2010-06-03 08:53:11.087747|ERROR |DatabaseQuery | | db_exec() CREATE INDEX index_clients_uid ON clients (client_unique_id, server_id error: Duplicate key name 'index_clients_uid'
2010-06-03 08:53:11.087805|ERROR |SQL | | database update to revision: 15 failed!

Someone has a solution please?

[Korigon]

YOUR_QUERY_GROUP_ID = 2 in most of case (99%)

Stop server

>sqlite3 ts3server.sqlitedb
sqlite> select * from group_server_to_client where group_id=2;
2|0|1|0
2|1|2|0
2|2|5|0
2|3|93|0
sqlite> UPDATE group_server_to_client SET server_id = 0 WHERE group_id = 2;
sqlite> select * from group_server_to_client where group_id=2;
2|0|1|0
2|0|2|0
2|0|5|0
2|0|93|0
sqlite>

Start Server & have fun.