[crossfitcentercity]

OK, it just happened again when I tried to delete all events from the trash. Here is a screenshot of what the website looks like, and below is from my log file… http://i.imgur.com/TCDdvQX.png

[18-May-2014 18:54:18 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query DELETE FROM wp_postmeta WHERE meta_id = 200841 made by wp_delete_post, delete_metadata_by_mid
[18-May-2014 18:54:18 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT DISTINCT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type = ‘nav_menu_item’ AND ((wp_posts.post_status <> ‘trash’ AND wp_posts.post_status <> ‘auto-draft’)) AND ( (wp_postmeta.meta_key = ‘_menu_item_object_id’ AND CAST(wp_postmeta.meta_value AS CHAR) = ‘26486’) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC made by wp_delete_post, do_action(‘delete_post’), call_user_func_array, _wp_delete_post_menu_item, wp_get_associated_nav_menu_items, WP_Query->query, WP_Query->get_posts
[18-May-2014 18:54:18 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query DELETE FROM wp_posts WHERE ID = 26486 made by wp_delete_post
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_plugin_directory_constants, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘home’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_cookie_constants, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘active_plugins’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_get_active_and_valid_plugins, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘hack_file’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_get_active_and_valid_plugins, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘blog_charset’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_set_internal_encoding, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘permalink_structure’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), WP_Rewrite->__construct, WP_Rewrite->init, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘wp_user_roles’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), WP_Roles->__construct, WP_Roles->_init, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘template’ LIMIT 1 made by include(‘wp-load.php’)
, require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_templating_constants, get_template_directory, get_template, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘stylesheet’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), wp_templating_constants, get_stylesheet_directory, get_stylesheet, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘category_base’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, create_initial_taxonomies, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘tag_base’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, create_initial_taxonomies, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘use_smilies’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, smilies_init, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘cron’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_cron, _get_cron_array, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1400439360;a:1:{s:16:\”wp_version_check\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option, add_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1400439360;a:1:{s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option, add_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1400439360;a:1:{s:16:\”wp_update_themes\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option, add_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘timezone_string’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, get_option, apply_filters(‘pre_option_gmt_offset’), call_user_func_array, wp_timezone_override_offset, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘gmt_offset’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, get_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1400485020;a:1:{s:20:\”wp_maybe_auto_update\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option, add_option
[18-May-2014 18:56:00 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SELECT option_value FROM wp_options WHERE option_name = ‘theme_switched’ LIMIT 1 made by include(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, check_theme_switched, get_option
[18-May-2014 18:56:15 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:57:18 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:58:28 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:58:36 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:58:37 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:59:01 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
[18-May-2014 18:59:17 UTC] WordPress database error User ‘wrdjkRRxWUy’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form
….

[crossfitcentercity]

Thanks for the reply Casey. It seems like whatever query ends up happening takes down our whole database, and the page that I then see when I go to the website looks like this – http://i.imgur.com/MHQEaVl.png.

And when I go to access our database through the c -panel at fatcow, it tells me it can not be found, which is why I think the query is hanging the database. Once it clears up, things resume to normal…

I can’t seem to find any sql log files, but I just turned logging on the wp-config file, not sure if that will yield anything helpful or not…

[Author]

Posts