InnoDB errors

New home Forums Pro Add-on InnoDB errors

This topic contains 1 reply, has 2 voices, and was last updated by  Nick Duncan 4 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #12045

    chris
    Member

    We recently moved to a WHM-Cpanel setup, and are getting the same error on all of our sites that have this plugin installed. I will copy some info out of the Cpanel home directory error log. After the error, the maps wont display correctly until I restart the MySql service or restart the entire web server. I understand that this may be a misconfig on our end, but everything else seems to work fine. If I look at the tables through myPHP for your plugin, I get the same innoDB error when the map is not displaying. Thanks as always for the support, Nick.

    Cheers,

    Chris

    [25-Mar-2015 04:35:44 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
                SELECT *
                FROM ruqnxhd_wpgmza
                WHERE <code>map_id</code> = '1' ORDER BY <code>id</code> DESC
             made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, wpgmaps_tag_pro, wpgmaps_return_marker_anchors
    [25-Mar-2015 04:35:44 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
            SELECT *
            FROM ruqnxhd_wpgmza_maps
            WHERE <code>id</code> = '1' LIMIT 1
         made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_footer, locate_template, load_template, require_once('/themes/catalyst/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wpgmaps_user_javascript_pro, wpgmza_get_map_data
    [25-Mar-2015 04:35:44 UTC] PHP Warning:  Creating default object from empty value in /home/webtech/public_html/wp-content/plugins/wp-google-maps-pro/wp-google-maps-pro.php on line 2298
    [25-Mar-2015 04:35:44 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
            SELECT COUNT(<code>id</code>) as <code>total_markers</code>
            FROM ruqnxhd_wpgmza
            WHERE <code>map_id</code> = '1'
             made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_footer, locate_template, load_template, require_once('/themes/catalyst/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wpgmaps_user_javascript_pro, wpgmza_return_marker_count
    [25-Mar-2015 04:35:44 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
    	SELECT *
    	FROM ruqnxhd_wpgmza_polygon
    	WHERE <code>map_id</code> = '1'
         made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_footer, locate_template, load_template, require_once('/themes/catalyst/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wpgmaps_user_javascript_pro, wpgmza_b_return_polygon_id_array
    [25-Mar-2015 04:35:44 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
    	SELECT *
    	FROM ruqnxhd_wpgmza_polylines
    	WHERE <code>map_id</code> = '1'
         made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, get_footer, locate_template, load_template, require_once('/themes/catalyst/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wpgmaps_user_javascript_pro, wpgmza_b_return_polyline_id_array
    [25-Mar-2015 04:46:09 UTC] WordPress database error Unknown storage engine 'InnoDB' for query 
            SELECT *
            FROM ruqnxhd_wpgmza_maps
            WHERE <code>id</code> = '1' LIMIT 1
         made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/catalyst/page.php'), catalyst_framework, catalyst_hook_post_loop, do_action('catalyst_hook_post_loop'), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action('catalyst_hook_post_content'), call_user_func_array, catalyst_build_the_content, the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, wpgmaps_tag_pro, wpgmza_get_map_data
    #12081

    Nick Duncan
    Keymaster

    Hi Chris
    I’ve seen this only once before whereby the host never had the “InnoDB” database storage method enabled on their side. Are you able to contact your host to get this supported?

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘InnoDB errors’ is closed to new replies.