After adding a new event I m no more able to see the attendees or edit any of my events.
Clicking on the "attendees" button produce no effect and clicking on the "edit" button open the right panel but only show the Amelia's animated logo with the "please wait" text.
I have turn the WP_DEBUG on but don't see any error messages.
The front-end seems to work but my customers tell me that they have registered but neither they nor I receive the confirmation emails.
I absolutely need to know which participant has registered for which event. In an emergency, is there a way to see which customer has reserved via the database?
Regards, Christophe
+ During my tests, before pushing the site live, I also noticed that creating recurring events for a year (a little over 130) created the same problem and I had a PHP error about a to big request.
I just found an error 500 message in the browser console.
Following the link I find this JSON block :
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"
Hi,
After adding a new event I m no more able to see the attendees or edit any of my events.
Clicking on the "attendees" button produce no effect and clicking on the "edit" button open the right panel but only show the Amelia's animated logo with the "please wait" text.
I have turn the WP_DEBUG on but don't see any error messages.
The front-end seems to work but my customers tell me that they have registered but neither they nor I receive the confirmation emails.
I absolutely need to know which participant has registered for which event.
In an emergency, is there a way to see which customer has reserved via the database?
Regards,
Christophe
+ During my tests, before pushing the site live, I also noticed that creating recurring events for a year (a little over 130) created the same problem and I had a PHP error about a to big request.
UPDATE :
I just found an error 500 message in the browser console.
Following the link I find this JSON block :
}
Hi, Christophe,
Sorry to hear that you faced this issue.
Yes, it seems like a BIG SELECT issue.
Our developers might need to add some alterations to the code, so please provide us with the following:
1. a temporary WP Admin login,
2. database access (cPanel or phpMyAdmin credentials),
3. FTP credentials.
Please make sure that you post the credentials in a private reply.
Looking forward to hearing from you.
Great stuff, Christophe, thanks for that!
I enabled BigSelects in your database, and it seems that Events, Attendees, and Event Editing works fine again.
Please check it out, and let me know.
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