Unable to make appointment due to database error

Support forumUnable to make appointment due to database error
papmanou Staff asked 6 years ago
Hi all,   Eachtime I try to add a booking, I receive a popup saying : "Something went wrong, please try again" In the "error-logs" file I can see the following error messages WordPress database error Cannot add or update a child row: a foreign key constraint fails (temp file operation failed) for query INSERT INTO `oxe_ea_appointments` (`location`, `service`, `worker`, `date`, `end_date`, `start`, `status`, `price`, `end`, `ip`, `session`) VALUES ('1', '8', '1', '2018-11-30', '2018-11-30', '09:00', 'reservation', '25.00', '09:30', '', '') made by do_action('wp_ajax_nopriv_ea_res_appointment'), WP_Hook->do_action, WP_Hook->apply_filters, EAAjax->ajax_res_appointment, EADBModels->replace Can someone help me please solving this issue ? Thanks in advance Papmanou
2 Answers
Nikola Loncar Staff answered 6 years ago
Hi Papmanou, looks like somethings is not right with location or service or worker value. Have you put predefine values in short code for that? Best regards, Nikola
papmanou Staff answered 6 years ago
Hi Nikola, Thanks for the answer. I have checked all my IDs (service, location, worker) and everything seems me ok. Working  Request URL: https://www.puurhalle.com/wp-admin/admin-ajax.php?location=1&service=23&worker=1&date=2018-12-01&end_date=2018-12-01&start=09%3A00&check=5c79704052&action=ea_res_appointment   Not working
Request URL: https://www.puurhalle.com/wp-admin/admin-ajax.php?location=1&service=23&worker=1&date=2018-12-01&end_date=2018-12-01&start=09%3A00&check=fe0a11c312&action=ea_res_appointment   the working site url is https://www.puurhalle.com/afspraak the not working site url : please adapt   dns  [] www.puurhalle.com and [] puurhalle.com You help is welcome   Papmanou
Nikola Loncar Staff replied 6 years ago

Hi Papmanou, there is no reason why should be difference between those two calls 🙁

Best regards,