Page 1 of 2

Date Input

Posted: 01 Feb 2020, 12:28
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

Re: Date Input

Posted: 01 Feb 2020, 15:16
by support
Dates save in timestamp. 31/12/9999 not supported in php.

Re: Date Input

Posted: 01 Feb 2020, 17:05
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.

Re: Date Input

Posted: 01 Feb 2020, 18:08
by support
You can read about this issue here https://www.phpclasses.org/blog/package ... tamps.html

And ask your hosting support about it.

Re: Date Input

Posted: 08 Feb 2020, 13:01
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

Re: Date Input

Posted: 08 Feb 2020, 14:25
by support
The issue that you hosing using 32 bits systems.
Change hosing that use 64 bits

Re: Date Input

Posted: 22 Feb 2020, 19:29
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

Re: Date Input

Posted: 22 Feb 2020, 20:37
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.

Re: Date Input

Posted: 23 Feb 2020, 06:14
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"

Re: Date Input

Posted: 23 Feb 2020, 06:35
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.