Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Location
    Germany
    Posts
    75

    Arrow How to solve "database invalid constraint"

    Hello guys, I wanted to share with you how I fixed the error "database invalid constraint". I was looking for a solution for such a long time and none worked, so maybe I can help some of you.
    But - I'm just talking about the database invalid constraint in the "Admin Server Query" group - not the normal "Server Admin" group.

    Requirements:
    Access to the database
    (SQLite Manager (Firefox addon))
    (Access to the serveradmin user to readd group members)

    There are actually two things that can cause this mistake - at least I think so ;-)
    1.) A Client in the Admin Server Query group has not the groupID = 0.
    How to solve it with a SQLite database:

    Download an SQL-editor - SQLite Manager for Firefox is fine.
    Open your Teamspeak 3 database "ts3server.sqlitedb" (!!You might have to tick a box to show ALL fileextentions!!) and get into the table "group_server_to_client"
    Click on Execute SQL and enter:
    Code:
    UPDATE group_server_to_client SET server_id = 0 WHERE group_id = X
    where X is the groupID of your Admin Server Query group (default 2).
    Run SQL
    Job's done. Error might be fixed.

    It was not in my case. There have been double entries - so we gonna remove them now.
    Same steps as in the first solution, but do not click on execute SQL - but on "Browse & Search". There are all Servergroups of all servers of your database. What we're looking for are clients with the groupID of the Admin Server Query group - in most cases 2.
    What I did now was to click on "group_id" so that we got the clients in the right order. Now you gonna highlight every client which is in the Admin Server Query group ID (EXCEPT SERVERADMIN!!! id1=1) and delete them.
    Job's done - you've got no more invalid constraints in there. Now just readd you into the Admin Server Query group with the user "serveradmin" which you hopefully have not deleted ;-)

    I hope I could help you and you enjoyed my tutorial.
    If you find any mistakes in my spelling/grammar you can keep them and sell them on Ebay
    Mfg Madmatti

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    More simple, when you have this error message, you have an importante indication in the server log that show you where is the problem .....

    This forum have many threads for this.
    You have several tools on this forum to find the problem.

  3. #3
    Join Date
    May 2009
    Location
    Germany
    Posts
    75
    Fine ;-) Thats my log - would you mind to show me where the message is, please?
    Code:
    2010-10-02 10:06:39.841545|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta29 [Build: 12473], Linux
    2010-10-02 10:06:39.841860|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2010-10-02 10:06:39.841924|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
    2010-10-02 10:06:39.842290|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
    2010-10-02 10:06:40.163977|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days
    2010-10-02 10:06:40.165336|INFO    |SQL           |   | pruning old guest clients where last connected time is older than 30 days, clients to remove: 67
    2010-10-02 10:06:40.387798|INFO    |SQL           |   | updated permissions to version 7
    2010-10-02 10:06:40.437926|INFO    |SQL           |   | updated permissions to version 8
    2010-10-02 10:06:40.623425|INFO    |Accounting    |   | Licensing Information
    2010-10-02 10:06:40.623516|INFO    |Accounting    |   | type              : Non-profit
    2010-10-02 10:06:40.623612|INFO    |Accounting    |   | starting date     : Wed May 19 00:00:00 2010
    2010-10-02 10:06:40.623667|INFO    |Accounting    |   | ending date       : Thu May 19 00:00:00 2011
    2010-10-02 10:06:40.623788|INFO    |Accounting    |   | max virtualservers: 10
    2010-10-02 10:06:40.623839|INFO    |Accounting    |   | max slots         : 512
    2010-10-02 10:06:40.651756|INFO    |FileManager   |   | listening on 0.0.0.0:30033
    2010-10-02 10:06:40.711320|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
    2010-10-02 10:06:40.764238|INFO    |VirtualServer |  2| listening on 0.0.0.0:4711
    2010-10-02 10:06:40.842961|INFO    |VirtualServer |  3| listening on 0.0.0.0:9999
    2010-10-02 10:06:40.900597|INFO    |VirtualServer |  5| listening on 0.0.0.0:4754
    2010-10-02 10:06:40.967168|INFO    |VirtualServer |  7| listening on 0.0.0.0:7777
    2010-10-02 10:06:41.030303|INFO    |VirtualServer |  8| listening on 0.0.0.0:1212
    2010-10-02 10:06:41.082256|INFO    |VirtualServer |  9| listening on 0.0.0.0:2222
    2010-10-02 10:06:41.132569|INFO    |VirtualServer | 10| listening on 0.0.0.0:1234
    2010-10-02 10:06:41.181778|INFO    |VirtualServer | 11| listening on 0.0.0.0:6666
    2010-10-02 10:06:41.243760|INFO    |VirtualServer | 12| listening on 0.0.0.0:1111
    2010-10-02 10:06:41.244233|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 84.60.188.58, 85.25.120.233, 
    2010-10-02 10:06:41.244611|INFO    |Query         |   | listening on 0.0.0.0:10011

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [On Todo] [TS 3.1] Query login and "database invalid constraint"
    By florian_fr40 in forum Bug Reports [EN/DE]
    Replies: 4
    Last Post: March 1st, 2011, 08:17 AM
  2. [On Todo] [TS 3.1] Query login and "database invalid constraint"
    By florian_fr40 in forum Suggestions and Feedback
    Replies: 0
    Last Post: February 28th, 2011, 02:35 PM
  3. database invalid constraint
    By TheKilledDeath in forum Server Support
    Replies: 4
    Last Post: October 3rd, 2010, 09:07 AM
  4. about database invalid constraint
    By Madmatthi in forum General Questions
    Replies: 2
    Last Post: July 17th, 2010, 03:53 AM
  5. database invalid constraint
    By damaboo in forum Windows
    Replies: 8
    Last Post: January 29th, 2010, 11:59 AM

Tags for this Thread

Posting Permissions

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