Title: bgswebmaster's Replies | WordPress.org

---

# bgswebmaster

  [  ](https://wordpress.org/support/users/bgswebmaster/)

 *   [Profile](https://wordpress.org/support/users/bgswebmaster/)
 *   [Topics Started](https://wordpress.org/support/users/bgswebmaster/topics/)
 *   [Replies Created](https://wordpress.org/support/users/bgswebmaster/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/bgswebmaster/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/bgswebmaster/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/bgswebmaster/engagements/)
 *   [Favorites](https://wordpress.org/support/users/bgswebmaster/favorites/)

 Search replies:

## Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Database update error](https://wordpress.org/support/topic/database-update-error-4/)
 *  [bgswebmaster](https://wordpress.org/support/users/bgswebmaster/)
 * (@bgswebmaster)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-update-error-4/#post-15912246)
 * 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.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] RANDOM_BYTES does not exist](https://wordpress.org/support/topic/random_bytes-does-not-exist/)
 *  [bgswebmaster](https://wordpress.org/support/users/bgswebmaster/)
 * (@bgswebmaster)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/random_bytes-does-not-exist/#post-15912235)
 * I am having this same issue on namehero server with Event Manager plugin.
 *     ```
       Events Manager is trying to update your database, but the following error occured:
   
       FUNCTION broomfie_wp92.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 wph1_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 wph1_em_tickets_bookings SET ticket_uuid= UUID()
       ```
   
 * And the 1st SQL update fails since the function does not exist and the 2nd SQL
   update gives 0 records updated.
 * Please help!

Viewing 2 replies - 1 through 2 (of 2 total)