[Solved] Step 3 Installation Error : 1364

[safewithyou247]

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)

Above is the error that I get when trying to install PS v1.1 on MySQL 5.1. Can anyone assist me with this issue?

Thanks,

[safewithyou247]

The error seems to be due to the fact that I am using Full Mode and not Simple Mode. Browse to \install\sql\db_settings_extends.sql. Open the file and edit the following lines of code.

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

Replace them with the below code. And boom! You fixed your problem.

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());

[rajvelu]

Thankyou
your solution worked..

[safewithyou247]

Glad I could help.

[Malik Imran Amir]

This is my first encounter of local installation. I tried to install everything and was caught up in this.

I have
1. PHP Version 5.2.8
2. OS. Microsoft Windows XP Professional SP3
3. MySQL Version: 5.0.67-community-nt

I wish to know why i got this error.

[safewithyou247]

You have one of two options.
1. Use Simple Mode for installation
2. Follow the steps that I have outlined above.