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 #3984762
Critical Error After Latest Update – Cannot Edit Services & Calendar Buffering (Collation Conflict)
Closed

Comments

  • Oki Tensao started the conversation
    2 weeks ago on May 7, 2025 at 9:04am

    Hi Amelia Support,

    I’m experiencing a critical issue after updating Amelia to the latest version.

    Issue Summary:

    • I can no longer edit services. The page only displays the “Add Category” button.

    • Services and Calendar pages keep loading indefinitely.

    • When inspecting the browser console, I receive the following error:

    jquery-migrate.min.js?ver=3.4.1:2 JQMIGRATE: Migrate is installed, version 3.4.1
    wp-admin/admin-ajax.php?action=wpamelia_api&call=/entities&types=employees,categories,locations,packages,entitiesRelations,customFields,taxes&page=booking&lite=true:1 
    Failed to load resource: the server responded with a status of 500 ()
    stepForm.0d506831.js:8 Uncaught (in promise) Error: Request failed with status code 500
        at l3 (stepForm.0d506831.js:8:15976)
        at ZP (stepForm.0d506831.js:8:16100)
        at XMLHttpRequest.h (stepForm.0d506831.js:9:1820)

    And also this message:

    "Unable to find by id in AmeliaBooking\Infrastructure\Repository\User\ProviderRepository SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation '>='"

    What I’ve Tried:

    • I’ve updated collation on all related Amelia tables via phpMyAdmin to utf8mb4_unicode_ci, but the error still persists.

    • When I enable “Load Entities on Page Load” in the Activation settings, the same collation conflict error reappears.

    Why This is Critical:

    I am running this booking system for a real customer in Indonesia who paid over $300 USD. These bugs are affecting our business and client trust. I’m under pressure and getting very frustrated because I cannot fix it even after hours of debugging and applying solutions.

    Request:

    • Please help resolve this collation conflict immediately.

    • If possible, provide a patch, workaround, or updated query structure that avoids this charset/collation incompatibility.

    • And please do something if the problem not in collation.

    I’m happy to provide wp-admin if necessary to speed up the investigation.

    Thank you for your support.

    Best regards,
    Oki Tensao

    Attached files:  Screenshot 2025-05-07 170109.png
      Screenshot 2025-05-07 170135.png
      Screenshot 2025-05-07 170155.png
      Screenshot 2025-05-07 170244.png

  •   Marko replied privately