Forum

Results 1 to 11 of 11
  1. #1
    Join Date
    March 2019
    Posts
    8

    List all clients -> convert error

    Hi,

    I just update from 3.6.1 to 3.7.0 and I got an issue regarding in List All Clients.

    On teamspeak client if you press on Permissions > List All Clients. The output is (Disconnected from server (convert error))

    I try to look on database for ilegal character but I don't think is fron names.

    Hope we can find the issue on this.

    Thanks

  2. #2
    Join Date
    June 2008
    Posts
    18,112
    Works fine here. Can you upload that database somewhere and send it to me in a private message?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  3. #3
    Join Date
    March 2019
    Posts
    8
    Sorry for delay response.

    Send PM

    Thank you

  4. #4
    Join Date
    June 2008
    Posts
    18,112
    No problem. The response wasn't late.

    I could reproduce it and tried to find the user/entry causing this.
    But I could not find it yet under these amount of users
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  5. #5
    Join Date
    March 2019
    Posts
    8
    I try as well but my worry is, how was possible to end up like that?

    The version from 3.6.1 > 3.7.0 should not make any difference, plus Teamspeak 3 will not add to database new user if can't be read.

    Could the new version change how nickname will be stored in the database and because the new version has a new restriction?

    I spend like 2 days to find that user or users, no luck

    What I try to find is forcing column client_nickname as utf-8 and rewrite all users, no luck with this. Do you think can be an identity as well?

    Thanks

  6. #6
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,344
    First-generation TeamSpeak mobile apps use CESU-8, while the second generation uses UTF-8. Prior to 3.2.0, servers did not support unicode beyond BMP, and blocked corresponding UTF-8 input. However, servers up to 3.0.11.3 did accept CESU-8. The desktop client never supported CESU-8 but crashes like you see it here. The servers return raw database output, so if a first-generation mobile app client connected to your server while running a version of 3.0.11.3 and below, invalid input would be stored in the database, preventing the snapshot feature from working after upgrading to 3.0.11.4 and up, and crashing many desktop client versions. Second-generation mobile apps handle both, CESU-8 and UTF-8 input correctly. As always, explained on yat.qa. However, that says that current clients should prevent convert errors by replacing CESU-8 with �, but that might not apply to the client DB.

  7. #7
    Join Date
    March 2019
    Posts
    8
    Thank you for your response.

    The server start as 3.4.0 and migrate to 3.5.1, 3.6.1 and 3.7.0. The migration from 3.6.1 to 3.7.0 the issue I'm representing should not be. The server is not older then 3.4.0 witch I don't think will be apply some issue because the database was on old version.

    I don't understand because I can't debug, will be great if an error as SQL Query faild to be printed in logs so we can find the issue quicky and fix it.

    Hope dante will or someone will find a solution the server.

    Thanks again

  8. #8
    Join Date
    June 2008
    Posts
    18,112
    I found the error. It took a while but it looks like the database was modified and to many entries got removed.

    You have a lot of clients in your database where no entry exists in table client_properties and when the client requests these client properties it will disconnect.
    Example: Lowest client id is 49045 but lowest client_properties begins with client id 49064
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  9. #9
    Join Date
    March 2019
    Posts
    8
    Hi dante,
    -- At line 1:
    DELETE FROM client_properties
    WHERE NOT EXISTS (
    SELECT *
    FROM clients CL
    WHERE CL.client_id=client_properties.id
    )
    -- Result: query executed successfully. Took 76ms, 0 rows affected
    Let look on the reverse so try to remove clients where not have property

    -- At line 1:
    DELETE FROM clients
    WHERE NOT EXISTS (
    SELECT *
    FROM client_properties CP
    WHERE CP.id=clients.client_id
    )
    -- Result: query executed successfully. Took 40ms, 638 rows affected
    Not good 638 clients have not property. I will test this on the server to see if will work and if fix the issue.




    PS: WORKING !!!!! THANK YOU
    Last edited by DeVes; March 27th, 2019 at 07:37 PM.

  10. #10
    Join Date
    August 2010
    Location
    Poland
    Posts
    11

    Thumbs up

    I was have the same problem (info from Client Log):
    Code:
    31.03.2019 18:42:04	SCHandler	Warning	Error while parsing packet: convert error
    31.03.2019 18:42:04	ClientUI	Info	Connect status: Disconnected
    31.03.2019 18:42:04	ClientUI	Info	Disconnected from server, no autoreconnect: convert error
    and this solution worked for me, thanks guys
    I used "SQLite Expert Personal" to run this script on "ts3server.sqlitedb".
    Last edited by tom34; April 1st, 2019 at 09:35 PM.

  11. #11
    Join Date
    March 2019
    Posts
    8
    Hi Tom,

    I'm really happy the query statement help you!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] Disconnected (convert error) server v 3.0.11
    By Bluscream in forum Server Support
    Replies: 24
    Last Post: March 31st, 2016, 07:21 AM
  2. Disconnected from server (convert error)
    By luki2260 in forum Windows
    Replies: 0
    Last Post: December 21st, 2015, 11:00 AM
  3. TeamSpeak PHP Convert Error
    By kmccmk9 in forum Tools / Web Based
    Replies: 0
    Last Post: March 13th, 2015, 03:59 AM
  4. [Resolved] list All Clients delete gameserver serverquery from list
    By thywitness in forum Server Support
    Replies: 9
    Last Post: May 22nd, 2012, 07:12 AM
  5. [Resolved] [BUG] Convert error for everyone on the server and disconnects
    By Slater in forum Bug Reports [EN/DE]
    Replies: 9
    Last Post: May 18th, 2011, 11:05 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
  •