Unknown column ‘term_order’ in ‘field list’

  • Resolved jdizzle

    (@jdizzle)


    4 years, 3 months ago

    Getting this error in the backend? Running WP 5.5, Plugin 2.5.0, PHP 7.4. Any ideas?

    WordPress database error: [Unknown column 'term_order' in 'field list']
SELECT count(*) as cnt, max(term_order) as max, min(term_order) as min FROM wp_terms AS terms INNER JOIN wp_term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id ) WHERE term_taxonomy.taxonomy = 'post_tag'

Notice: Undefined offset: 0 in /www/website/public/wp-content/plugins/simple-custom-post-order/simple-custom-post-order.php on line 279

Notice: Trying to get property 'cnt' of non-object in /www/website/public/wp-content/plugins/simple-custom-post-order/simple-custom-post-order.php on line 279
Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi @jdizzle,

    Thanks for reaching out!
    Can you please deactivate and then reactivate the plugin?
    term_order is added by our plugin and used by it to order taxonomies.

    Warmly,
    Mihaela

    Thread Starter jdizzle

    (@jdizzle)

    Hi @mplusb,

    The error still exists after doing that step?

    Thanks,
    J

    Hi @jdizzle,

    The only option left is to manually add that column in your database.
    If you want to try that go to your database and run the following SQL command:
    ALTER TABLE wp_terms ADD term_order INT( 4 ) NULL DEFAULT '0'

    Warmly,
    Mihaela

    • This reply was modified 4 years, 3 months ago by Miha. Reason: grammar
    Thread Starter jdizzle

    (@jdizzle)

    Perfect! Thanks Mihaela ??

    Anytime!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Unknown column ‘term_order’ in ‘field list’’ is closed to new replies.