We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
We are in the middle of a marketing campaign and our customers can't subscribe for the event. While services work finde, I'm not able to edit events in the Wordpress backend either. I'm waiting for any type of reply since yesterday. Please help us or we need to find another solution.
That's the error message in the console: 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
Sincerely,
Tim
Hello Tim
Sorry for the late response, we're not working on weekends, and a lot of tickets came in during weekend, so our response times are longer than usual.
You need to make some alterations in our code, in ../wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/ActivationSettingsHook.php:
That 'pdoBigSelect' is set to false by default, so you need to change it to true, and also in wp_options database table, under option_name search for "amelia_settings". That returns only one row, and you'll need to edit that; change option_value's entry from "pdoBigSelect":false to "pdoBigSelect":true.
After that you will have no issues with events.
Please save my response in case our developers cannot include this in the plugin's built-in features for the next update, as you will need to go into ../wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/ActivationSettingsHook.php again and make the same change when the plugin updates.
I hope they'll be able to implement it, though.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 Aleksandar,
due to the late response I had to hire a freelance developer over the weekend who fixed it for me.
It's working now.
Hi again Tim
I'm sorry to hear you had to waste your resources on this.
Amelia doesn't have any time zone settings, it inherits the time zone from WordPress. If your time zone is in UTC+/- format, please change it by selecting the city near you. Also, please check if you enabled "Show bookings in customer's time zone" in Amelia's General settings.
If you are in a different time zone than your WordPress site is, and you've enabled this option, the times on front-end will show available time slots in your time zone, which will be the time you set in back-end +/- the time difference (depending on where you are in regards to the time zone set in WordPress' General settings).
When it comes to Google Calendar, it also has its own time zone settings, so make sure that the time zone in your Google Account is the same as it is in WordPress.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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