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 #3833911
CSV Dateien und löschen von Veranstaltungen
Closed

Comments

  • Nina started the conversation

    Hallo,


    leider gibt es einige Probleme mit dem PlugIn:


    ich kann Leier nichts löschen, das PlugIn hängt sich auf, sobald ich versuche, eine Veranstaltung zu löschen.

    Außerdem kann ich keine CSV-Dateien downloaden, ich bekomme eine Fehlermeldung:

    {"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"}

    ich habe bereits folgendes versucht:

    - alle plugIn deaktiviert, und sukzessive reaktiviert, um zu schauen, ob ein anderes PlugIn stört, scheint nichts zu stören

    -das Amelia-PlugIn gelöscht und neuinstalliert, allerdings ohne die Daten zu löschen, da dort ich bereits wertvolle Teilnehmerlisten gespeichert habe.

    - cache geleert

    - cdn ausgeschaltet

    - für den csv-download verschiedene variationen mit weniger abzufragenden Daten.


    Ich bitte darum, abzuklären, woher diese Störungen kommen.


    Vielen Dank und mit freundlichen Grüßen

    Nina

  •  1,696
    Uroš replied

    Hello Nina,

    This usually happens when your database is configured to use SQL_BIG_SELECTS, but Amelia has that turned off by default because the majority of databases don't use it.

    If you know your way around the database, you can enable this yourself by going into the wp_options database table (wp_ is the default database prefix, but it could be anything on your end):

    6172199762.png

    In there, click on SEARCH at the top, and in the "option_name" column search for "amelia_settings":

    9596326323.png

    The search will return only one row, and you need to edit it:

    3462547772.png

    In the "option_value" column, search for "pdoBigSelect":

    9685395863.png

    It is currently set to false, as you can see in the screenshot above, so just change that to true, save the settings, and try editing the event again.

    If that fails, or if you're not familiar with phpMyAdmin, please provide us with a temporary wp-admin (administrator) user for your website, along with the database access credentials (phpMyAdmin or cPanel), and I'll gladly take a look.

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  •   Nina replied privately
  •  1,696
    Uroš replied

    Hallo Nina,

    vielen Dank für deine Nachricht!

    Du kannst es jetzt testen, um zu sehen, ob das Problem weiterhin besteht. Lass mich bitte wissen, wenn du auf weitere Probleme stößt, und ich werde dir sofort weiterhelfen.

    Danke für deine Geduld!

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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