Database update error
-
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.
- The topic ‘Database update error’ is closed to new replies.