Jump to content
Sign in to follow this  
SRD75

Install: Error while inserting data in the database

Recommended Posts

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

Bump. No one has the skills to help me with this?

Share this post


Link to post
Share on other sites

I guess any errors members of the public receive are not important.

Share this post


Link to post
Share on other sites

I inserted the .sql directly using PHPMyAdmin, and I now receive the error:

Bad SubDomain SQL query.

Share this post


Link to post
Share on other sites

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

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

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
Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More