Make WordPress Core

Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#53120 closed defect (bug) (invalid)

term_order-field not copied to wp_x_terms when switching to multisite

Reported by: spithost's profile spithost Owned by: johnjamesjacoby's profile johnjamesjacoby
Milestone: Priority: normal
Severity: normal Version:
Component: Taxonomy Keywords:
Focuses: multisite Cc:


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)

#1 @johnjamesjacoby
3 years ago

  • Owner set to johnjamesjacoby
  • Status changed from new to assigned

Hi there @spithost!

Do you happen to have this plugin installed?

#2 @spithost
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?

#3 @johnjamesjacoby
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! 🙏

#4 @SergeyBiryukov
3 years ago

  • Component changed from General to Taxonomy
  • Focuses multisite added

#5 @spithost
3 years ago

Thanks! Will do!

Note: See TracTickets for help on using tickets.