Installation problem at system config step

[lastcowboy]

I keep getting a

Error while inserting data into the database:
'INSERT INTO `ps_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`) VALUES (1, 7, 23, 1)'
Field \'date_add\' doesn\'t have a default value(Error: : 1364)

[TropischBruin]

Is this a linux or a windows server?

[lastcowboy]

windows server.

i got around this issue by going to the install folder > sql > db_settings_extends.sql

i changed the following lines in 184 185

INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, `date_add`) VALUES (1, 7, 23, 1, NOW());
INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, `date_add`) VALUES (1, 9, 0, 1, NOW());

for the install to work properly.

Please note i was using prestashop 1.1

Hope this helps other people.