Cms last update date error

[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 !!!

[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'

[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 !!!!

[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.

[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

[amir2314]

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 ?

[Pablo]

What is the problem after you have changed the database structure?

[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

[Pablo]

Maybe your server needs a different date format?

[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

[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.

[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