News:

Support the VirtueMart project and become a member

Main Menu

Upgrade Won't Migrate All Categories

Started by kumpleto, November 13, 2012, 10:27:37 AM

Previous topic - Next topic

kumpleto

I'm trying to migrate my tables from V1.1.3 to V2.0.12f, however, it won't move all the categories and subcategories and returning me this error during migration:

vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )


Got no idea about this error and it's really giving me a pain in the ass with this issue.  Followed the position posted in here but to no avail.


Badly needed help! tnx

chetanmadaan

Do a fresh instal.. could be because the category with that ID already exist.