Subscription Length maxed out to year 2038

[DCD.RB]

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]

<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]

Sorry, what do I need to change exactly?

[Paul M]

Messing with your database for a joke is probably not a good idea. Just limit your subscriptions to 20 years.

[DCD.RB]

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]

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.