Vote to Improve PrestaShop

PrestaShop Forum: Build a free online shop. Count on the Community!

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum: Build a free online shop. Count on the Community!

Jump to content

 
Photo

Install: Error while inserting data in the database


  • Please log in to reply
6 replies to this topic
SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 26 March 2011 - 06:24 AM

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?

SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 28 March 2011 - 05:03 AM

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

SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 04 April 2011 - 07:42 AM

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

Bad SubDomain SQL query.



SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 04 April 2011 - 07:28 AM

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

SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 04 April 2011 - 07:55 AM

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.

SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 04 April 2011 - 11:20 AM

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)



SRD75

    PrestaShop Apprentice

  • Members
  • PipPip
  • 28 posts

Posted 04 April 2011 - 01:01 PM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users