Problem installing csweb on xampp

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
khantmg
Posts: 1
Joined: March 20th, 2018, 12:32 am

Problem installing csweb on xampp

Post by khantmg »

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.
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Problem installing csweb on xampp

Post by josh »

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.
Post Reply