site crashed while adding new user - advise needed

Hi,

I don't know if anyone here can help explain what happened. I was adding a new member (in my Q&A site) and instead of registering I used the Add New option under Users. I received an email to verify and I clicked on the link, the login page opened and I entered my username/password.

When it didn't work, I went back to my admin page to check if the user was verified or not and maybe change the password and try again, I click the back button on my browser and all I got was error.

I tried the public URL and other admin options and all I get is a blank page with one simple word 'error'. I tried another computer and faced the same.

I don't know what went wrong.

edit to add: it took a while but site is back now still don't know what happened, I didn't do anything other than freak

  • mira

    It is back but I'm worried to add a new user again -_-

    yeah there is a lot! what does it all mean?

    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('question_category') ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, do_action('genesis_after_content'), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/genesis/sidebar.php'), do_action('genesis_sidebar'), call_user_func_array, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, QA_Widget_Categories->widget, wp_list_categories, get_categories, get_terms
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT * FROM wp_usermeta WHERE meta_key='_qa_rep' AND meta_value > 0 ORDER BY CONVERT(meta_value, SIGNED) DESC LIMIT 5 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, do_action('genesis_after_content'), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/genesis/sidebar.php'), do_action('genesis_sidebar'), call_user_func_array, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, QA_Widget_Reputation->widget
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('question_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 45 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, do_action('genesis_after_content'), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/genesis/sidebar.php'), do_action('genesis_sidebar'), call_user_func_array, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, QA_Widget_Tags->widget, wp_tag_cloud, get_terms
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_genesis-update' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, get_transient, get_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT autoload FROM wp_options WHERE option_name = '_transient_genesis-update' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, get_transient, delete_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_genesis-update' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, get_transient, delete_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = '_transient_genesis-update' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, set_transient, get_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_transient_timeout_genesis-update', '1371896372', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, set_transient, add_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_transient_genesis-update', 'a:4:{s:11:\"new_version\";s:5:\"1.9.2\";s:3:\"url\";s:40:\"http://my.studiopress.com/themes/genesis\";s:7:\"package\";s:60:\"http://www.genesistheme.com/download/?file=genesis.1.9.2.zip\";s:13:\"changelog_url\";s:53:\"http://www.genesistheme.com/changelog/?TB_iframe=true\";}', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_updates_menu, wp_get_update_data, get_site_transient, apply_filters('site_transient_update_themes'), call_user_func_array, genesis_update_push, genesis_update_check, set_transient, add_option
    [21-Jun-2013 10:19:32 UTC] WordPress database error MySQL server has gone away for query SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments GROUP BY comment_approved made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), wp_footer, do_action('wp_footer'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, wp_admin_bar_comments_menu, wp_count_comments
    [27-Jun-2013 05:00:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 for query UPDATE wp_linkTrack SET redirect_to=NULL WHERE post_id = LIMIT 1 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, widget_wp_sidebarlogin_check, wp_signon, do_action('wp_login'), call_user_func_array, QA_Edit->wp_login, wp_update_post, wp_insert_post, do_action('edit_post'), call_user_func_array, TrafficTrack->update_redirect_values
    [07-Jul-2013 01:59:03] PHP Warning: parse_url(/english/wp-login.php?regplus_verification=i3bbg3872l495mf906d6402gbc&redirect_to=http://isha3ah.com/english) [function.parse-url]: Unable to parse URL in /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php on line 588
    [07-Jul-2013 01:59:03] PHP Warning: Cannot modify header information - headers already sent by (output started at /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php:588) in /home1/monira/public_html/english/wp-login.php on line 368
    [07-Jul-2013 01:59:03] PHP Warning: Cannot modify header information - headers already sent by (output started at /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php:588) in /home1/monira/public_html/english/wp-login.php on line 380
    [07-Jul-2013 01:59:26] PHP Warning: parse_url(/english/wp-login.php?regplus_verification=i3bbg3872l495mf906d6402gbc&redirect_to=http://isha3ah.com/english) [function.parse-url]: Unable to parse URL in /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php on line 588
    [07-Jul-2013 01:59:26] PHP Warning: Cannot modify header information - headers already sent by (output started at /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php:588) in /home1/monira/public_html/english/wp-login.php on line 368
    [07-Jul-2013 01:59:26] PHP Warning: Cannot modify header information - headers already sent by (output started at /home1/monira/public_html/english/wp-content/plugins/simplr-registration-form/simplr_reg_page.php:588) in /home1/monira/public_html/english/wp-login.php on line 380
    [07-Jul-2013 02:07:33] PHP Warning: getimagesize(/home1/monira/public_html/english/wp-content/uploads/logo.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /home1/monira/public_html/english/wp-content/plugins/register-plus/register-plus.php on line 1531

  • Vaughan

    hiya

    it means you're in a mess.

    WordPress database error MySQL server has gone away for query

    happens when the database closes it's connection, usually due to being idle. but can also occur if the wait_timeout session in MySQL is not long enough. your host could help with that. otherwise it would mean editing the actual wordpress core which we would not recommend.

    but it's strange how it just suddenly started happening.

    for now, just going on the errors above.

    I would deactivate the following plugins

    register-plus & simplr-registration-form

    also switch to the default 2012 theme.

    rename that error_log file to error_log_old

    then go through the process of adding a new user. visit the pages on your site randomly, go through dashboard options.

    then keep checking that error_log to see if any more errors occur.

    if the errors stop, then re-activate your theme & test again.

    I'm not sure it's such a good idea having 2 different plugins that modify the registration system, it could be those that are the cause.

    what version of WP are you using btw?

    hope this helps.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.