Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problems importing db from 2.2 RC 2 to 2.3.1


Guest

Recommended Posts

I exported just the data from my old db (not the structure) and cleared all the default data from the 2.3.1. db as other instructions have said. I imported the data to my 2.3.1. database, which is a fresh install and a new database. I receive the following error:

 

SQL query:

-- -- Dumping data for table `categories` -- INSERT INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`) VALUES (21, NULL, 0, 0, '2010-02-03 14:00:44', NULL), (22, NULL, 0, 0, '2010-02-09 17:56:57', NULL), (23, NULL, 0, 0, '2010-02-09 18:06:19', NULL), (24, NULL, 0, 0, '2010-02-09 18:11:20', NULL), (25, NULL, 0, 0, '2010-02-09 18:16:20', NULL), (26, NULL, 0, 0, '2010-02-09 18:25:28', NULL), (27, NULL, 0, 0, '2010-02-10 12:26:11', NULL), (28, NULL, 0, 0, '2010-02-15 14:42:04', NULL), (29, NULL, 0, 0, '2010-02-15 14:56:40', NULL), (30, NULL, 0, 0, '2010-02-15 15:15:18', NULL), (31, NULL, 0, 0, '2010-02-15 15:36:57', NULL), (32, NULL, 0, 0, '2010-02-23 17:31:05', NULL), (33, NULL, 0, 0, '2010-02-23 17:55:08', NULL), (34, NULL, 0, 0, '2010-02-23 18:23:34', NULL), (35, NULL, 0, 0, '2010-02-24 15:31:07', NULL), (36, NULL, 0, 0, '2010-02-24 15:51:04', NULL), (37, NULL, 0, 0, '2010-02-24 16:11:57', NULL), (38, NULL, 0, 0, '2010-02[...]

MySQL said: 

#1062 - Duplicate entry '51' for key 1 

 

Any suggestions or is there a detailed description or info sheet on how to do this properly? I am going to be using new installs for all of my stores.

 

Thanks, and help is appreciated.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...