Magento 2.3 - After moving theme files to root folder getting error - SQLSTATE[23000]

[Aveeva]

After move theme folder (app, pub, lib) to root folder then run php bin/magento setup:upgrade getting the following error,

> php bin/magento setup:upgrade

Installing data... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '21' for key 'PRIMARY', query was: INSERT INTO `eav_attribute_set` (`entity_type_id`, `attribute_set_name`, `sort_order`, `attribute_set_id`) VALUES (?, ?, ?, ?)

[Bhanu Periwal]

Hi @Aveeva 

Kindly refer below url:
https://magento.stackexchange.com/questions/216720/sqlstate23000-integrity-constraint-violation-1062...

Follow steps mentioned within solution, it will help you to resolve issue.

If issue resolve, please click on 'Kudos' & Accept as Solution!

[Aveeva]

@Bhanu Periwal  Here Duplicate entry 21 is my attribute_set_id Now what i need to do?

[Bhanu Periwal]

Hello @Aveeva 

Please take backup of table or complete database first.

Edit that row, you will see there is more than 1 entry (comma separated) for same value (here 21), just remove all other duplicates values from there and save it.

Flush cache and re-run index command.

If error comes again then again (that may come for other products as well) check and fix in similar way.

If issue resolve, Please click on 'Kudos' & Accept as Solution!

[Aveeva]

@Bhanu Periwal  From your point, "Edit that row, you will see there is more than 1 entry (comma separated) for same value (here 21), just remove all other duplicates values from there and save it."

Here 21 is available single time,

Screenshot :  https://snipboard.io/v1z0f2.jpg

What i need to do?

[Aveeva]

@Bhanu Periwal Final stage error, could you pls help me. Thanks.