Potential Issue with my Database wp_term

I’m having an issue with a custom plugin, directoriespro, when importing data for the plugin we are getting ‘WordPress database error Duplicate’. I have contacted the plugin support and they recon that it could be caused by ‘UNIQUE index configured for the “slug” column in the wp_terms table’.

I have checked the table and it and it’s setup as below.
Keyname Type Unique Packed Column Cardinality Collation
PRIMARY BTREE Yes No term_id 8741 A
slug BTREE Yes No slug 8670 A
name BTREE No No name 8741 A

Are they correct that it shouldn’t be unique? They referred my to the following article but its a bit over my head tbh.https://core.trac.wordpress.org/ticket/22023

Also if there is an issue with this table, is there any plugins out there that I can install to check all my tables are correctly setup and correct for the current version(version 5.3.2–en_GB) I am running.

• This topic was modified 6 years, 3 months ago by solarblitz77.
• This topic was modified 6 years, 3 months ago by solarblitz77.