Database update error

  • Resolved Cheryl

    (@tricheryltops)


    2 years, 1 month ago

    Hi,
    I just started getting the following message in my wp-admin area:

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

FUNCTION pwdkxqqjfm.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_hboz_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_hboz_em_tickets_bookings SET ticket_uuid= UUID()

    I tried running the query. The first one returned the same error about RANDOM_BYTES not existing. The second one said it was successful but the error message recurs.

    I don’t use the bookings function. How can I fix this? Thanks.

Viewing 15 replies - 1 through 15 (of 19 total)
1 2
  • Head Goldfish

    (@shoelaced)

    2 years, 1 month ago

    Experiencing the same issue.

    Jos Klever

    (@josklever)

    2 years, 1 month ago

    The function RANDOM_BYTES doesn’t exist in MariaDB versions <10.10.0
    This version is still in Alpha phase, so this should not run on any production server.

    Thread Starter Cheryl

    (@tricheryltops)

    2 years, 1 month ago

    Well, I’m not sure what to do. The only settings for MariaDB available on my hosting platform were 10.1,10.2,10.3,10.4,10.5, and 10.6. I changed the version to see if it would made a difference. It did not, and now I cannot downgrade.

    Jos Klever

    (@josklever)

    2 years, 1 month ago

    I’ve downgraded to 6.0.1 for now. You can download it at the bottom of https://wordpress.org/plugins/events-manager/advanced/ or use a plugin like WP Rollback.
    After the rollback I still needed to close the notification, but I hope this gets fixed soon in 6.1.1

    Henning Stummer

    (@henningstummer)

    2 years, 1 month ago

    I have the same error. But I don’t use the booking function – therefor the table is empty.

    Please put a “Dismiss” button on that notification.

    Kristian Yngve

    (@kristianngve)

    2 years, 1 month ago

    Same – I don’t use the booking function – therefore the table is empty.

    I will “Dismiss” button on that notification in hopes they get their act together and fix this self-made bug 🙁

    PS: I wish they would consider all aspects before doing reckless things like this – as plugin creators. Personally, I see it as irresponsible and can encourage harmful plugin ratings.

    I express this as I googled the issue and their competitors keep coming up at the top of Google promising solutions and better UI ~

    I’ll await the update and close down this buggy warning for now in hopes they’re not damaging my Database … ugggh

    EDIT: the notification doesn’t go if you change pages – god damn it…

    arnoschouten

    (@arnoschouten)

    2 years, 1 month ago

    I did an install on a fresh wordpress installation. No errors.

    • This reply was modified 2 years, 1 month ago by arnoschouten.
    tnchuntic

    (@tnchuntic)

    2 years, 1 month ago

    Here too experiencing issue no idea what cause the issue. Any updates from the author/developer?

    rcamorc

    (@rcamorc)

    2 years, 1 month ago

    This error occurred on my website too. Tried both queries, but nothing happened.

    Lawrence DAINES

    (@ldaines)

    2 years, 1 month ago

    Experiencing the same issue.
    I tried running the queries. The first one returned error:
    FUNCTION axedit_steph.RANDOM_BYTES does not exist
    The second one was successful but the error message is still there.

    bgswebmaster

    (@bgswebmaster)

    2 years, 1 month ago

    Ditto here as well.

    Run the queries…
    The first one returned error:
    FUNCTION axedit_steph.RANDOM_BYTES does not exist.

    The second one was successful but 0 records updated.

    The error message is still there.

    dimitri242

    (@dimitri242)

    2 years, 1 month ago

    Experiencing the same issue.

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

FUNCTION dbs8249059.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 CIVpqKBKem_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 CIVpqKBKem_tickets_bookings SET ticket_uuid= UUID()
    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    2 years, 1 month ago

    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.`

    Jos Klever

    (@josklever)

    2 years, 1 month ago

    @netweblogic The dev update seems to work. Hopefully you can check this forum sooner after releasing an update, because you thank @guidodr for mentioning this issue, although I was the one who mentioned it 28 hours earlier here in this topic.

    Guido

    (@guidodr)

    2 years, 1 month ago

    Jos @josklever you’re right, you have been earlier with your hint. 😉
    Probably your hint was just overseen.

    I only had seen your post after I had already analyzed and posted it in another thread that was titled with “RANDOM_BYTES does not exist”
    There I had also posted the link to the MariaDB Knowledge Base entry for RANDAM_BYTES which probably made it easier for Marcus to solve the problem.

    best regards to the Netherlands
    Guido

Viewing 15 replies - 1 through 15 (of 19 total)
1 2
  • The topic ‘Database update error’ is closed to new replies.

Tags