Subsite returns error for sub-domain added in cpanel

  • Using Multisite 5.5.3 having 20 subsite

    Super.site.org
    Main.site.org
    Sub1.site.org
    Sub2.site.org
    Sub3.site.org
    Sub4.site.org
    Sub5.site.org likewise

    All network and subsite working fine until we decided to create new subsite
    Sub20.site.org

    Sub-Domain is created on the server and mapped to the site.org – OK with domain records and this has been verified by the server support that all is well at their end. But the error is reported on this new subsite (rest all is still working fine)

    We don’t see any issue with the plugins, as such if any plugins have been the problems then it would have affected the rest of the subsite as well. But seems that is not the issue. The following is the error on the server log

    dig A werp.theunition.org @8.8.4.4 +short
    204.44.192.19

    Checking further the sub-domain I found that it is returning a WP error and here is what I have fund in the debug logs:

    bash-4.2$ tail -3 wp-content/debug.log
    [23-Nov-2020 15:52:27 UTC] WordPress database error Unknown column
    ‘t.term_order’ in ‘order clause’ for query SELECT t.*, tt.* FROM
    wporg_20_terms AS t INNER JOIN wporg_20_term_taxonomy AS tt ON
    t.term_id = tt.term_id WHERE tt.taxonomy IN (‘activity_category’) AND
    t.name IN (‘Volunteering’) AND tt.parent = ‘0’ ORDER BY t.term_order
    ASC made by require_once(‘wp-load.php’), require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action,
    WP_Hook->apply_filters, cdcrm_default_activity_categories,
    wp_insert_term, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms
    [23-Nov-2020 15:52:27 UTC] WordPress database error Unknown column
    ‘t.term_order’ in ‘order clause’ for query SELECT t.*, tt.* FROM
    wporg_20_terms AS t INNER JOIN wporg_20_term_taxonomy AS tt ON
    t.term_id = tt.term_id WHERE tt.taxonomy IN (‘activity_category’) AND
    t.slug = ‘volunteering’ ORDER BY t.term_order ASC LIMIT 1 made by
    require_once(‘wp-load.php’), require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action,
    WP_Hook->apply_filters, cdcrm_default_activity_categories,
    wp_insert_term, wp_unique_term_slug, get_term_by, get_terms,
    WP_Term_Query->query, WP_Term_Query->get_terms
    [23-Nov-2020 15:52:27 UTC] WordPress database error Unknown column
    ‘t.term_order’ in ‘order clause’ for query SELECT t.term_id, tt.parent,
    tt.count, tt.taxonomy FROM wporg_20_terms AS t INNER JOIN
    wporg_20_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy
    IN (‘activity_category’) ORDER BY t.term_order ASC made by
    require_once(‘wp-load.php’), require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action,
    WP_Hook->apply_filters, cdcrm_default_activity_categories,
    wp_insert_term, clean_term_cache, clean_taxonomy_cache,
    _get_term_hierarchy, get_terms, WP_Term_Query->query,
    WP_Term_Query->get_terms

    The database is not corrupt and I suspect that there is just a plugin misconfiguration / conflict but it’s hard to identify which of the modules is the culprit because you have a huge amount of plugin installed for this application:

    bash-4.2$ ll | wc -l
    805

    Kind to check at your self what could have emerged the issue

Viewing 3 replies - 1 through 3 (of 3 total)

  • Well, ‘werp’ was in maintenance when I first looked but then it came up just fine after I navigated to theunition.org and then back to ‘werp’. I imagine you fixed something while the subsite was in maintenance.

    So let us know if you need anything else.

    Thread Starter w4cdev

    (@w4cdev)

    Thanks for updates.

    There were no tasks been taken emphatically for this issue. It could be something of of belie “Miracle do happens”

    But we further belief that “Miracle do happens unless some action”

    If you please LUK what the above error that made the sub-domain been dumped, if possible

    As an InMotion web hosting customer, you can create subdomains (separately from your … Congratulations, you have added your first subdomain! … Sorry for the issue you’re encountering with the error when creating a subdomain. … what i need is the address bar return into my real subdomain which is … TargetPayandBenefits

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Subsite returns error for sub-domain added in cpanel’ is closed to new replies.