Site down hard

This topic contains 9 replies, has 2 voices, and was last updated by  Paolo 9 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #36468

    msgliniewicz
    Buyer
    Post count: 164

    So, I installed all the updates last night and things were running fine and then…

    Sometime between 6 am and now, my site went down hard. Meaning, I am reinstalling everything to try and get it up and running again.

    This is the 2nd time this has happened and the only thing in my error log is this:

    [07-Apr-2015 02:52:20 UTC] WordPress database error Unknown column ‘bsg2geodir_gd_event_detail.post_latitude’ in ‘field list’ for query SELECT bsg2posts.* , (3958.761 * 2 * ASIN(SQRT( POWER(SIN((ABS(38.8658635) – ABS(bsg2geodir_gd_event_detail.post_latitude)) * pi()/180 / 2), 2) +COS(ABS(38.8658635) * pi()/180) * COS( ABS(bsg2geodir_gd_event_detail.post_latitude) * pi()/180) *POWER(SIN((-104.7098063 – bsg2geodir_gd_event_detail.post_longitude) * pi()/180 / 2), 2) )))as distance FROM bsg2posts WHERE 1=1 AND bsg2posts.post_type = ‘post’ AND ((bsg2posts.post_status = ‘publish’)) ORDER BY bsg2posts.post_date DESC LIMIT 0, 5 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/geodirectory/geodirectory-templates/geodir-location.php’), do_action(‘geodir_location_sidebar_right’), call_user_func_array, geodir_action_home_sidebar_right, do_action(‘geodir_home_sidebar_right_inside’), call_user_func_array, geodir_home_right_section, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Posts->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    Right now, there is nothing for you guy to log into as, as I mentioned, I am rebuilding the site.

    This is actually the 2nd time this has happened.

    I’ll keep you posted.

    Shawn

    #36470

    msgliniewicz
    Buyer
    Post count: 164

    So, with a clean install, I received this error trying to get GD Modern running.

    07-Apr-2015 15:44:58] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/php/54/usr/lib64/php/modules/imagick.so’ – /usr/php/54/usr/lib64/php/modules/imagick.so: undefined symbol: zend_new_interned_string in Unknown on line 0

    #36476

    msgliniewicz
    Buyer
    Post count: 164

    Site is back up, had to to a restore from 3 days ago (before plugin update). Not sure what the DB error is all about, just looking for 2nd set of eyes, please.

    #36484

    msgliniewicz
    Buyer
    Post count: 164

    Site is operational again. I will keep an eye on the error log and I believe the outage is was due to the database error, also corrected.. Sorry for blowing up the support forms..

    Shawn

    #36534

    Paolo
    Site Admin
    Post count: 31211

    No problem Shawn, we are glad the site is back up and working.

    Thanks

    #36550

    msgliniewicz
    Buyer
    Post count: 164

    Paolo

    I am getting an errors this am and not sure what it is in reference too:

    [08-Apr-2015 15:00:28 UTC] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8226651 bytes) in /home2/theauti9/public_html/bluestarguide/wp-includes/wp-db.php on line 1036

    Site seems to be stable right now, holding breath and keeping tabs.

    Shawn

    #36551

    msgliniewicz
    Buyer
    Post count: 164

    Oh, this error is back as of 5 min ago>

    [08-Apr-2015 15:10:24 UTC] WordPress database error Unknown column ‘bsg2geodir_gd_event_detail.post_latitude’ in ‘field list’ for query SELECT bsg2posts.* , (3958.761 * 2 * ASIN(SQRT( POWER(SIN((ABS(38.837613399999995) – ABS(bsg2geodir_gd_event_detail.post_latitude)) * pi()/180 / 2), 2) +COS(ABS(38.837613399999995) * pi()/180) * COS( ABS(bsg2geodir_gd_event_detail.post_latitude) * pi()/180) *POWER(SIN((-104.8193687 – bsg2geodir_gd_event_detail.post_longitude) * pi()/180 / 2), 2) )))as distance FROM bsg2posts WHERE 1=1 AND bsg2posts.post_type = ‘post’ AND ((bsg2posts.post_status = ‘publish’)) ORDER BY bsg2posts.post_date DESC LIMIT 0, 5 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/geodirectory/geodirectory-templates/geodir-location.php’), do_action(‘geodir_location_sidebar_right’), call_user_func_array, geodir_action_home_sidebar_right, do_action(‘geodir_home_sidebar_right_inside’), call_user_func_array, geodir_home_right_section, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Posts->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    Thoughts?

    #36582

    Paolo
    Site Admin
    Post count: 31211

    It seems like the server is having memory problems. What kind of server is that?

    Shared, VPS or dedicated?

    Let us know,

    Thanks

    #36591

    msgliniewicz
    Buyer
    Post count: 164

    Let me check…

    #36656

    Paolo
    Site Admin
    Post count: 31211

    Hi again,

    I still think the errors are mainly due to the server having exhausted memory problems.

    I’d suggest to move minimum to a VPS.

    Let us know,

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

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount