CRITICAL BUG! THIS CAN DESTROY YOUR DATABASE!
BUG IN: Server
BUG NAME: Removing clients without deleting group entries
- System: Ubuntu 12.04.3 LTS (vServer, using OpenVZ)
- TS3-Server: 126.96.36.199 (using MySQL)
- MySQL Permissions: ALL (NOT: GRANT, CREATE TEMPORARY TABLES, LOCK TABLES)
Is seems like the server didn't delete group entries for the user from the table "group_server_to_client" when the client was deleted from the "clients" table with TeamSpeak (not manuallly!). If you want to list all clients from a server group and this group owns one of the "dead" entries, the client will throw out a "invalid CLIENTID()" error and you will see no clients.
HOW I FIX IT:
You have to enter your MySQL Admin Panel and execute the following command (stop your server before):
You have to change "USE teamspeak;" to your database. (e.g.: "USE mytsdatabase;")
LIST ALL DEAD ENTRIES
DELETE THIS ENTRIES
SELECT * FROM group_server_to_client WHERE id1 NOT IN (SELECT client_id FROM teamspeak.clients);
DELETE FROM group_server_to_client WHERE id1 NOT IN (SELECT client_id FROM teamspeak.clients);
Why does this bug appears? I didn't delete any user from the database with mysql admin cp. Only with TS3-Client.
Is this a "ONE-TIME" bug or a global problem?