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
Date Input
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
- support
- Site Admin
- Posts: 6186
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Input
Dates save in timestamp. 31/12/9999 not supported in php.
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date Input
Hi Sergey,
However I tried using your demo in fact your system able to support the date (see below). 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.
However I tried using your demo in fact your system able to support the date (see below). 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.
- support
- Site Admin
- Posts: 6186
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Input
You can read about this issue here https://www.phpclasses.org/blog/package ... tamps.html
And ask your hosting support about it.
And ask your hosting support about it.
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date Input
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?
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?
- support
- Site Admin
- Posts: 6186
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Input
The issue that you hosing using 32 bits systems.
Change hosing that use 64 bits
Change hosing that use 64 bits
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date Input
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.
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.
- support
- Site Admin
- Posts: 6186
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Input
You can try it on public demo and see it works ok
https://www.rukovoditel.net/demo.php
So issue with hosting configuration.
https://www.rukovoditel.net/demo.php
So issue with hosting configuration.
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date Input
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"
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"
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date Input
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.
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.