Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    2
    Plugin Contributions
    0

    Default Installation error 1064 when creating database

    When I am installing Zen Cart I get the following error after clicking on Save Database setup.

    1064 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 '-configuration' at line 2
    in:
    [select configuration_key as cfgkey, configuration_value as cfgvalue from zen-configuration]

    I cant find the correct file to edit. (I don't know what it is called)

    regards

    Tony Prodger

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Installation error 1064 when creating database

    1. What version of Zen Cart are you trying to install?

    2. When you're doing the database-setup portion, DO NOT use a hyphen as part of the table-prefix. You used "zen-". A better choice would be "zen_" or none at all.

    I was pretty sure we had addressed this issue in the v1.3.x series so that you are told that you've used an invalid character and given a chance to fix it before loading the database.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Dec 2005
    Posts
    2
    Plugin Contributions
    0

    Default Re: Installation error 1064 when creating database

    Many apologies for not replying sooner but I have only just got back from a trip away.

    I have reinstalled and left the extension blank (though I thought that I had used zen_).

    The installation worked well.

    Many thanks for your help

    Tony Prodger

 

 

Similar Threads

  1. 1064 syntax error when creating account
    By mayleine in forum General Questions
    Replies: 3
    Last Post: 2 Jan 2011, 11:31 AM
  2. 1064 SQL Syntax error when upgrading database from 1.3.8 to 1.3.9
    By pioupioun in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 23 Aug 2010, 06:26 AM
  3. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  4. 1064 Error on installation V1.3.7
    By dbunch in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 1 Jan 2007, 07:45 PM
  5. 1064 Error - Installation problem
    By Terry111 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 22 Jul 2006, 12:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR