Trouble importing data

[isaacr25]

Hi guys,
I'm following directions using this article:
http://www.zen-cart.com/wiki/index.p...Switch_Servers

When I try importing my data (data exported from my "old" domain, last step in step 5), I get the following error. Please advise. Thanks.

Error
SQL query:

--
-- Dumping data for table `address_book`
--
INSERT INTO `address_book` ( `address_book_id` , `customers_id` , `entry_gender` , `entry_company` , `entry_firstname` , `entry_lastname` , `entry_street_address` , `entry_suburb` , `entry_postcode` , `entry_city` , `entry_state` , `entry_country_id` , `entry_zone_id` )
VALUES (

'1', '1', 'm', , 'John', 'Doe', 0x3131312054657374204c616e65, '', '31000', 'Nowhere', '', '223', 19
);



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 ' 'John', 'Doe', 0x3131312054657374204c616e65, '', '31000', 'Nowhere', '', '223',' at line 2

[DrByte]

If you look at the data: '1', '1', 'm', , 'John' ... you'll see that there are two commas with no data in between. This is where the company name should appear in quotes.
How did that go missing?

Either you have a bad backup or someone/something has made incorrect edits to your backup SQL file and removed the information. Did you do a search/replace on the file for some reason?

I suggest you start with another backup...

[kobra]

If using phpmyadmin to create the backup are you including these options

Structure
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value

Add CREATE PROCEDURE / FUNCTION

Data
Complete inserts
Extended inserts
Maximal length of created query

Use hexadecimal for binary fields

DrByte to the rescue

[isaacr25]

If you look at the data: '1', '1', 'm', , 'John' ... you'll see that there are two commas with no data in between. This is where the company name should appear in quotes.
How did that go missing?

Either you have a bad backup or someone/something has made incorrect edits to your backup SQL file and removed the information. Did you do a search/replace on the file for some reason?

I suggest you start with another backup...

I don't believe that this information was entered during the install, so it never entered the database. I'll try entering it in admin and then doing another backup. This should do it, correct?

[isaacr25]

Ok,
Never mind my last post. The company info IS in zen cart admin. I did another update using the recommended settings, and I still get the same error. What else could it be?

[DrByte]

Are you using phpMyAdmin to do the restore? If not, you should.
Don't use SQL Patch tool for database restores. It's not designed for that.

[isaacr25]

Dr. Byte,
Yes, I am usingn phpMyAdmin for all my database tasks.

Comment:
On the new installation of zen cart, I left the Company Name, address etc as the default. Could this have something to do with it? Thanks.

[DrByte]

On the new installation of zen cart, I left the Company Name, address etc as the default. Could this have something to do with it? Thanks.

No, that would have nothing to do with customer address records completely missing company field data during a database export.

[isaacr25]

Any more ideas as to what I can do?

[DrByte]

--
-- Dumping data for table `address_book`
--
INSERT INTO `address_book` ( `address_book_id` , `customers_id` , `entry_gender` , `entry_company` , `entry_firstname` , `entry_lastname` , `entry_street_address` , `entry_suburb` , `entry_postcode` , `entry_city` , `entry_state` , `entry_country_id` , `entry_zone_id` )
VALUES (

'1', '1', 'm', , 'John', 'Doe', 0x3131312054657374204c616e65, '', '31000', 'Nowhere', '', '223', 19
);

Is that how your export file reads?
What does the next line say?