Skip to main content
Solved

MySqlConnection error when trying to complete large appointments

  • 25 June 2024
  • 2 replies
  • 56 views

We get an error that says - ‘This MySqlConnection is already in use. See https://fl.vu/mysql-conn-reuse’ when we try to ‘complete’ large appointments.  Once we get this error message we are unable to cancel, alter, save, complete or bill this appointment.

This has happened on appointments ranging from  25-45 lines.

Anyone have any idea why this is happening and how we can get around the issue?

If anyone else comes across this issue, we had this issue fixed the other day. This error happened even after customisations were removed.  My understanding is that an index was added on one of the appointment tables.


Thank you for sharing your solution with the community @steph23!


Reply