oscommerce 2.3.4 on localhost wamp 3.0.0

[Sdubara]

Hello everyone. Im having a problem installing oscommerce 2.3.4 on local wamp server:
-Created database named "oscommerce" in phpmyadmin

Database server: localhost

username: root

password: root

database name: oscommerce.
 

And it shows me error ===>

There was a problem importing the database. The following error had occured:

Invalid default value for 'customers_dob'

Please verify the connection parameters and try again.

 

PHP Version 5.6.16

 

PHP Settings register_globals Off magic_quotes Off file_uploads On session.auto_start Off session.use_trans_sid Off

 

Required PHP Extensions MySQL

 

Recommended PHP Extensions GD cURL OpenSSL

Is there any tricks with localserver wamp and oscommerce 2.3.4 ?

Thanks alot!

[firstbizsoft]

Hi Sasa,

-Created database named "oscommerce" in phpmyadmin

Database server: localhost

username: root

password:

database name: oscommerce.

 

The password label blank.

[MrPhil]

The only reason anyone should install osC on a PC *AMPP server is to play with it when they don't have a real commercial server to work on yet. Never try to set up a real live site on your home PC -- the hackers will eat you alive, since they know all the security ins and outs that you don't. If you have a real (commercial) server for your site, set up any new osC installation in a private test directory, with no links to it from the outside world. It's much better to experiment on your real server, rather than fine tuning everything on a PC server and then finding out the different installations are incompatible when you try to upload to the server. To edit a file on your PC and upload it with an already-open FTP program takes only a few seconds more than to do everything on your PC (and then spend hours figuring out why the different PHP, MySQL, and server versions has broken your site).

[gjpinzino]

I just went through the exact same problem today. The issue is MySQL in strict mode rejects the default value '0000-00-00 00:00:00'. Open install/oscommerce.sql. Find the customers_dob and change the default value to '1970-01-01 00:00:01'. Save the file and try installing. The error should go away.