PrestaShop install SQL error

Posted by Steve on Pro Webmasters See other posts from Pro Webmasters or by Steve
Published on 2011-04-05T01:00:52Z Indexed on 2012/06/08 16:50 UTC
Read the original article Hit count: 241

I am trying to install PrestaShop 1.4.0.17, and reach Step 3.

I enter database information, which tests okay, and I choose the second option: Full mode: includes 100+ additional modules and demo products (FREE too!).

I choose Next, and receive the error:

Error while inserting data in the database:
‘CREATE TABLE `shop_county_zip_code` ( `id_county` INT NOT NULL , `from_zip_code` INT         NOT NULL , `to_zip_code` INT NOT NULL , PRIMARY KEY ( `id_county` , `from_zip_code` , `to_zip_code` ) ) ENGINE=’
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’\’ at line 6(Error: : 1064)

This happens if I use either MyISAM, or InnoDB. Why is this happening?

This also happens if I drop all database tables, and try again in simple mode.

Is there a manual installation method?

© Pro Webmasters or respective owner

Related posts about sql

Related posts about web-platform-installer