Unable to split shared taxonomy terms

(@bcworkz)

The error message is because WP could not insert a new DB record into the terms table for the term being split. This is essential because each of the term’s taxonomies needs to have a its own unique term ID. This is accomplished by inserting additional term records, one for each taxonomy. Being unable to add records makes splitting impossible.

The plugin uses the same function that WP update uses to split terms. It’s failing for the same reason the terms were not split to start with. Until WP can insert records using this function, splitting terms would be difficult.

Can you manually insert new terms? If so, its strange the above process doesn’t work.

I suppose you could manually split terms through phpMyAdmin, replicating a term’s data in a new record. Update one of the taxonomies using the old term ID in the taxonomy table to the new term ID. This splitting gets more complicated if the split term has child terms, as those term’s parent ID needs updating as well.

It would be horribly tedious to manually split 47 terms, but if things appear to be desperate, it’s a possibility. Be sure to back up the taxonomy and terms tables before attempting anything like this. Test one split thoroughly before spending time on further splits.

For reference, the PHP code to do the splitting is at https://core.trac.wordpress.org/browser/tags/5.2/src/wp-includes/taxonomy.php#L3759

Thread Starter

(@motljus)

Well we have been able to add new terms (both new categories and tags) and also delete those who are not conflicting, without any problems.
It is just those 47 that are sharing the same ID that are causing problems, so that can’t be the reason and we aren’t getting any more error logging from the script than that it is unable to split the terms.

Thread Starter

(@motljus)

Thanks for the link to where in the source code btw, @bcworkz
It made me search for the WP_error I was logging

Could not split shared term.

Which in turn led me to this part of the code;

	if ( false === $wpdb->insert( $wpdb->terms, $new_term_data ) ) {
		return new WP_Error( 'db_insert_error', __( 'Could not split shared term.' ), $wpdb->last_error );
	}

…so I logged the array $new_term_data

Array ( [name] => Rollspel [slug] => rollspel [term_group] => 0 )
ERROR: Term Taxonomy ID 3 could not be split! -> Could not split shared term.1
Array ( [name] => Rollspel [slug] => rollspel [term_group] => 0 )
ERROR: Term Taxonomy ID 101 could not be split! -> Could not split shared term.1
Array ( [name] => Dataspel [slug] => dataspel [term_group] => 0 )
ERROR: Term Taxonomy ID 37 could not be split! -> Could not split shared term.1
Array ( [name] => Dataspel [slug] => dataspel [term_group] => 0 )
ERROR: Term Taxonomy ID 211 could not be split! -> Could not split shared term.1
Array ( [name] => Bordsrollspel [slug] => bordsrollspel [term_group] => 0 )
ERROR: Term Taxonomy ID 47 could not be split! -> Could not split shared term.1
Array ( [name] => Bordsrollspel [slug] => bordsrollspel [term_group] => 0 )
ERROR: Term Taxonomy ID 554 could not be split! -> Could not split shared term.1
Array ( [name] => Skräck [slug] => skrack [term_group] => 0 )
ERROR: Term Taxonomy ID 556 could not be split! -> Could not split shared term.1
Array ( [name] => Skräck [slug] => skrack [term_group] => 0 )
ERROR: Term Taxonomy ID 58 could not be split! -> Could not split shared term.1
Array ( [name] => Figurspel [slug] => figurspel [term_group] => 0 )
ERROR: Term Taxonomy ID 61 could not be split! -> Could not split shared term.1
Array ( [name] => Figurspel [slug] => figurspel [term_group] => 0 )
ERROR: Term Taxonomy ID 1870 could not be split! -> Could not split shared term.1
Array ( [name] => Fantasy [slug] => fantasy [term_group] => 0 )
ERROR: Term Taxonomy ID 547 could not be split! -> Could not split shared term.1
Array ( [name] => Fantasy [slug] => fantasy [term_group] => 0 )
ERROR: Term Taxonomy ID 71 could not be split! -> Could not split shared term.1
Array ( [name] => Warhammer 40k [slug] => warhammer-40k [term_group] => 0 )
ERROR: Term Taxonomy ID 1868 could not be split! -> Could not split shared term.1
Array ( [name] => Warhammer 40k [slug] => warhammer-40k [term_group] => 0 )
ERROR: Term Taxonomy ID 82 could not be split! -> Could not split shared term.1
Array ( [name] => Science Fiction [slug] => science-fiction [term_group] => 0 )
ERROR: Term Taxonomy ID 549 could not be split! -> Could not split shared term.1
Array ( [name] => Science Fiction [slug] => science-fiction [term_group] => 0 )
ERROR: Term Taxonomy ID 91 could not be split! -> Could not split shared term.1
Array ( [name] => Cthulhu [slug] => cthulhu [term_group] => 0 )
ERROR: Term Taxonomy ID 555 could not be split! -> Could not split shared term.1
Array ( [name] => Cthulhu [slug] => cthulhu [term_group] => 0 )
ERROR: Term Taxonomy ID 102 could not be split! -> Could not split shared term.1
Array ( [name] => Lajv [slug] => lajv [term_group] => 0 )
ERROR: Term Taxonomy ID 540 could not be split! -> Could not split shared term.1
Array ( [name] => Lajv [slug] => lajv [term_group] => 0 )
ERROR: Term Taxonomy ID 136 could not be split! -> Could not split shared term.1
Array ( [name] => Krönika [slug] => kronika [term_group] => 0 )
ERROR: Term Taxonomy ID 175 could not be split! -> Could not split shared term.1
Array ( [name] => Krönika [slug] => kronika [term_group] => 0 )
ERROR: Term Taxonomy ID 171 could not be split! -> Could not split shared term.1
Array ( [name] => brevlajv [slug] => brevlajv [term_group] => 0 )
ERROR: Term Taxonomy ID 841 could not be split! -> Could not split shared term.1
Array ( [name] => brevlajv [slug] => brevlajv [term_group] => 0 )
ERROR: Term Taxonomy ID 199 could not be split! -> Could not split shared term.1
Array ( [name] => Fantasylajv [slug] => fantasylajv [term_group] => 0 )
ERROR: Term Taxonomy ID 583 could not be split! -> Could not split shared term.1
Array ( [name] => Fantasylajv [slug] => fantasylajv [term_group] => 0 )
ERROR: Term Taxonomy ID 232 could not be split! -> Could not split shared term.1
Array ( [name] => LAN [slug] => lan [term_group] => 0 )
ERROR: Term Taxonomy ID 564 could not be split! -> Could not split shared term.1
Array ( [name] => LAN [slug] => lan [term_group] => 0 )
ERROR: Term Taxonomy ID 1880 could not be split! -> Could not split shared term.1
Array ( [name] => LAN [slug] => lan [term_group] => 0 )
ERROR: Term Taxonomy ID 287 could not be split! -> Could not split shared term.1
Array ( [name] => Datorspel [slug] => datorspel [term_group] => 0 )
ERROR: Term Taxonomy ID 1881 could not be split! -> Could not split shared term.1
Array ( [name] => Datorspel [slug] => datorspel [term_group] => 0 )
ERROR: Term Taxonomy ID 289 could not be split! -> Could not split shared term.1
Array ( [name] => Zombie [slug] => zombie [term_group] => 0 )
ERROR: Term Taxonomy ID 551 could not be split! -> Could not split shared term.1
Array ( [name] => Zombie [slug] => zombie [term_group] => 0 )
ERROR: Term Taxonomy ID 379 could not be split! -> Could not split shared term.1
Array ( [name] => Historiskt [slug] => historiskt [term_group] => 0 )
ERROR: Term Taxonomy ID 558 could not be split! -> Could not split shared term.1
Array ( [name] => Historiskt [slug] => historiskt [term_group] => 0 )
ERROR: Term Taxonomy ID 497 could not be split! -> Could not split shared term.1
Array ( [name] => Airsoft [slug] => airsoft [term_group] => 0 )
ERROR: Term Taxonomy ID 541 could not be split! -> Could not split shared term.1
Array ( [name] => Airsoft [slug] => airsoft [term_group] => 0 )
ERROR: Term Taxonomy ID 590 could not be split! -> Could not split shared term.1
Array ( [name] => Turnering [slug] => turnering [term_group] => 0 )
ERROR: Term Taxonomy ID 546 could not be split! -> Could not split shared term.1
Array ( [name] => Turnering [slug] => turnering [term_group] => 0 )
ERROR: Term Taxonomy ID 1558 could not be split! -> Could not split shared term.1
Array ( [name] => Elmia [slug] => elmia [term_group] => 0 )
ERROR: Term Taxonomy ID 565 could not be split! -> Could not split shared term.1
Array ( [name] => Elmia [slug] => elmia [term_group] => 0 )
ERROR: Term Taxonomy ID 1789 could not be split! -> Could not split shared term.1
Array ( [name] => barnlajv [slug] => barnlajv [term_group] => 0 )
ERROR: Term Taxonomy ID 569 could not be split! -> Could not split shared term.1
Array ( [name] => barnlajv [slug] => barnlajv [term_group] => 0 )
ERROR: Term Taxonomy ID 899 could not be split! -> Could not split shared term.1
Array ( [name] => Martinsgården [slug] => martinsgarden [term_group] => 0 )
ERROR: Term Taxonomy ID 824 could not be split! -> Could not split shared term.1
Array ( [name] => Martinsgården [slug] => martinsgarden [term_group] => 0 )
ERROR: Term Taxonomy ID 828 could not be split! -> Could not split shared term.1
Array ( [name] => Berghem [slug] => berghem [term_group] => 0 )
ERROR: Term Taxonomy ID 883 could not be split! -> Could not split shared term.1
Array ( [name] => Berghem [slug] => berghem [term_group] => 0 )
ERROR: Term Taxonomy ID 903 could not be split! -> Could not split shared term.1

Is term_group meant to be 0? Otherwise I can’t tell what is causing the insert to fail. Can you?

Thread Starter

(@motljus)

Please.
Does anyone have experience with not being able to split their terms at all, or does anyone know where to keep looking or debug to track down the reason of this bug?

Moderator

(@bcworkz)

Hi Motljus, I’m sorry I missed you previous post. On occasion notifications fail to come through to my email. I’m even more sorry to hear you’re still struggling with this.

It is common for “term_group” to be 0, I’m not sure if the field is even used, every single one of my terms have 0 value. From your logged data, it appears the terms are already split as each term has two different IDs. Unless the terms had more than 2 taxonomies? Get into phpMyAdmin and search the term_taxonomy table for term_id 3 and 101 (Rollspel). If each term_id has a single, unique taxonomy, then the terms are already split!

I suspect the splitting is incomplete though, which would be evidenced by one ID having two different taxonomies and the other none. You ought to be able to change one of the taxonomy row’s term_id to that of the term with no current entries in order to complete the split. Of course, you should backup the table before making such changes and test one change thoroughly before making further changes.

If that doesn’t check out, there are some table maintenance operations you can try in phpMyAdmin. Maybe after running these the splitting will succeed. For each table go to More > Operations. Near the bottom under Table Maintenance are Defragment and Optimize operations you can do. Again, you should make backups before making changes to the DB.

Thread Starter

(@motljus)

Thanks for answering.
Had to check with the database to get the full info first;
That is unfortunately the Term Taxonomy ID that is different. They still share the same Term ID = 3 (Rollspel)

SELECT * FROM 'wp_spelkult_se_terms'ORDER BY'term_id' ASC

term_id name	slug	term_group
3 	Rollspel 	rollspel 	0
43 	Levande rollspel 	levande-rollspel 	0
44 	Bordsrollspel 	bordsrollspel 	0

SELECT * FROM'wp_spelkult_se_term_taxonomy'WHERE'term_id' = 3

term_taxonomy_id	term_id	taxonomy	description	parent	count
3 	3 	category 	Artiklar om allt från bordsrollspel till levande r... 	0 	48
101 	3 	post_tag 		0 	0

This reply was modified 4 years, 5 months ago by Motljus.
This reply was modified 4 years, 5 months ago by Motljus.

Thread Starter

(@motljus)

Tried running repair and got this cutoff message;

spelkult_se.wp_spelkult_se_termmeta 	repair 	note 	The storage engine for the table doesn't support r...
spelkult_se.wp_spelkult_se_terms 	repair 	note 	The storage engine for the table doesn't support r...
spelkult_se.wp_spelkult_se_term_relationships 	repair 	note 	The storage engine for the table doesn't support r...
spelkult_se.wp_spelkult_se_term_taxonomy 	repair 	note 	The storage engine for the table doesn't support r...

Optimize resulted in these messages

spelkult_se.wp_spelkult_se_termmeta 	optimize 	note 	Table does not support optimize, doing recreate + ...
spelkult_se.wp_spelkult_se_termmeta 	optimize 	status 	OK
spelkult_se.wp_spelkult_se_terms 	optimize 	note 	Table does not support optimize, doing recreate + ...
spelkult_se.wp_spelkult_se_terms 	optimize 	status 	OK
spelkult_se.wp_spelkult_se_term_relationships 	optimize 	note 	Table does not support optimize, doing recreate + ...
spelkult_se.wp_spelkult_se_term_relationships 	optimize 	status 	OK
spelkult_se.wp_spelkult_se_term_taxonomy 	optimize 	note 	Table does not support optimize, doing recreate + ...
spelkult_se.wp_spelkult_se_term_taxonomy 	optimize 	status 	OK

Thread Starter

(@motljus)

Check and analyze results in Status OK however, if that says anything.

Moderator

(@bcworkz)

The table operations probably wouldn’t have helped anyway, it was just something to try out of few better ideas. Because we can be sure the post_tag taxonomy terms have no children (taxonomy is not hierarchical), you can change the term_id value 3 to 101 for the post_tag entry (taxonomy_term_id 101). Then go to the respective taxonomy list tables in WP admin and confirm the action links (“edit”, “view”, but not “delete”) for each Rollspell term work as expected.

The term_id and taxonomy_term_id matching is very common, but not a requirement. Also check the termmeta table for any entries for term_id 3. If there is data, but nothing for 101, decide if it is logical for any such meta data to be duplicated for the post_tag term as well. WP doesn’t add any term meta but themes and plugins might.

If that all checks out then the Rollspel term has finally been properly split (!) and it shouldn’t show up in the WP split terms errors. You can then proceed in a similar manner for the other terms that are throwing split errors. Doing so manually for all the terms would be extremely tedious. IF one of the problem terms is always a post_tag term, it may be possible to write an SQL query that fixes up all the term_taxonomy entries in one go. I’m not sure though, SQL is not my strong suit.

The entire process could be custom coded in PHP for sure, but chances of doing it wrong and corrupting the table is very real. It would entail some very careful, limited testing before turning such a script loose on your DB.

Thread Starter

(@motljus)

I have begun clearing up tags from a the first of the conflicting taxonomy terms, in an attempt to make them easier to split or perhaps even delete the unused completely. That is why there are no tags using the term “dataspel” no more, but 48 using the category with the same term id and name.

The problem with replacing the term_id (3) for taxonomy_term_id 101 with 101, if I understand you correctly, is that the term_id 101 is already populated with another term;
101 Crowdfunding crowdfunding 0

Is that perhaps the reason why the split is malfunctioning?

Moderator

(@bcworkz)