Easyappointments not accepting bookings

Support forumCategory: BugsEasyappointments not accepting bookings
Kostis Tsarpalis asked 6 years ago
Dear Nikola, My plugin seems to not work since yesterday. The link is here. Specifically, two thingsare happening: 1. It does not accept any new bookings. When you try to make a booking nothing happens. Just inactive without any specific notification. 2. It seems to not show the unavailable slots, whereas up to now it was perfectly synchronised with my google calendar.  I would appreciate any help/ideas/advice. Thanks a lot, Kostis
3 Answers
Nikola Loncar Staff answered 6 years ago
Hi Kostis, can you please tell me have you changed your password for Google account that was used? Also is there any error log inside hosting error file? Best regards, Nikola
alex.seidanis replied 6 years ago

Hello Nikola,

This is Alex, supporting Kostis with his site. The errors logged on the server during my attempt to register an appointment on the front end were these:

[Tue Sep 04 00:41:00.710076 2018] [fcgid:warn] [pid 19094:tid 140570412230400] [client 5.144.209.86:52844] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘4’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace, referer: https://www.tsarpalis.gr/el/o-iatros/kleiste-rantevou/
[Tue Sep 04 00:41:07.075548 2018] [fcgid:warn] [pid 19094:tid 140570655618816] [client 5.144.209.86:52952] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘4’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace, referer: https://www.tsarpalis.gr/el/o-iatros/kleiste-rantevou/
[Tue Sep 04 00:42:10.637842 2018] [fcgid:warn] [pid 55380:tid 140570968590080] [client 5.144.209.86:54264] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘6’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace, referer: https://www.tsarpalis.gr/el/o-iatros/kleiste-rantevou/
[Tue Sep 04 00:44:48.878426 2018] [fcgid:warn] [pid 55380:tid 140570789902080] [client 5.144.209.86:56616] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘6’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace, referer: https://www.tsarpalis.gr/el/o-iatros/kleiste-rantevou/
[Tue Sep 04 00:45:28.404281 2018] [fcgid:warn] [pid 55380:tid 140570487764736] [client 5.144.209.86:57206] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘6’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace
[Tue Sep 04 00:45:53.085549 2018] [fcgid:warn] [pid 55380:tid 140570781509376] [client 5.144.209.86:57476] mod_fcgid: stderr: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Duplicate entry ‘0’ for key ‘PRIMARY’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7 INSERT INTO `3Dct7_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES (‘1’, ‘6’, ‘1’, ‘2018-09-05’, ‘2018-09-05′, ’09:00’, ‘reservation’, ‘0.00’, ’09:30′, ‘5.144.209.86’, ”) \xce\xb1\xcf\x80\xcf\x8c do_action(‘wp_ajax_ea_res_appointment’), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace

Please note that appointments can be successfully registered through the dashboard / back-end, just not on the front-end. Would a DB dump help at all?

Alex Seidanis
Web Developer

Nikola Loncar Staff answered 6 years ago
Hi Alex, it is converting strings into unicode chars. As you can see it from here \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 I am not sure why that is done on your site. Have you some kind of localization plugin? Best regards, Nikola
alex.seidanis replied 6 years ago

That doesn’t make sense. All plugins were in place long before the appointments stopped working. The only thing changed was to switch to https. I’ll try a clean installation and if that doesn’t work either, you’ll be required to making this work under https.

alex.seidanis replied 6 years ago

A closer look to the errors above points that the actual error is “Duplicate entry ‘0’ for key ‘PRIMARY’”, and it seems this was not set to autoincrement. I fixed that in the DB, and now it creates an entry in the DB, but without any customer info, while the front-end user is confronted with an “undefined” error.

Nikola Loncar Staff replied 6 years ago

It shouldn’t be like that when I look at error log that part is called with EADBModels->replace so it should not try to do the insert if there is already ID defined. This is first time to see something like that. 🙁

Best regards,
Nikola

konstantinos_tsarpalis answered 6 years ago
Hi Nikola, everything is fixed now! It seems that the fault started from our side when we tried to install SSL to the site, creating a snowball reaction of malfunctions (at least that's how I understand it as a non-expert). This is all fixed now from our part and the plugin works great, as before. Thanks for your responses and for you time! Best regards, Kostis
Nikola Loncar Staff replied 5 years ago

Thanks for the updated Kostis 🙂

Best regards,
Nikola