Zen Cart Logo
Forums / General Questions / Easy populate MySQLi error 1062: Duplicate entry '4530' for key 'categories.PRIMARY'

Easy populate MySQLi error 1062: Duplicate entry '4530' for key 'categories.PRIMARY'

Views: 359

Results 1 to 1 of 1
18 Nov 2024, 4:46 PM
#1
chadlly2003 avatar

chadlly2003

Totally Zenned

Join Date:
Jan 2015
Posts:
755
Plugin Contributions:
0

Easy populate MySQLi error 1062: Duplicate entry '4530' for key 'categories.PRIMARY'

zencart 1.5.8
php 8.1
I use easypopulate. All works great on my local site.

For some reason on my live site I am getting an error when trying to import from easy populate. I have been using this program for some time with no issue. Not sure what would have changed. If someone
could assist me or lead me in the right dirction i would greatly appreciate it.

MySQLi error 1062: Duplicate entry '4530' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
) VALUES (
4530, '', 4157, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
)
MySQLi error 1062: Duplicate entry '4530-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
categories_id = 4530,
language_id = 1,
categories_name = 'Goodwe Accessories',
categories_description = ''
MySQLi error 1062: Duplicate entry '4530' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
) VALUES (
4530, '', 4157, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
)