i have Amelia installed and setup properly. Testmails are sending fine but a frontend booking doesn't send any confirmation to me or the client. The booking registration itself is also saved in the database and visible in the backend.
Forms are active of course.
I used PJP and WP Send, and now switched to SMTP. As said: all internal testmails worked perfectly with all modes.
Thank you for purchasing our product, and for reaching out to us.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
You didn't configure SMTP properly you set up port 25 instead 587
We are sending you the link where you can read more about SMTP configuration and we are sending you the configuration bellow
SMTP (Simple Mail Transfer Protocol) – In this article, we show how to configure SMTP mail service for Gmail, but you can set it up for any other outgoing service that supports SMTP for a mail client. When you select this option, four inputs will appear – you need to populate them in to configure SMTP properly. A Google SMTP example:
SMTP Host – smtp.gmail.com
SMTP Port – 465 (SSL) or 587 (TLS)
SMTP Secure – SSL, TLS or Disabled
SMTP Username – Your Gmail address
SMTP Password – Your Gmail password
For Gmail, it is also necessary also to turn on the “Allow less secure apps” option in your Gmail account.
Hope this helps.
If you have any more questions please feel free to open another ticket.
Port 25 for TLS was the recommended setting from the Hosting Provider. It's not common, but it worked and as said - i got the test mails from internal tests.
I now switched to 587 (also possible as alternative) and also received the internal test mail sending from notifications Panel. Unfortunately, like before, i still don't receive any mails from Bookings.
Does the internal Test fires with another sending method than the global setting?
When we inspect your page we can see that you have several errors in your console
The 500 Internal Server Error is a server-side error, meaning the problem probably isn't with your computer, Internet connection or plug ins but instead is a problem with the web site's server.
A 404 error message is a Hypertext Transfer Protocol (HTTP) status code indicating the server could not find the requested website. In other words, your web browser can connect with the server, but the specific page you're trying to access can't be reached.
Can you please investigate your server log and see if there is some errors, please contact you hosting provider also to check that you do not have some issues with permisions.
When we try to cancel the event for Amelia Test customer and when we try to delete it we can't we get the errors above.
thanks. This is a huge step forward. I also tested the booking and saw an error for "post". I contacted the Server admin now and will get back to you, if i know more.
we tested some things but nothing helps.Server seems to be OK and we test wise changed From PHP7.4 o 8. I also deactivated all unnecessary Plugins. But sending still leads to error 500. If i follow that error inside the console i get this here:
{"message":"Unable to find event by id in AmeliaBooking\\Infrastructure\\Repository\\Booking\\Event\\EventRepository SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"}
This can happen when your database is configured to use SQL_BIG_SELECTS, but Amelia has that turned off by default because the majority of databases don't use it.
If you know your way around the database, you can enable this yourself by going into the wp_options database table (wp_ is the default database prefix, but it could be anything on your end):
In there, click on SEARCH at the top, and in the "option_name" column search for "amelia_settings":
The search will return only one row, and you need to edit it:
In "option_value" column, search for "pdoBigSelect":
It is currently set to false, as you can see in the screenshot above, so just change that to true, save the settings, and try editing the event again.
If that fails, or if you're not familiar with phpMyAdmin, please provide us with a temporary wp-admin (administrator) user for your website, along with the database access credentials (phpMyAdmin or cPanel), and I'll gladly take a look.
If you are going to provide us with a temporary wp-admin (administrator) user for your website please make sure that you check the PRIVATE button for a response since this is a public ticket.
Hi,
i have Amelia installed and setup properly. Testmails are sending fine but a frontend booking doesn't send any confirmation to me or the client.
The booking registration itself is also saved in the database and visible in the backend.
Forms are active of course.
I used PJP and WP Send, and now switched to SMTP. As said: all internal testmails worked perfectly with all modes.
Best,
Torsten
Hello Torsten,
Thank you for purchasing our product, and for reaching out to us.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Torsten,
You didn't configure SMTP properly you set up port 25 instead 587
We are sending you the link where you can read more about SMTP configuration and we are sending you the configuration bellow
For Gmail, it is also necessary also to turn on the “Allow less secure apps” option in your Gmail account.
Hope this helps.
If you have any more questions please feel free to open another ticket.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Marko,
Port 25 for TLS was the recommended setting from the Hosting Provider. It's not common, but it worked and as said - i got the test mails from internal tests.
I now switched to 587 (also possible as alternative) and also received the internal test mail sending from notifications Panel. Unfortunately, like before, i still don't receive any mails from Bookings.
Does the internal Test fires with another sending method than the global setting?
Best
Torsten
Hello Torsten,
We have forwarded your ticket to our level 2 agents and as soon as we get some feedback from them we will contact you immediately.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Torsten,
When we inspect your page we can see that you have several errors in your console
The 500 Internal Server Error is a server-side error, meaning the problem probably isn't with your computer, Internet connection or plug ins but instead is a problem with the web site's server.
A 404 error message is a Hypertext Transfer Protocol (HTTP) status code indicating the server could not find the requested website. In other words, your web browser can connect with the server, but the specific page you're trying to access can't be reached.
Can you please investigate your server log and see if there is some errors, please contact you hosting provider also to check that you do not have some issues with permisions.
When we try to cancel the event for Amelia Test customer and when we try to delete it we can't we get the errors above.
Looking forward to your reply.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Marko,
thanks. This is a huge step forward. I also tested the booking and saw an error for "post".
I contacted the Server admin now and will get back to you, if i know more.
Thanks
Torsten
Hello Torsten,
We are glad to help in any way we can. Please do reach out to them and let us know if everything is back in order after that.
Looking forward to your reply.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Marco,
we tested some things but nothing helps.Server seems to be OK and we test wise changed From PHP7.4 o 8.
I also deactivated all unnecessary Plugins. But sending still leads to error 500.
If i follow that error inside the console i get this here:
https://www.ts-medicare.de/wp-admin/admin-ajax.php?action=wpamelia_api&call=/bookings/success/20
{"message":"Unable to find event by id in AmeliaBooking\\Infrastructure\\Repository\\Booking\\Event\\EventRepository SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"}
Best
Torsten
Hello Torsten,
This can happen when your database is configured to use SQL_BIG_SELECTS, but Amelia has that turned off by default because the majority of databases don't use it.
If you know your way around the database, you can enable this yourself by going into the wp_options database table (wp_ is the default database prefix, but it could be anything on your end):
In there, click on SEARCH at the top, and in the "option_name" column search for "amelia_settings":
The search will return only one row, and you need to edit it:
In "option_value" column, search for "pdoBigSelect":
It is currently set to false, as you can see in the screenshot above, so just change that to true, save the settings, and try editing the event again.
If that fails, or if you're not familiar with phpMyAdmin, please provide us with a temporary wp-admin (administrator) user for your website, along with the database access credentials (phpMyAdmin or cPanel), and I'll gladly take a look.
If you are going to provide us with a temporary wp-admin (administrator) user for your website please make sure that you check the PRIVATE button for a response since this is a public ticket.
Looking forward to your reply.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Marko,
i could change the value and after all, it works now.
I've lost some basic settings like Global Colours, Mail Settings and Sending-Parameters for messages. But all in all, this is fine now.
Thanks
Torsten
Hello Torsten,
We are glad that we managed to help you and we are sorry to hear that you have lost some settings, we hope that this will not happen to you again.
We wish you all the best and if you have any more questions please feel free to open another ticket we will gladly help you there.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables