Check-in fails because of SQL error

About Support App Check-in fails because of SQL error

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #11128
    Avatar for Richard HughesRichard Hughes
    Participant

    App Menu -> Check In.
    On submit, the app give error. Please help. We are going “live” with our Check-in Attendance in March.

    Log files show this.

    SQL

    [27-Feb-2025 04:20:24 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 t
    o use near '\"1\",\"0\","service","3","2025-02-26")' at line 1 for query INSERT INTO wp_church_admin_attendance (adults,children,mtg_type,service_id,<code>date</code>) VALUES (\"1\",\"0\
    ","service","3","2025-02-26") made by do_action('wp_ajax_nopriv_ca_app'), WP_Hook->do_action, WP_Hook->apply_filters, church_admin_app_ajax, church_admin_app_new_checkin
    [27-Feb-2025 04:20:24 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 t
    o use near '\"0\",\"1\","service","3","2025-02-26")' at line 1 for query INSERT INTO wp_church_admin_attendance (adults,children,mtg_type,service_id,<code>date</code>) VALUES (\"0\",\"1\
    ","service","3","2025-02-26") made by do_action('wp_ajax_nopriv_ca_app'), WP_Hook->do_action, WP_Hook->apply_filters, church_admin_app_ajax, church_admin_app_new_checkin
    
    Attachments:
    You must be logged in to view attached files.
    #11131
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Will sort later today

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.