{"id":15909138,"date":"2022-08-11T18:50:39","date_gmt":"2022-08-11T18:50:39","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-update-error-4\/"},"modified":"2022-08-11T18:50:39","modified_gmt":"2022-08-11T18:50:39","slug":"database-update-error-4","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-update-error-4\/","title":{"rendered":"Database update error"},"content":{"rendered":"<p>Hi,<br \/>\nI just started getting the following message in my wp-admin area:<\/p>\n<pre><code>Events Manager is trying to update your database, but the following error occured:\n\nFUNCTION pwdkxqqjfm.RANDOM_BYTES does not exist\n\nIt 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:\n\nUPDATE wp_hboz_em_bookings SET booking_uuid= LOWER(CONCAT( HEX(RANDOM_BYTES(4)), &#039;&#039;, HEX(RANDOM_BYTES(2)), &#039;4&#039;, SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), &#039;&#039;, HEX(FLOOR(ASCII(RANDOM_BYTES(1)) \/ 64) + 8), SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), &#039;&#039;, hex(RANDOM_BYTES(6)) ))\n\nOR\nUPDATE wp_hboz_em_tickets_bookings SET ticket_uuid= UUID()<\/code><\/pre>\n<p>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.<\/p>\n<p>I don&#8217;t use the bookings function. How can I fix this? Thanks.<\/p>\n","protected":false},"template":"","class_list":["post-15909138","topic","type-topic","status-publish","hentry","topic-tag-errors"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15909138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15909138\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=15909138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}