dashboard breaks when I try to edit single event

[crossfitcentercity]

Hi, I’ve upgraded to the new version of Events Calendar Pro, and at first I had no events showing up in my dashboard. I found some where to add the following to my functions file, and so I did that, and then could see all of my events in my back end.
add_action(‘init’, ‘tribe_allow_large_joins’);
function tribe_allow_large_joins(){
global $wpdb;
$wpdb->query(‘SET SQL_BIG_SELECTS=1’);
}

I was then going through trying to delete all my recurring events, because I read in another thread that after the upgrade if you were experiencing problems that was the way to go. I then went into a single event, and tried to delete it, and my whole site has been taken down. When I go there, all I see is a page that tells me I need to install WordPress. This has happened to me before, and I deleted and re-installed the plugin in to no avail. I think something is happening with the database query being too large, because whenever I call fatcow for help, they usually can’t find anything wrong and it resolves itself after about 20 minutes. But I can’t keep making my site unaccessible for 20 minutes at a time. Any thoughts? Thank you.

I have tried to disable all my plugins by renaming the folder to plugins.old via ftp, but I can’t revert themes because I can’t actually get to my dashboard…

[Casey D]

Hello crossfitcentercity,

Sorry you are experiencing this! I bet it can be frustrating.

all I see is a page that tells me I need to install WordPress

Can you expand on this part a bit? I’ve never heard a situation before where deleting one event would bring down an entire site. Could you offer screenshots of your process?

Here are some excellent tools for uploading some screenshots!

Thanks

– Casey Driscoll

[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…

[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
….

[Casey D]

Hello crossfitcentercity,

Thanks for the info! Could you contact Fatcow about this at the same time? I am in the process of contacting our devs, but I believe the issue is with your host.

I’m not certain, but I believe your ‘max_questions’, a limit set by your host, prevents you from accessing the DB only so many times. I still don’t know how that brings down the entire install though.

I will contact our developers, but I would be sure to contact your host again because I’m not sure how much we will be able to help on this.

Cheers!

– Casey Driscoll

[Casey D]

Hello crossfitcentercity,

I checked with our devs and there isn’t any thing we can do about this, unfortunately. If you are running a more active site, you have out grown your host. Contact them for more information!

Good luck!

– Casey Driscoll

[Author]

Posts