Forum

Results 1 to 6 of 6
  1. #1
    Join Date
    December 2009
    Location
    New Jersey USA
    Posts
    77

    Admin Server Query Error since Beta 23

    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?

  2. #2
    Join Date
    June 2002
    Location
    Krün / Germany
    Posts
    1,638
    did you read the changelog ?

    Code:
    ! 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>;

  3. #3
    Join Date
    December 2009
    Location
    Deutschland
    Posts
    25
    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

  4. #4
    Join Date
    September 2002
    Location
    Germany
    Posts
    82
    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?

  5. #5
    Join Date
    June 2010
    Location
    France
    Posts
    1
    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?

  6. #6
    Join Date
    September 2003
    Location
    France
    Posts
    37
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. My server's Admin Server Query error invalid clientID.
    By beerza991 in forum Server Support
    Replies: 5
    Last Post: September 15th, 2017, 04:10 PM
  2. [Not possible] Server Admin error on Client connect with Query Group
    By TandelK in forum Server Support
    Replies: 1
    Last Post: September 20th, 2015, 03:49 PM
  3. Replies: 1
    Last Post: December 30th, 2010, 08:57 AM
  4. [no bug] Query command on server Beta 26 [build 11927]
    By florian_fr40 in forum Bug Reports [EN/DE]
    Replies: 2
    Last Post: July 29th, 2010, 11:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •