6 replies to this topic

[SRD75]

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:

Quote

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?

[SRD75]

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

[SRD75]

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

[SRD75]

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

Quote

Bad SubDomain SQL query.

[SRD75]

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:

Quote

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.

[SRD75]

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

Quote

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)

[SRD75]

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:

Quote

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?