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,572
    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