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 6 of 6
  1. #1
    Join Date
    October 2010
    Location
    Germany
    Posts
    67

    clients.client_lastconnected isn't updated anymore - why?

    For example i have a client with ID X - this client does have these statistics:

    Click image for larger version. 

Name:	1.png 
Views:	62 
Size:	4.7 KB 
ID:	12096

    First Connection: 11.03.2014 19:04:04
    Online Since: 07.03.2015 17:18:56

    Now if i take a look directly in the database (mysql) i got these values:

    Click image for larger version. 

Name:	2.png 
Views:	67 
Size:	2.5 KB 
ID:	12097

    client_lastconnected = 02.08.2014 17:41:34

    Click image for larger version. 

Name:	3.png 
Views:	62 
Size:	2.3 KB 
ID:	12098

    client_created = 11.03.2014 19:04:04

    So why does client_lastconnected differ from the real "Online Since:" date / time ?


    Greetings, FireEmerald
    Last edited by FireEmerald; March 21st, 2015 at 10:42 AM.

  2. #2
    Join Date
    October 2010
    Location
    Germany
    Posts
    67
    Nobody knows why this happens? Someone of the staff please take a look at this.

  3. #3
    Join Date
    June 2008
    Posts
    18,513
    We don't know either what's wrong in your database or clock on the server.
    Is this for all of your users?
    What happens in a new databse?
    Is your server clock working correctly?
    Is the server updated to 3.0.11.2 ?
    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?

  4. #4
    Join Date
    October 2010
    Location
    Germany
    Posts
    67
    Quote Originally Posted by dante696 View Post
    We don't know either what's wrong in your database or clock on the server.
    The clock on my server is correct:
    • [email protected] ~ # date
      Sat Mar 21 11:25:45 CET 2015
      Code:
      11:25:40	SELECT UTC_TIMESTAMP() FROM teamspeak.clients LIMIT 1	1 row(s) returned	0.047 sec / 0.000 sec
      2015-03-21 10:25:44

    Quote Originally Posted by dante696 View Post
    Is this for all of your users?
    It's kind of confusing:
    If i take a look at the database and collect the following data:
    Code:
    SELECT *, from_unixtime(client_lastconnected) FROM teamspeak.clients ORDER BY client_id DESC;
    The highest client_id is 22345.

    If i order the results by date of client lastconnected:
    Code:
    SELECT *, from_unixtime(client_lastconnected) FROM teamspeak.clients ORDER BY client_lastconnected DESC;
    Then the latest entry is 2014-08-02 17:59:27 (1406995167).

    If i want to take a look at a new client in the teamspeak like a guy which connected first on 31.01.2015 11:05:02 (he has the Database ID:25278) i got no result at all:
    Click image for larger version. 

Name:	fQaB7Bw.png 
Views:	45 
Size:	9.7 KB 
ID:	12175
    Code:
    11:16:14	SELECT * FROM teamspeak.clients WHERE client_id = '25278' LIMIT 0, 1000	0 row(s) returned	0.047 sec / 0.000 sec
    Quote Originally Posted by dante696 View Post
    What happens in a new databse?
    • I don't know - i didn't tested it yet because i need my database not a new one
    • UPDATE: Checked this - all is working well and like expected in a clean database.

    Quote Originally Posted by dante696 View Post
    Is the server updated to 3.0.11.2 ?
    • The server is running under version: 3.0.11.2 (15.12.2014 15:43:52) on Linux.


    MySQL Client: MySQL Workbench 6.1.7.11891 build 1788
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	schema_inspector.jpg 
Views:	58 
Size:	161.6 KB 
ID:	12174   Click image for larger version. 

Name:	table_inspector.jpg 
Views:	48 
Size:	58.1 KB 
ID:	12176  
    Last edited by FireEmerald; March 21st, 2015 at 12:47 PM.

  5. #5
    Join Date
    October 2010
    Location
    Germany
    Posts
    67
    Found the error and corrected it. Thanks.

  6. #6
    Join Date
    June 2008
    Posts
    18,513
    And what was it?
    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?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. cliententerview add client_lastconnected to data
    By Toine in forum Suggestions and Feedback
    Replies: 2
    Last Post: October 19th, 2014, 04:47 PM
  2. client_lastconnected & error db
    By Death_Balgor in forum General Questions
    Replies: 1
    Last Post: October 18th, 2013, 01:48 PM
  3. Replies: 2
    Last Post: September 12th, 2011, 01:06 PM
  4. Replies: 2
    Last Post: April 13th, 2010, 09:53 AM
  5. Updated Client can NOT join while old clients could?
    By willy_sunny in forum General Questions
    Replies: 3
    Last Post: January 8th, 2010, 02:45 PM

Posting Permissions

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