Unable to make appointment due to database error

Support › Unable to make appointment due to database error
0 Vote Up Vote Down
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', '94.225.247.189', '') 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
0 Vote Up Vote Down
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
0 Vote Up Vote Down
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  [217.70.186.97] www.puurhalle.com and [217.70.186.97] 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,
Nikola