Jump to content
  • 0
SRD75

Install: Error while inserting data in the database

Question

PrestaShop 1.4.0.17 Installer 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?

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

I saw on this thread someone mention the _subdomain table in the database.

My _subdomain table had no entries, so I inserted one with ID=1, and the subdomain without the full domain.

I now receive the following error when I load the home page of my PrestaShop:

Server error
The webpage at http://www.steve.doig.com.au/shop/ is currently unavailable. It may be overloaded or down for maintenance.

This occurs even if I load the /index.php page directly.

I have checked my settings.inc.php page and it all looks okay.

Share this post


Link to post
Share on other sites
  • 0

I dropped all the presta shop tables, ran the install again and chose basic, and received the error:

Error while inserting data in the database:
'CREATE TABLE `ps_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)

Share this post


Link to post
Share on other sites
  • 0

The sql files had a lot of ENGINE= entries that were incorrect or incomplete - I removed them.

I try again, click Next, the page loads for a couple of second, and then nothing else happens. If I try again, I receive a message:

A Prestashop database already exists, please drop it or change the prefix.

and I can't get out of this loop.

Is there a manual way to proceed?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×