PDA

View Full Version : Subscription Length maxed out to year 2038


DCD.RB
01-14-2017, 07:57 PM
Hello,
On my board, years have options to subscribe up 100 years. 1000 & 9000 are just jokes.

But I've noticed anyone who subscribes for 100 years, the system automatically sets them to expire by 2038. If I manually edit the number, it changes to 2106. Which is fine, more than enough.

But why would the automatic subscription max out at 2038 and require a manual edit? And how could I resolve it?

Thank you

Dave
01-14-2017, 08:58 PM
<a href="https://en.wikipedia.org/wiki/Year_2038_problem" target="_blank">https://en.wikipedia.org/wiki/Year_2038_problem</a>

That will explain it all. You might be able to "fix" it by changing it to a BIGINT in the database.

DCD.RB
01-14-2017, 09:04 PM
Sorry, what do I need to change exactly?

Paul M
01-14-2017, 10:04 PM
Messing with your database for a joke is probably not a good idea. Just limit your subscriptions to 20 years.

DCD.RB
01-14-2017, 10:40 PM
100 years isn't a joke. The 1000 & 9000 are.

It's suppose to be the "life time" option. And I noted the 100 causes the issue. In fact no one has subscribed for 1000 or 9000.

Paul M
01-15-2017, 12:21 PM
Then I suggest you just use 20 years for lifetime (or more specifially, set them to 31 Dec 2037).

If you are still around in 15+ or so years, running vB4, you can start thinking about a long term fix.