Forum

Results 1 to 3 of 3
  1. #1
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266

    Can't delete or get client information from db

    What am I doing wrong?! Below you see a full query session, only pw was removed. I'm trying to delete or get information about the client with id 18. All I get is an error.

    Code:
    login client_login_name=serveradmin client_login_password=#########
    error id=0 msg=ok
    use 1
    error id=0 msg=ok
    clientgetdbidfromuid cluid=ZXEOkc2HQkNSWig\/3UZJJyLaDwg=
    cluid=ZXEOkc2HQkNSWig\/3UZJJyLaDwg= cldbid=18
    error id=0 msg=ok
    clientdbdelete cldbid=18
    error id=512 msg=invalid\sclientID
    clientdbinfo cldbid=18
    error id=512 msg=invalid\sclientID
    Server is running 3.0.7.2... before resolving to query I have removed some server groups from the client and after that I tried to ban the client. I use my ts client, "List Clients" selected the proper client and right clicked on "Ban Client" in the following window I set permanent ban and a comment. After clicking "ok" the windows repeated to show...

    Code:
    2013-06-09 11:55:26.549241|INFO    |VirtualServer |  1| client (id:18) was removed from servergroup 'WdW-V'(id:39) by client 'Barungar'(id:3)
    2013-06-09 11:55:36.287273|INFO    |VirtualServer |  1| client (id:18) was removed from servergroup 'WdW-W'(id:40) by client 'Barungar'(id:3)
    2013-06-09 11:55:47.758712|INFO    |VirtualServer |  1| client (id:18) was removed from servergroup 'WdW'(id:32) by client 'Barungar'(id:3)
    There are no errors or anything logged in _1 or _0, also no error was given in the ts client.

    And now "List Clients" wont show the client anymore. And even server query has some issues with that client.

  2. #2
    Join Date
    September 2012
    Posts
    6,076
    If you have a copy before your attempts, keep it.
    Create a backup of the current database.

    If you have experience with the database, take a look and see if you can find any mention of the client in the database or remnants of it.

  3. #3
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    I downloaded a copy of the sqlite db, and opened if local on another host.
    A "SELECT * FROM clients WHERE client_id=18;" got a result of 0 rows.
    After that I tried to restart the server...

    The Restart of the teamspeak-server itself solved the "server query issue"... now the client with id 18 is no longer findable.

    Code:
    clientgetdbidfromuid cluid=ZXEOkc2HQkNSWig\/3UZJJyLaDwg=
    error id=512 msg=invalid\sclientID
    So as far as I can tell... the "List Clients" -> "Ban Clients" did not create a ban but rather deleted the client in the database. In the memory? of the running server it seems that the failed ban/delete was not registered properly.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Client reports, with Lack of information.
    By dante696 in forum Client Support
    Replies: 1697
    Last Post: Yesterday, 09:38 PM
  2. how refresh client information
    By 1230456 in forum Client Plugins / Lua Scripts
    Replies: 3
    Last Post: October 6th, 2015, 05:40 PM
  3. [Resolved] [not possible] Need to disable users from viewing client information
    By samerdl in forum Server Support
    Replies: 1
    Last Post: October 10th, 2011, 07:34 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
  •