term_order-field not copied to wp_x_terms when switching to multisite

[spithost]

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 ;-)

[johnjamesjacoby]

Hi there @spithost!

Do you happen to have this plugin installed?

​https://wordpress.org/plugins/wp-term-order/

[spithost]

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

[johnjamesjacoby]

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! 🙏

[spithost]

Thanks! Will do!