[3.12.19] Form fail to render when location is predefined in shortcode
rszewczyk Staff asked 9 months ago
Hi.
In version 3.12.19.
When using bootstrap short code:
[ea_bootstrap width="850px" scroll_off="true" layout_cols="2" select_placeholder="Wybierz usΕugΔ" show_remaining_slots="0" location="2"
Form fails to render list of Workers. Throwing error in PHP:
[Mon Jan 19 18:49:42.331256 2026] [proxy_fcgi:error] [pid 1661] [client :52421] AH01071: Got error 'PHP message: 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 ') ORDER BY `id` ASC' at line 1 for query SELECT * FROM wp_ea_staff WHERE id IN () ORDER BY `id` ASC made by do_action('wp_ajax_nopriv_ea_next_step'), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_front_end, EADBModels->get_next', referer: https://_______.pl/umow/
Removing Location tag from short code fixes the problem.
Easy Appointment Staff answered 8 months ago
Please login or Register to submit your answer
Additional error in PHP log:
[Mon Jan 19 18:49:39.561655 2026] [proxy_fcgi:error] [pid 1661] [client .36:52421] AH01071: Got error ‘PHP message: PHP Warning: Attempt to read property “id” on array in /srv/_____.pl/wp-content/plugins/easy-appointments/src/frontend.php on line 868’
Another finding. This issue is not manifesting itself when there is only one location in the DB wp_ea_locations table.