[ad_1]
I had the Pro version, but did not renew the subscription a year ago, but left it installed. Now I get errors and messages I need to update the Pro version. So this time I deleted the Pro plugin.
But even after deinstallation I get errors about Pro not being able to update the database:
Events Manager is trying to update your database, but the following error occured:
FUNCTION u133439p128281_2.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_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_em_tickets_bookings SET ticket_uuid= UUID()How do I get rid of the error and Pro-parts. The reservation is not fully functioning now (for the free version even).
The page I need help with: [log in to see the link]