Support » Plugin: Simply Schedule Appointments – Booking Calendar » We ran into a problem: Internal Server Error

We ran into a problem: Internal Server Error

  • Resolved antonioc197

    (@antonioc197)


    9 months ago

    When booking an appointment it gives the error: We ran into a problem: Internal Server Error. How can we fix this ?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Simply Schedule Appointments Support

    (@simplyscheduleappointments)

    9 months ago

    Hello @antonioc197,

    Could you double-check to make sure you’re using the latest version of the SSA plugin?

    And, if that doesn’t work, could you go to the SSA Admin page > Support tab > scroll to the bottom > turn on the WordPress debug logs. After turning them on, go ahead and try to book an appointment again.

    After you’re done, go back to the debug logs and copy/paste the most recent errors back to this thread. The recent errors should show today’s date.

    If the debug logs don’t show anything obvious, we may need to continue troubleshooting through our support email: support@ssaplugin.com

    Thread Starter antonioc197

    (@antonioc197)

    9 months ago

    Hi,
    We are using version Version 1.4.1.2 which is the latest version.

    WordPress Debug Logs:

    [19-Jan-2021 20:56:43 UTC] WordPress database error Unknown column ‘customer_locale’ in ‘field list’ for query INSERT INTO wp_ssa_appointments (appointment_type_id, rescheduled_from_appointment_id, group_id, author_id, customer_id, customer_information, customer_timezone, customer_locale, start_date, end_date, title, description, price_full, payment_method, payment_received, mailchimp_list_id, google_calendar_id, google_calendar_event_id, allow_sms, status, date_created, date_modified) VALUES (2, 0, 0, 2, 2, ‘{\”Name\”:\”test\”,\”Email\”:\”antonio.cumberbatch2@gmail.com\”,\”Phone\”:\”+1 868 323 7810\”,\”Notes\”:\”test\”}’, ‘America/La_Paz’, ‘en_US’, ‘2021-01-21 18:00:00’, ‘2021-01-21 18:30:00’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘booked’, ‘2021-01-19 20:56:43’, ‘2021-01-19 20:56:43’) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, SSA_Appointment_Model->create_item, TD_API_Model->create_item, SSA_Appointment_Model->insert, TD_Model->insert, TD_DB_Model->db_insert
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 856
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 857
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 856
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 857
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 582
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 856
    [19-Jan-2021 20:56:43 UTC] PHP Notice: Undefined index: id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-model.php on line 857
    [19-Jan-2021 20:56:43 UTC] PHP Fatal error: Uncaught Exception: Invalid SSA_Appointment_Object property: appointment_type_id in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-object.php:108
    Stack trace:
    #0 /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-object.php(257): SSA_Appointment_Object->__get(‘appointment_typ…’)
    #1 /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-object.php(291): SSA_Appointment_Object->get_appointment_type()
    #2 /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-object.php(346): SSA_Appointment_Object->get_calendar_event_title(Object(SSA_Recipient_Customer))
    #3 /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-ics-exporter.php(202): SSA_Appointment_Object->get_customer_calendar_title()
    #4 /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-i in /home/abcpeads/public_html/wp-content/plugins/simply-schedule-appointments/includes/class-appointment-object.php on line 108
    [19-Jan-2021 20:56:53 UTC] WordPress database error Unknown column ‘actioned_text’ in ‘field list’ for query SELECT action_id, name, label, query, status, is_primary, actioned_text
    FROM wp_wc_admin_note_actions
    WHERE note_id = 16 made by set_current_screen, WP_Screen->set_current_screen, do_action(‘current_screen’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, Automattic\WooCommerce\Admin\Notes\Note->__construct, WC_Data_Store->read, Automattic\WooCommerce\Admin\Notes\DataStore->read, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions
    [19-Jan-2021 20:56:53 UTC] WordPress database error Unknown column ‘actioned_text’ in ‘field list’ for query SELECT action_id, name, label, query, status, is_primary, actioned_text
    FROM wp_wc_admin_note_actions
    WHERE note_id = 16 made by set_current_screen, WP_Screen->set_current_screen, do_action(‘current_screen’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, WC_Notes_Run_Db_Update::update_done_notice, Automattic\WooCommerce\Admin\Notes\Note->__construct, WC_Data_Store->read, Automattic\WooCommerce\Admin\Notes\DataStore->read, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions
    [19-Jan-2021 20:56:53 UTC] WordPress database error Unknown column ‘actioned_text’ in ‘field list’ for query REPLACE INTO wp_wc_admin_note_actions (note_id, name, label, query, status, is_primary, actioned_text) VALUES (16, ‘update-db_done’, ‘Thanks!’, ‘https://abcpaediatrics.com/wp-admin/admin.php?page=simply-schedule-appointments%2F&wc-hide-notice=update&_wc_notice_nonce=6701855d6d’, ‘actioned’, 1, ”) made by set_current_screen, WP_Screen->set_current_screen, do_action(‘current_screen’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, WC_Notes_Run_Db_Update::update_done_notice, WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore->update, Automattic\WooCommerce\Admin\Notes\DataStore->save_actions
    [19-Jan-2021 20:56:53 UTC] WordPress database error Unknown column ‘actioned_text’ in ‘field list’ for query SELECT action_id, name, label, query, status, is_primary, actioned_text
    FROM wp_wc_admin_note_actions
    WHERE note_id = 16 made by set_current_screen, WP_Screen->set_current_screen, do_action(‘current_screen’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, WC_Notes_Run_Db_Update::update_done_notice, WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore->update, Automattic\WooCommerce\Admin\Notes\DataStore->save_actions, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions

    Simply Schedule Appointments Plus
    Simply Schedule Appointments Plus

    Interested in getting even more out of SSA? Consider upgrading to our Plus Edition and unlock awesome features like:

    Google Calendar Sync
    Custom Fields
    Mailchimp Integration
    Multiple Bookings in the Same Time Slot
    Book Classes and Group Events

    Plugin Support Simply Schedule Appointments Support

    (@simplyscheduleappointments)

    8 months, 4 weeks ago

    @antonioc197

    Let’s try rebuilding your SSA database.

    > Go to SSA Settings
    > scroll down to and select the Import/Export link at the bottom of the page
    > go ahead and Export all the settings and appointments
    > Copy the export code
    > Paste the code under the Import tab

    Doing this will not harm any of your data or settings, it should only rebuild your SSA database. Since I see a couple of SSA database errors in the error log, hopefully, this can sort through any issues it’s having.

    If not, please contact us at support@ssaplugin.com

    Thread Starter antonioc197

    (@antonioc197)

    8 months, 4 weeks ago

    Hi,

    No luck with this sadly.
    Will contact the suggested email address.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘We ran into a problem: Internal Server Error’ is closed to new replies.

Views