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
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'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.
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