Fixing, or even understanding, MySQL Database Issues are still something that eludes me the majority of the time...

I recently migrated a large database across from EKM Powershop in to WooCommerce. All works fine, except the site (dev url at present) is very slow, especially in the backend.

I have been in contact with the hosting companies support team and they are saying the database is under load due to errors, the details are below. Can anybody make any sense of this/convert to plain English and give me a heads up as to whats going on?

rootdev16.co.uk [Thu May 21 15:44:29 2015] [error] [client 2.103.21.0:43198] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by WP_List_Table->display, WP_List_Table->display_tablenav, WP_Posts_List_Table->extra_tablenav, wp_dropdown_categories, get_terms

rootdev16.co.uk [Thu May 21 15:44:35 2015] [error] [client 81.141.4.83:47626] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

rootdev16.co.uk [Thu May 21 15:44:37 2015] [error] [client 2.103.21.0:48614] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

rootdev16.co.uk [Thu May 21 15:45:01 2015] [error] [client 2.103.21.0:36418] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

rootdev16.co.uk [Thu May 21 15:45:06 2015] [error] [client 2.103.21.0:37856] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

rootdev16.co.uk [Thu May 21 15:45:17 2015] [error] [client 2.103.21.0:46832] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

rootdev16.co.uk [Thu May 21 15:45:29 2015] [error] [client 2.103.21.0:52602] AH01215: WordPress database error Table 'cl54-gy9-236a.vinvi5e_interface_taxonomy' doesn't exist for query SELECT t.*, tt.*, tm.meta_key, tm.meta_value FROM vinvi5e_terms AS t INNER JOIN vinvi5e_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN vinvi5e_interface_taxonomy AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('category') ORDER BY CAST(tm.meta_value AS SIGNED) ASC, t.name ASC made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, of_options, get_categories, get_terms

 

The table `vinvi5e_interface_taxonomy` does not exist try porting it over from your original site While your there check that you have these as well:

vinvi5e_terms

vinvi5e_term_taxonomy

vinvi5e_interface_taxonomy

Edited May 29, 201511 yr by D4Y0

vinvi5e_terms

vinvi5e_term_taxonomy

are both there.

As this has been ported from EKM Powershop to WordPress, could the 'interface_taxonomy' table simply not have come over as it isn't used on the new site? Sorry, I really am terrible with MySQL.

Failing that, could I just add the new table manually, with no data? Would that work?

Yea it looks like it has not been moved over

 

If you have PhpMyAdmin or ssh access you can login in and export the table from the EKM Powershop database and import it to the wordpress database

 

SSH Commands:

Export:

mysqldump -u {username} -p{password} {database) {table} > {file}.sql

Import:

mysql -u {username} -p{password}} -D {database} < {file}.sql

Key:

{password} = should be the sql password there should not be a space between the p and the password, you can leave it blank but you will be prompted for it

{username} - the username of your sql user

{database} - the database of the table you want to export/import

{table} - the table within the database you want to import/export

{file} - Where the outputed sql will be saved, or the file to import

Edited May 29, 201511 yr by D4Y0

Unfortunately, EKM doesn't work like that, it simply allows us to export everything as a CSV file, there isn't any direct access to phpmyadmin.

 

Looking again at the tables, they all look like typical WordPress tables?

Looking like it was down to an old plugin that hadn't been removed properly. Once removed, and a fresh install of the DB was uploaded, all was fine with the world

 

Cheers Guys