CSPro Users Forum

Hello,
This is my first post requesting help for installing csweb on xampp on local computer.
I'm having an error "Failed to connect to database. SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_time'" during installation.
The following are the steps I made.
1. Run Apache and MySQL (Xampp).
2. Go to phpMyAdmin and create database (test_csweb).
3. Create user (same as database name) and gave all privileges.
4. Download the CSWeb zip file and extract the files to Xampp root/htdocs/CSWeb folder.
5. From browser, go to /localhost/csweb/setup/. Everything is OK in CSWeb: Server Requirements. So I clicked "Next"
6. In CSWeb: Configuration page, I type the following

• database name - test_csweb
  Hostname - localhost
  Database username - root
  Database password -
  CSWeb admin password - test_csweb
  Timezone - Asia/Yangon
  Maximum execution time - 300
  Path to files directory - D:\xampp\htdocs\CSWeb\files ("my xampp is on D:\")
  CSWeb API URL - http://localhost/csweb/api/

7. Click "Next" and get error.

Please help me installing csweb.
Thank you everyone for helping.

Please download the latest CSWeb from here: https://www.census.gov/data/software/cspro.html

We just a fixed a problem that can cause the error that you are seeing.