Page 1 of 1

Urgently Need Help!!!Error Connection of CSWEB to remote server

Posted: January 19th, 2018, 3:31 am
by bmuganda
Hi guys,

I am trying to set up CSWEB on linode server. The server seems to meet all the requirements for installation of csweb. However it cannot connect to mysql database. It throws an error.

Code: Select all

Failed to connect to database. SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_time'
[/i]. See the attached screenshots as well.

Connection to mysql is active, I have tried connecting remotely from another mysql client and it works pretty well. Any help I will appreciate so much.

Thanks

Boniface

Re: Urgently Need Help!!!Error Connection of CSWEB to remote server

Posted: January 19th, 2018, 6:42 am
by bmuganda
Finally I got a hack around this. I can share to whoever is intrerested

Re: Urgently Need Help!!!Error Connection of CSWEB to remote server

Posted: January 19th, 2018, 7:02 am
by josh