6.1 update error

  • I attempted to update to 6.1 and am now seeing the following on the Dashboard:

    Events Manager is trying to update your database, but the following error occured:

FUNCTION wordpress.RANDOM_BYTES does not exist

It might be that reloading this page one or more times may complete the process, if you have a large number of bookings in your database. Alternatively, you can run one of these two queries directly into your WP database:

UPDATE wp_83_em_bookings SET booking_uuid= LOWER(CONCAT( HEX(RANDOM_BYTES(4)), '', HEX(RANDOM_BYTES(2)), '4', SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), '', HEX(FLOOR(ASCII(RANDOM_BYTES(1)) / 64) + 8), SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), '', hex(RANDOM_BYTES(6)) ))

OR
UPDATE wp_83_em_tickets_bookings SET ticket_uuid= UUID()

    Running the commands leads to:

    MariaDB [wordpress]> UPDATE wp_83_em_bookings SET booking_uuid= LOWER(CONCAT( HEX(RANDOM_BYTES(4)), '', HEX(RANDOM_BYTES(2)), '4', SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), '', HEX(FLOOR(ASCII(RANDOM_BYTES(1)) / 64) + 8), SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), '', hex(RANDOM_BYTES(6)) ));
ERROR 1305 (42000): FUNCTION wordpress.RANDOM_BYTES does not exist
MariaDB [wordpress]> UPDATE wp_83_em_tickets_bookings SET ticket_uuid= UUID();
Query OK, 0 rows affected (0.000 sec)
Rows matched: 0  Changed: 0  Warnings: 0

    and the error is still displayed on the dashboard.

Viewing 1 replies (of 1 total)
  • Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    Hi everyone, sorry for the bug which is now fixed in a dev version you can already get. Here’s my reply on the issue, reposted from this thread:

    For anyone with this issue, we’ve updated a dev version 6.1.0.1 which fixes this specific issue (tested and confirmed). We’ll release a regular update within the next day or sooner.

    To upgrade to a dev version, visit Dashboard > Events > Settings > Admin Tools and click the Check Dev Updates button. You’ll see the update appear on your plugins/updates page. You can also manually update by downloading the dev versions from our downloads page. For more detailed instructions, see our documentation for upgrading to dev versions.

    The issue was mainly related to the adding of UUID for old bookings and ticket bookings, in theory this shouldn’t have affected your installation as the main use of UUIDs are currently for the recent Pro features like QR tickets and checkins.

    It looks like the error is limited to those using MariaDB (correctly identified by @guidodr) instead of mySQL, that RANDOM_BYTES function in the SQL statement is available in MariaDB 10.10 and I believe we misread the min WP version with 10.1 (the trailing 0 made all the difference!). Whilst we usually keep relatively straightforward SQL statements, we’ll be more mindful of our MariaDB users moving forward, should we ever need to add with more complex queries.

Viewing 1 replies (of 1 total)
  • The topic ‘6.1 update error’ is closed to new replies.