Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    156
    Plugin Contributions
    0

    red flag SQL Error When Importing Database

    I'm moving the shopping cart to a new server. I did everything as stated in the tutorial however when I go to import the database I get the error below. I did notice that the server the cart was on was using Zen Cart version 1.3.9d and the new server uses 1.3.9g. Could that be the issue? What do I do?

    Error
    SQL query:

    CREATE TABLE "zen_address_book"(

    "address_book_id"int( 11 ) NOT NULL ,
    "customers_id"int( 11 ) NOT NULL DEFAULT '0',
    "entry_gender"char( 1 ) NOT NULL DEFAULT '',
    "entry_company"varchar( 64 ) DEFAULT NULL ,
    "entry_firstname"varchar( 32 ) NOT NULL DEFAULT '',
    "entry_lastname"varchar( 32 ) NOT NULL DEFAULT '',
    "entry_street_address"varchar( 64 ) NOT NULL DEFAULT '',
    "entry_suburb"varchar( 32 ) DEFAULT NULL ,
    "entry_postcode"varchar( 10 ) NOT NULL DEFAULT '',
    "entry_city"varchar( 32 ) NOT NULL DEFAULT '',
    "entry_state"varchar( 32 ) DEFAULT NULL ,
    "entry_country_id"int( 11 ) NOT NULL DEFAULT '0',
    "entry_zone_id"int( 11 ) NOT NULL DEFAULT '0',
    PRIMARY KEY ( "address_book_id" ) ,
    KEY "idx_address_book_customers_id_zen"( "customers_id" ) ) AUTO_INCREMENT =8;



    MySQL said:

    #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 '"zen_address_book" (
    "address_book_id" int(11) NOT NULL,
    "customers_id" int(' at line 1
    ##############################___
    Stacee Edwards
    Stacee Edwards

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: SQL Error When Importing Database

    Please see your other post ... you only need just one ...
    http://www.zen-cart.com/forum/showthread.php?t=167443
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. v139h Error 1044 when importing DATABASE
    By Mthirty5 in forum Installing on a Windows Server
    Replies: 11
    Last Post: 9 Jan 2016, 04:27 PM
  2. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  3. SQL Errors when importing to new database - #1062 - Duplicate entry '3' for key 1
    By countingsheep in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 17 Sep 2009, 09:43 PM
  4. SQL Error Importing Database
    By esugrue in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 15 Oct 2008, 05:02 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