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

    red flag Moving Cart to New Server

    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

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

    Default Re: Moving Cart to New Server

    Where are the double quote marks coming from?

    Those are causing an error ... are they in your sql file?
    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!]
    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. moving zen cart to a new server, need help
    By xoxomeowmixoxo in forum General Questions
    Replies: 19
    Last Post: 28 Feb 2011, 03:34 PM
  2. Moving Zen-Cart to a new server/hosting company
    By lhutzley in forum Installing on a Linux/Unix Server
    Replies: 10
    Last Post: 15 Jun 2010, 12:56 AM
  3. moving cart to a new domain (same server)
    By iddy in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 25 May 2010, 12:04 AM
  4. cart not working when moving to a new server
    By webdev316 in forum General Questions
    Replies: 4
    Last Post: 30 Oct 2008, 03:35 AM
  5. Can't run my cart after moving to new server
    By alhakeem2001 in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 12 Oct 2008, 03:01 PM

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