Page 1 of 1
Cms last update date error
Posted: Sun Feb 06, 2022 10:48 am
by amir2314
Hi i uploaded my cms admin to my host and when i enter my user and pass to login page called me this
Hey invalid error last_update_date
I set tge default value to 0000-000-00 00:00:00 but its not working !!!
Re: Cms last update date error
Posted: Sun Feb 06, 2022 10:52 am
by Pablo
This is most likely a server configuration issue.
For some servers you may need to set the default date of the database field to
'1970-01-01 00:00:01'
Re: Cms last update date error
Posted: Sun Feb 06, 2022 11:11 am
by amir2314
I set default value to 1970-01-01 00:00:01 but when i going to sql server set automaticaly this to 1970-01-01 03:30:01 !!!!
Re: Cms last update date error
Posted: Sun Feb 06, 2022 11:19 am
by Pablo
This has nothing to do with WWB.
But it does not make any difference for the behavior of the CMS.
This is server related.
Re: Cms last update date error
Posted: Sun Feb 06, 2022 11:47 am
by amir2314
I know its not wwb bug cause ita working perfect with wamp or xamp server !!!
How can i fix with my server ? The server host is Cpanel 100.0.9 . phpmyadmin 5.5.1
Re: Cms last update date error
Posted: Sun Feb 06, 2022 12:26 pm
by amir2314
Pablo wrote: Sun Feb 06, 2022 11:19 am
This has nothing to do with WWB.
But it does not make any difference for the behavior of the CMS.
This is server related.
My host is linux is it relate for this ?
Re: Cms last update date error
Posted: Sun Feb 06, 2022 1:32 pm
by Pablo
What is the problem after you have changed the database structure?
Re: Cms last update date error
Posted: Sun Feb 06, 2022 2:23 pm
by amir2314
When i change the value of timestamp default field on my data base to 1970-01-01 00:00:01 i see this message : query error #1067 - invalid default value for "last_update_date
Also when i restore bmanualy sql to my host . Timestamp default field automaticaly changeing to this : 1970-01-01 03:30:01
I dont know whay !!!
Even i set the sql mode to allow invalid date but not working too
Re: Cms last update date error
Posted: Sun Feb 06, 2022 2:47 pm
by Pablo
Maybe your server needs a different date format?
Re: Cms last update date error
Posted: Sun Feb 06, 2022 2:53 pm
by amir2314
I change the timestamp to datetime and its set to 1970-01-01 00:00:01
But whebn i go to cmsadmin panle when i enter my user and pas
I see invalid query Last_update_date
Re: Cms last update date error
Posted: Sun Feb 06, 2022 3:39 pm
by Pablo
Sorry, but I cannot help you with the server configuration.
To be able to help you with this I need to know the all server settings and even then it may also take me a lot of time to figure out what is wrong.
Re: Cms last update date error
Posted: Sun Feb 06, 2022 5:51 pm
by amir2314
I fix this with this methode
I change timecode to datetime with the php file createed with wwb and set the stracture time on sql to datetime
Set 1970-01-01 00:00:01 to boath of subject : 1 php cmsadmin 2 sql structure
And its work
