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

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
bmuganda
Posts: 37
Joined: January 18th, 2018, 11:57 am

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

Post 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
Attachments
csweb_snip2.JPG
csweb_snip2.JPG (78.73 KiB) Viewed 3119 times
csweb_snip.JPG
csweb_snip.JPG (92.79 KiB) Viewed 3119 times
bmuganda
Posts: 37
Joined: January 18th, 2018, 11:57 am

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

Post by bmuganda »

Finally I got a hack around this. I can share to whoever is intrerested
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

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

Post by josh »

Post Reply