The web calendar is running very slow

The web calendar is running very slow and sometimes not working. Select service and no problem, but then selecting supplier gets stuck.

  • Gerardo
    • Flash Drive

    [09-Dec-2015 10:26:17 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 65552 bytes) in /home/wwwultra/public_html/wp-includes/shortcodes.php on line 332
    [10-Dec-2015 22:41:42 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/wwwultra/public_html/wp-includes/wp-db.php on line 2327

  • Gerardo
    • Flash Drive

    Hello,

    php:
    11-Dec-2015 02:56:17 UTC] Error Query execution was interrupted de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=17 AND worker=14 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=52 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_busy, Appointments->get_reserve_apps_by_worker, Appointments->get_reserve_apps
    [11-Dec-2015 14:27:34 UTC] Error Server shutdown in progress de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=2 AND worker=0 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=53 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_busy, Appointments->get_reserve_apps
    [11-Dec-2015 18:30:40 UTC] Error Lost connection to MySQL server during query de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=5 AND worker=2 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=53 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_service_possible, Appointments->is_busy, Appointments->get_reserve_apps_by_worker, Appointments->get_reserve_apps
    [11-Dec-2015 18:30:40 UTC] Error Lost connection to MySQL server during query de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=19 AND worker=8 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=52 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_busy, Appointments->get_reserve_apps_by_worker, Appointments->get_reserve_apps
    [11-Dec-2015 18:30:40 UTC] Error Lost connection to MySQL server during query de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=6 AND worker=5 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=52 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_busy, Appointments->get_reserve_apps_by_worker, Appointments->get_reserve_apps
    [11-Dec-2015 19:24:28 UTC] Error Server shutdown in progress de la base de datos de WordPress para la consulta SELECT * FROM wp_app_appointments WHERE service=2 AND worker=6 AND (status='pending' OR status='paid' OR status='confirmed' OR status='reserved' OR status='completed') AND WEEKOFYEAR(start)=51 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ultrasonic/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, App_Shortcode_MonthlySchedule->process_shortcode, Appointments->get_monthly_calendar, Appointments->get_timetable, Appointments->is_busy, Appointments->get_reserve_apps_by_worker, Appointments->get_reserve_apps

    the access its ready.

    best regards

  • Gerardo
    • Flash Drive

    Hello,

    This problem has me crazy .
    Create a new account on the server (dedicated ) I install a new Appointment and wordpress, migrate databases of appointment and again have the same slow when selecting the service provider. Create everything from scratch on another server (VPS ) and the same thing happens again . It will be a problem of the last update?

    Regards

  • Michael
    • Site Builder, Child of Zeus

    I recently migrated my website over to https and I thought this was what was causing my problem. Now I have read a few posts on the forum I realise it is not the case. There is definitely an issue with 1.5.4 which is causing huge delay in loading pages containing calendar info. I have had my website timing out and returning a 500 error when someone tries to book an appointment, I have had appointment confirmations timing out and I have had admin confirmation emails not being sent. My gmex and google pagespeed scores were showing a server response time of over 10 seconds to open a page containing a calendar.

    I've just rolled back to 1.5.2 and everything is good again, pages load quickly and everything seems to work as it has done for the last year or so I've been using this plugin.

    Please take a look at the modified code between 1.5.2 and 1.5.4 as I've seen numerous threads where support suggest it may be the hosting package the end user is running etc but user responses suggest the hosting is unchanged but performance is seriously reduced. This is certainly the case for me, I have actually upgraded my web server but with 1.5.4 the performance was awful compared to previous versions.

  • Luís
    • Support

    @GerardoHi @Gerardo and @Michael,

    Honestly, I can't reproduce the issue in my install. Besides that I tested the performance and again, I don't see any differences in the page loading.

    I flagged the SLS team (our code experts :slight_smile: ) to investigate further and get their valuable feedback.

    Since this team deals with more advanced threads it may take them longer to reply.

    @Gerardo, if possible, can you send the FTP details from one of your fresh installs where you referred that are getting the issue.

    Cheers, Luís

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.