Preparing for 19 January 2038 bug?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    info Preparing for 19 January 2038 bug?

    On 19 January 2038 after 03:14:07 a lot of scripts will stop working due to a unix date being a higher integer than a 32 bit signed integer.
    Read up here: https://en.wikipedia.org/wiki/Year_2038_problem

    Eg:
    here is a well known database table:
    Code:
    CREATE TABLE `ibwf_blogs` (
    `id` int(100) NOT NULL,
    `bowner` int(100) NOT NULL DEFAULT 0,
    `bname` varchar(50) NOT NULL,
    `btext` blob NOT NULL,
    `bgdate` int(100) NOT NULL DEFAULT 0
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    this will fail as it saves php time() into bgdate as an INT

    You can test this out for yourself by trying to insert:
    2147546754 into bgdate

    So preparing yourself for this bug, could save you a headache in the future ... instead of lots of your scripts all failing at once.

    #2
    Originally posted by something else View Post
    On 19 January 2038 after 03:14:07 a lot of scripts will stop working due to a unix date being a higher integer than a 32 bit signed integer.
    Read up here: https://en.wikipedia.org/wiki/Year_2038_problem

    Eg:
    here is a well known database table:
    Code:
    CREATE TABLE `ibwf_blogs` (
    `id` int(100) NOT NULL,
    `bowner` int(100) NOT NULL DEFAULT 0,
    `bname` varchar(50) NOT NULL,
    `btext` blob NOT NULL,
    `bgdate` int(100) NOT NULL DEFAULT 0
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    this will fail as it saves php time() into bgdate as an INT

    You can test this out for yourself by trying to insert:
    2147546754 into bgdate

    So preparing yourself for this bug, could save you a headache in the future ... instead of lots of your scripts all failing at once.
    2038 year? who knows wats going to be after 18 years.
    may be i won't be living on earth due to health problems.

    though all the best to the ppl who going to use lava scripts till 2038 year
    sigpic

    WANT GOOD CHEAP HOSTING WITH 99% UPTIME? THEN PM ME FOR DETAILS!!

    Comment


      #3
      2038 running lava wml version (retro nostalgia on a nokia 3310 phone)
      Advertise your mobile site for FREE with AdTwirl

      Comment


        #4
        Wow GumSlone you kept this site running? Damn!
        GumSlone
        Administrator
        GumSlone

        Comment

        Working...
        X