: PrestaShop install SQL error 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+

Posted in: #Prestashop #Sql #WebPlatformInstaller

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?

10.01% popularity Vote Up Vote Down

: How to accomplish a rich snippet with Twitter? I would like to enhance my CTR for my pages and/or posts. When I publish these I tend to Tweet them so they become known. When doing some research

@Rambettina238

Posted in: #Google #Seo #Serps #SocialMedia

1 Comments

: Display Google Custom Search results on your own site Is there a way for Google's Custom Search engine to show it's results on a page on your website? On a custom page which you put on your

@Rambettina238

Posted in: #GoogleCustomSearch

3 Comments

: Microformatting questions & answers - Semantic Web 3.0? With the introduction of the Semantic Web we (SEOs) have the opportunity to mark-up our content in such a way that robots/crawlers have

@Rambettina238

Posted in: #RichSnippets #SearchEngines #SemanticWeb #StructuredData

2 Comments

: Wordpress CSS formating issue A don't understand why the sidebar of my Wordpress blog does not have consistent formatting for H3 tags. There are two PHP-generated un-styled H3 tags in the

@Rambettina238

Posted in: #Css #Wordpress

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Carla537

I guess your the one here ?
www.prestashop.com/forums/topic/99317-install-error-while-inserting-data-in-the-database/
Have tried using the latest version ?

A lot of bugs have been corrected after 1.4.0.17, this is one of the reasons they recommend to install the latest version and also for the security fixes.

Current Version is PrestaShop v1.4.7 and the changelog

From www.prestashop.com/en/developers-versions

We strongly recommend to use the latest version of PrestaShop to build
an online store.

To answer your question, I think the problem is that you have magic_quotes turned on in your php.ini

You have also to make sure your mysql user have sufficient privileges.

ref : www.prestashop.com/forums/topic/124238-solved-installation-stucked-on-step-3-installation-type/

10% popularity Vote Up Vote Down

Feed

: PrestaShop install SQL error 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+

More posts by @Rambettina238

: How to accomplish a rich snippet with Twitter? I would like to enhance my CTR for my pages and/or posts. When I publish these I tend to Tweet them so they become known. When doing some research

: Display Google Custom Search results on your own site Is there a way for Google's Custom Search engine to show it's results on a page on your website? On a custom page which you put on your

: Microformatting questions & answers - Semantic Web 3.0? With the introduction of the Semantic Web we (SEOs) have the opportunity to mark-up our content in such a way that robots/crawlers have

: Wordpress CSS formating issue A don't understand why the sidebar of my Wordpress blog does not have consistent formatting for H3 tags. There are two PHP-generated un-styled H3 tags in the

Login to post a comment!

1 Comments

Back to top | Use Dark Theme