info Preparing for 19 January 2038 bug?

[something else]

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:

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.

[thunderwap]

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:

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

[GumSlone]

2038 running lava wml version (retro nostalgia on a nokia 3310 phone)

[CreativityKills]

Wow GumSlone you kept this site running? Damn! GumSlone