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

    Default Database setup failed

    Hi All,

    This error has been frustrating me for sometime, i have almost tried everything but with no success.. Also cant ind anything on google regarding this error..

    Trying to install fresh 1.3.9h on mysql version 5.1.56, php 5.3.6, apache 2.2.19

    Installation In Progress...

    ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

    ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
    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 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', '6', '0', now(' at line 1
    in:
    [INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Tax Basis', 'MODULE_SHIPPING_FLAT_TAX_BASIS', 'Shipping', 'On what basis is Shipping Tax calculated. Options are
    Shipping - Based on customers Shipping Address
    Billing Based on customers Billing addresid, sort_order, date_added) VALUES ('Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', '6', '0', now());]

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Database setup failed

    It is possible that one or more of the files in your download of ZC sfotware have become corrupted.

    As you are not making any progress, then my advice is to do the following.

    1. Get another copy of the ZC software and remove the old copy from your machine.

    2. On your host c-panel, or via phpMyAdmin, DROP every table in the database. Empty it out completely. You may even want to DELETE that database, and create a brand new one.

    3. Send all the folders of ZC back to the server, OVERWRITING those that are there. (Or you could delete those currently on the server).

    Basically, start from scratch.
    19 years a Zencart User

 

 

Similar Threads

  1. database setup - failed connection
    By marius2012 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 29 Jul 2012, 11:22 AM
  2. v150 Database Setup Issue: Connection to Database failed, on iPage
    By tempoart in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jul 2012, 07:43 AM
  3. database setup - failed connection
    By bx32 in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 25 Oct 2011, 06:38 AM
  4. Install blank at Zen Cart™ Setup - Database Setup
    By ChamplainPictures in forum Installing on a Linux/Unix Server
    Replies: 7
    Last Post: 14 Feb 2008, 05:38 AM
  5. Failed to create tables under database setup step.
    By samcyh in forum Installing on a Windows Server
    Replies: 7
    Last Post: 3 Nov 2006, 11:56 PM

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