I use Amelia with WooCommerce integration and up until now once I completed the order on Woocommerce the booking would appear on my calendar in the backend, but recently I had 3 bookings each was completed in Woocommerce but none are showing up in amelia calendar. I have tried adding the appointment manually but that does not work either the inputs all turn green but the appointment is not added and the box just stays up like I haven’t completed something. This is really annoying and I have no idea what would cause this issue all of a sudden. The appointments do not show up on any part of Amelia neither in the appointment page nor the calendar.
That's unfortunate since these types of issues require for us to check the database as well. I checked again your website and when tried to make an appointment I got this error: "Unable to add data in AmeliaBooking\Infrastructure\Repository\Booking\Appointment\AppointmentRepository" (please see attachment).
This means that the appointments/the parameters can't be created in the database (they are not accepted by the server) for some reason. Could you please check with your host provider about this? Maybe they changed something so it blocks the appointments from Amelia to be made in the database.
We will check this out and get back to you. But this is definitely due to some setting on the server. And regarding their explanation we don't hard code anything in wp-load.php so this is not the case. You said that Amelia was working before, and you haven't changed anything in Amelia so it just stopped working (creating the appointments). When you Google the Error 500, you will see why I am saying it is up to the server. They probably changed some setting there (probably some security) and the appointments stopped creating.
But we will check this out and see if we can find the issue/solution and get back to you,
We checked out the database, since we thought that maybe something was wrong with the database, but this is not the case, for now.
For further debugging we need your permission to debug in the plugin editor (or if you can give as access to the file system (FTP) there), so please give us permission for this and please ask FlyWheel to leave the access for us until we debug and find the issue.
The problem is that Amelia table names have been changed (they have a new prefix: e.g. wp_ppxq2lanx5_amelia_services). While the constraints definition have not been changed (they are using old table names: e.g. wp_amelia_services). The tool that was used for changing table names didn't do the renaming correctly. The solution is to return old prefix, or to change tables constraints manually. If you have any troubles doing this please let us know, we will help you out.
But it would be good if you haven't changed this, to ask your hosting provider if they did it and which tool they used for it. (and let them know that this caused an issue)
If you have any further questions or concerns feel free to ask,
Thanks for this. Yes, i think when the site was moved from the development domain to the final hosting company the table prefixes are different. We'll need to change tables constraints manually. As you've offered I would love some help doing that, thanks.
Thanks Marija, That looks like it's all working as expected now.
In the future I may need to do this again. I really like the plugin and I'm sure my other clients will be interested to use it too. Do you have some instructions to change tables constraints manually?
Sent a question about this yesterday and was directed here. Here is my original ticket - https://wordpress.org/support/topic/cannot-make-appointment-and-calendar-shows-nothing/#post-12038255
My issue:
I use Amelia with WooCommerce integration and up until now once I completed the order on Woocommerce the booking would appear on my calendar in the backend, but recently I had 3 bookings each was completed in Woocommerce but none are showing up in amelia calendar. I have tried adding the appointment manually but that does not work either the inputs all turn green but the appointment is not added and the box just stays up like I haven’t completed something. This is really annoying and I have no idea what would cause this issue all of a sudden. The appointments do not show up on any part of Amelia neither in the appointment page nor the calendar.
Hello clockworkmoggy,
Thanks for the credentials!
Could you please give as permission for your database as well? Please send us PhpMyAdmin credentials.
Thanks!
Hello clockworkmoggy,
That's unfortunate since these types of issues require for us to check the database as well. I checked again your website and when tried to make an appointment I got this error: "Unable to add data in AmeliaBooking\Infrastructure\Repository\Booking\Appointment\AppointmentRepository" (please see attachment).
This means that the appointments/the parameters can't be created in the database (they are not accepted by the server) for some reason. Could you please check with your host provider about this? Maybe they changed something so it blocks the appointments from Amelia to be made in the database.
Hello Neil,
Thanks!
We will check this out and get back to you. But this is definitely due to some setting on the server. And regarding their explanation we don't hard code anything in wp-load.php so this is not the case. You said that Amelia was working before, and you haven't changed anything in Amelia so it just stopped working (creating the appointments). When you Google the Error 500, you will see why I am saying it is up to the server. They probably changed some setting there (probably some security) and the appointments stopped creating.
But we will check this out and see if we can find the issue/solution and get back to you,
Hello Neil,
You are welcome.
We checked out the database, since we thought that maybe something was wrong with the database, but this is not the case, for now.
For further debugging we need your permission to debug in the plugin editor (or if you can give as access to the file system (FTP) there), so please give us permission for this and please ask FlyWheel to leave the access for us until we debug and find the issue.
Thanks.
Hello Neil,
We tried to login but we couldn't access SFTP. Please see the attachment.
Could you please check if we have permission to enter the SFTP? If not, could you please change this permission so we can access the SFTP. Thanks!
I just created a new user and tried using the quickconnect on Filezilla, judging from the screenshot you're using the same program.
Firstly please make sure that host: is set to sftp://ftp.flywheelsites.com - looks to me like you're missing the ftp. part at the in your screenshot.
Secondly when I used quickconnect it fired a popup "Unknown host key". You'll have to check the box in the box in that popup to continue.
I hope that helps.
Kind Regards,
Neil
Hello Neil,
OK, thanks for the clarifications. Hopefully, everything will work now.
I will get back to you as soon as we check the issue out,
Thanks Marija.
Hello Neil,
The problem is that Amelia table names have been changed (they have a new prefix: e.g. wp_ppxq2lanx5_amelia_services). While the constraints definition have not been changed (they are using old table names: e.g. wp_amelia_services). The tool that was used for changing table names didn't do the renaming correctly. The solution is to return old prefix, or to change tables constraints manually. If you have any troubles doing this please let us know, we will help you out.
But it would be good if you haven't changed this, to ask your hosting provider if they did it and which tool they used for it. (and let them know that this caused an issue
)
If you have any further questions or concerns feel free to ask,
Hi Marija,
Thanks for this. Yes, i think when the site was moved from the development domain to the final hosting company the table prefixes are different. We'll need to change tables constraints manually. As you've offered I would love some help doing that, thanks.
Is there anything you need from me?
Kind Regards,
Neil
Hello Neil,
One of our developers changed the constraints. Could you please check it out and let me know if everything works well now ? Thanks!
Thanks Marija, That looks like it's all working as expected now.
In the future I may need to do this again. I really like the plugin and I'm sure my other clients will be interested to use it too. Do you have some instructions to change tables constraints manually?
Thanks very much for the excellent support.