Date Input

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Date Input

Post by bernard.lee »

Hi Sergey,

I have input the date and wanted to be 31/12/9999
However, it appeared 19/01/2038

Is there any solution? Or what is the cause?

I'm using
Apache/2.4.41 (Win64) PHP/7.3.12
MySQL Version: 5.7.28

User avatar
support
Site Admin
Posts: 3268
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Date Input

Post by support »

Dates save in timestamp. 31/12/9999 not supported in php.

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Re: Date Input

Post by bernard.lee »

Hi Sergey,

However I tried using your demo in fact your system able to support the date (see below).
Untitled.png
But mine only accepted the date until 19/01/2038.

Any recommendation or exact version PHP/apache/MySQL can the date be supported.
Please advise. Thank you.

User avatar
support
Site Admin
Posts: 3268
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Date Input

Post by support »

You can read about this issue here https://www.phpclasses.org/blog/package ... tamps.html

And ask your hosting support about it.

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Re: Date Input

Post by bernard.lee »

Hi Sergey,

My host claimed that is "The issue seems to be the like database configuration."

My opinion is unlikely. The config during install is simply the connection database, db name & password only. What other config is required?

I have a question, is this something possible to do with PHP Extensions which is therefore NOT enabled to cause this problem?

Can you also let us know what are the essential extensions needed or the PHP version?
Screenshot 2020-02-08 at 4.58.27 PM.png

User avatar
support
Site Admin
Posts: 3268
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Date Input

Post by support »

The issue that you hosing using 32 bits systems.
Change hosing that use 64 bits

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Re: Date Input

Post by bernard.lee »

Hi Sergey,

I have checked with my hosting, they said something to do with the installation or configuration.

I have also tried using another different hosting that has a similar issue. The date ended at 19-01-2038.

Untitled.png

User avatar
support
Site Admin
Posts: 3268
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Date Input

Post by support »

You can try it on public demo and see it works ok
https://www.rukovoditel.net/demo.php

So issue with hosting configuration.
Attachments
screenshot-demo.rukovoditel.net-2020.02.png

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Re: Date Input

Post by bernard.lee »

Certainly, I have tried your demo with no issue.

Your demo version is "Rukkovoditel 2.3.1" I am not sure does this bug only appeared to your latest version "2.6.1"?

I have consulted many, most say the coding. Would you be good to update the version to see a similar issue that occurred in the latest version?

Date to set/input "31/12/9999"

bernard.lee
Posts: 52
Joined: 14 Apr 2017, 10:50
Name: Bernard Lee
Location: Singapore

Re: Date Input

Post by bernard.lee »

Hi Sergey,

THIS IS CONFIRMED.
I have installed the version "Rukkovoditel 2.3.1" there is not any issue with the date input "31/12/9999".

The latest version "Rukkovoditel 2.6.1" has a problem. Can you look into this matter and solve it.

Post Reply