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: 244
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