A Project for Chronicle 4 based on L2JServer.


    Negative online time

    Share

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Negative online time

    Post  Neeeeeeeeeel.- on 6th January 2014, 05:38

    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: Negative online time

    Post  DnR on 6th January 2014, 14:03

    You aren't using Navicat, right?

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Re: Negative online time

    Post  Neeeeeeeeeel.- on 6th January 2014, 15:08

    DnR wrote:You aren't using Navicat, right?
    No, it's an old version of phpmyadmin. Why?
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: Negative online time

    Post  DnR on 6th January 2014, 17:06

    There could be something wrong with this.
    Variable "onlinetime" is set as decimal from table.
    If by any chance phpmyadmin turned it into "int" for any strange reason, it would only support a certain number, and once reached maximum, it would turn negative.

    Also, is that old version trustworthy?
    It could be the reason for your spawn errors, as well.

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Re: Negative online time

    Post  Neeeeeeeeeel.- on 6th January 2014, 18:46

    DnR wrote:There could be something wrong with this.
    Variable "onlinetime" is set as decimal from table.
    If by any chance phpmyadmin turned it into "int" for any strange reason, it would only support a certain number, and once reached maximum, it would turn negative.

    Also, is that old version trustworthy?
    It could be the reason for your spawn errors, as well.
    phpMyAdmin-2.10.3 it's the one that cames with AppServ 2.5.1

    I'm not at home so I can't check if the column is int or decimal. I will update later.

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Re: Negative online time

    Post  Neeeeeeeeeel.- on 7th January 2014, 06:56

    I checked and the column type is decimal.

    Also I updated my OOOOOLD phpMyAdmin
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: Negative online time

    Post  DnR on 7th January 2014, 17:54

    Column type is decimal, and variable onlineTime is long, just as they both should.
    I can't tell for sure what caused time to turn negative.
    The most legit explanation is that computer time change (it also caused bad spawns) affected time of Java System, as well.
    In the core, System.currentTimeInMillis() is applied to variable onlineTime, so fixing computer could possibly fix this.
    If problem persists, i suggest you check a specific record regularly.

    Sponsored content

    Re: Negative online time

    Post  Sponsored content


      Current date/time is 23rd October 2017, 05:19