Tables in db not present

I am getting an error indicating a table not found (6hKedH1_network_terms) everytime a make a post with or without TERMS for taxonomy.

I don't see this table: 6hKedH1_network_terms

But I do see these tables: 6hKedH1_network_term_taxonomy and
6hKedH1_term_taxonomy

Any of the wpmudev plugins use this 6hKedH1_network_terms table?
Of course ignore the "6hKedH1" portion.

Thank you

  • Sajid

    Hello Lee,

    Hope you are doing good today :slight_smile:

    If I remember correctly the Post Indexer plugin have network_terms table. If you are not using this plugin then simply deactivate it.

    In case you are using this plugin but its not working correctly then please enable support staff access so I could take a closer look.

    To grant access go to WPMU DEV -> Support -> Support Access -> Grant Support Access or see this manual for more details:
    https://premium.wpmudev.org/manuals/wpmu-dev-dashboard-enabling-staff-login/

    Take care and have a nice day :slight_smile:

    Best Regards,
    Sajid

  • Lee

    Yes I have it activated. Thought it might be the case.

    I deactivated it then activated and did a rebuild but that did not fix the problem.

    I deactivated and deleted it. The error goes away.

    Reinstalled and got the same error back in my apache log by simply publishing a new post with tile test5, text 'test5' and term test5. I have deleted postindexer plugin for now. This should be problem everyone is having.

    AH01071: Got error 'PHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SELECT term_id FROM 6hKedH1_network_terms WHERE name = 'Audio' AND slug = 'audioc' AND term_group = 0 made by edit_post, wp_update_post, wp_insert_post, do_action('post_updated'), call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SHOW FULL COLUMNS FROM 6hKedH1_network_terms made by edit_post, wp_update_post, wp_insert_post, do_action('post_updated'), call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SELECT term_id FROM 6hKedH1_network_terms WHERE name = 'test5' AND slug = 'test5' AND term_group = 0 made by edit_post, wp_update_post, wp_insert_post, do_action('post_updated'), call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SHOW FULL COLUMNS FROM 6hKedH1_network_terms made by edit_post, wp_update_post, wp_insert_post, do_action('post_updated'), call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SELECT term_id FROM 6hKedH1_network_terms WHERE name = 'Audio' AND slug = 'audioc' AND term_group = 0 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SHOW FULL COLUMNS FROM 6hKedH1_network_terms made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SELECT term_id FROM 6hKedH1_network_terms WHERE name = 'test5' AND slug = 'test5' AND term_group = 0 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\nPHP message: WordPress database error Table 'wordpress_f.6hKedH1_network_terms' doesn't exist for query SHOW FULL COLUMNS FROM 6hKedH1_network_terms made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, postindexeradmin->index_post, postindexermodel->index_tax, postindexermodel->insert_or_get_term\n', referer: https://domain.tld/wp-admin/post-new.php?wp-post-new-reload=true

  • Sajid

    Hello Lee,

    Hope you are doing good today!

    Yes, I could replicate this issue. However, I could create a table manually by going in phpMyadmin directly.

    CREATE TABLE IF NOT EXISTS 6hKedH1_network_terms (
    term_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    name varchar(200) NOT NULL DEFAULT '',
    slug varchar(200) NOT NULL DEFAULT '',
    term_group bigint(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (<code>term_id</code>),
    UNIQUE KEY <code>slug</code> (<code>slug</code>),
    KEY <code>name</code> (<code>name</code>)
    )

    If you are comfortable with running MySQL queries manually then run the above query in your database.

    If it does not work first time then try to reduce the length of name and slug to 100 by replacing the 200 for both columns in above query.

    In case, you are unable to do it or not familiar at all then please send in cPanel details via our secure contact form in following format and I will do it for you.

    Subject: "Attn: Sajid Javed”
    - WordPress admin username
    - WordPress admin password
    - login url
    - cPanel credentials (loginlink/username/password)
    - link back to this thread for reference
    - any other relevant urls

    Take care and have a nice weekend :slight_smile:

    Best Regards,
    Sajid

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.