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!

Okay
  Public Ticket #2894574
Bug with Events back-end
Closed

Comments

  • Elodie started the conversation

    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. 

  • Elodie replied

    UPDATE :

    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"

    }

  • [deleted] replied

    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. 

  •   Elodie replied privately
  •   [deleted] replied privately
  •   Aleksandar replied privately
  •   Elodie replied privately
  •  2,576
    Aleksandar replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  •   Elodie replied privately
  •   Aleksandar replied privately