#53120 closed defect (bug) (invalid)
term_order-field not copied to wp_x_terms when switching to multisite
Reported by: |
|
Owned by: |
|
---|---|---|---|
Milestone: | Priority: | normal | |
Severity: | normal | Version: | |
Component: | Taxonomy | Keywords: | |
Focuses: | multisite | Cc: |
Description
I changed a site to multi-site yesterday and ran into trouble creating new product-categories in Woocommerce.
When activated, the debugging for the site, there was mentioning of missing term_order-column in queries.
When checking the tables of the sites that were "created" as subsites, the term_order-field was missing indeed.
I then manually added the field to the wp_x_terms-table (copied the field from the "original" website-tables) and the problem was fixed.
I suspect the routine that switched WordPress from single-site to multi-site, uses a "table-template" that misses the term-order-field or just had no edit-routine to add this specific field to the wp_x_terms-table.
The x in wp_x_terms is ofcourse the "number" of the subsite ;-)
Change History (5)
#2
@
3 years ago
Hi John,
Nope... is that a "known fellon" that produces this error?
The "nearest" plugin I have installed is plugins/taxonomy-terms-order, by nsp-code.
Could that be the culprit?
Regards,
Klaus
#3
@
3 years ago
- Focuses multisite removed
- Milestone Awaiting Review deleted
- Resolution set to invalid
- Status changed from assigned to closed
- Version 5.7.1 deleted
is that a "known fellon" that produces this error?
Not exactly. It's just a plugin (of my own) that provides similar (but different) functionality to Taxonomy Terms Order.
I assumed a plugin must've added that database column, because wp_terms
does not normally have term_order
.
Could that be the culprit?
Yes, I believe that it is. You'll want to contact the plugin author (nsp-code) for help with what you're seeing.
Sorry that we are unable to help you here. Best of luck, Klaus! 🙏
Hi there @spithost!
Do you happen to have this plugin installed?
https://wordpress.org/plugins/wp-term-order/