WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
SELECT option_name, option_value
FROM rlu_options AS wp_row
WHERE autoload IN ('yes','on','auto-on','auto') AND option_name IN ('AUTOMATOR_PLUGIN_VERSION','uap_database_version','uap_database_views_version','uncannyautomator_source','automator_settings_debug_enabled','automator_settings_debug_notices_enabled','load_automator','automator_delete_user_records_on_user_delete','automator_db_size','automator_last_updated','automator_reporting','automator_over_time','automator_sent_email_completed','automator_dismiss_log_last_dismissed','automator_last_manual_prune_date','automator_manual_purge_days','automator_delete_recipe_records_on_completion','automator_delete_data_on_uninstall','automator_run_hook_listening','uap_automator_pro_license_key','uap_automator_pro_license_status','uap_automator_free_license_key','uap_automator_free_license_status','uap_automator__license_key','uap_automator_free_license_data','uap_automator_pro_license_expiry','uap_automator_pro_license_expiry_notice','uap_automator_pro_license_last_checked','uap_automator_purge_days','uap_automator_purge_unit','uap_automator_slack_api_bot_name','uap_automator_alck_api_bot_icon','automator_open_ai_secret','automator_cohere_api_key','automator_gemini_api_key','automator_claude_api_key','automator_mistral_api_key','automator_grok_api_key','automator_perplexity_api_key','automator_whatsapp_secret','automator_telegram_bot_secret','automator_telegram_webhook','automator_facebook_lead_ads_credentials','automator_telegram_bot_info','automator_async_site_token','automator_api_mode_options','automator_twitter_api_key','automator_twitter_api_secret','automator_twitter_access_token','automator_twitter_access_token_secret','automator_twitter_user','_uncannyowl_twitter_settings','automator_stripe_token','automator_stripe_user','automator_stripe_mode','automator_stripe_webhook_secret_','automator_stripe_webhook_secret','automator_stripe_webhook_secret_live','automator_stripe_webhook_secret_test','uap_zoom_api_connected_user','uap_automator_zoom_api_account_id','uap_automator_zoom_api_client_id','uap_automator_zoom_api_client_secret','uap_automator_zoom_api_settings_version','_uncannyowl_zoom_settings','uap_zoom_webinar_api_connected_user','uap_automator_zoom_webinar_api_account_id','uap_automator_zoom_webinar_api_client_id','uap_automator_zoom_webinar_api_client_secret','uap_automator_zoom_webinar_api_settings_version','uap_automator_zoom_webinar_api_settings_expired','_uncannyowl_zoom_webinar_settings','uap_automator_gtt_api_consumer_key','uap_automator_gtt_api_consumer_secret','_uncannyowl_gtt_settings','_uncannyowl_gtt_settings_expired','uap_automator_gtw_api_consumer_key','uap_automator_gtw_api_consumer_secret','_uncannyowl_gtw_settings','uap_automator_twilio_api_phone_number','uap_automator_twilio_api_account_sid','uap_automator_twilio_api_auth_token','uap_twilio_connected_user','automator_helpscout_client','uap_helpscout_enable_webhook','uap_helpscout_webhook_key','uap_active_campaign_api_url','uap_active_campaign_api_key','uap_active_campaign_connected_user','uap_active_campaign_enable_webhook','uap_active_campaign_webhook_key','uap_mailchimp_enable_webhook','uap_mailchimp_webhook_key','uap_mailchimp_api_key','uap_mailchimp_api_url','_uncannyowl_mailchimp_settings','_uncannyowl_mailchimp_settings_user_info','automator_linkedin_client','automator_linkedin_connected_user','automator_campaign_monitor_credentials','automator_campaign_monitor_account','automator_drip_credentials','automator_microsoft_teams_credentials','automator_microsoft_teams_api_secret','_automator_hubspot_settings','_automator_hubspot_refresh_token_failed_attempts','_automator_hubspot_last_refresh_token_call','automator_mautic_base_url','automator_mautic_username','automator_mautic_password','automator_mautic_credentials','automator_mautic_resource_owner','automator_convertkit_client','automator_convertkit_options_client','automator_convertkit_api_key','automator_convertkit_api_secret','automator_bitly_account_details','automator_bitly_access_token','automator_bitly_credentials','automator_discord_credentials','automator_discord_servers','automator_whatsapp_client','automator_whatsapp_webhook_key','automator_google_contacts_credentials','automator_google_calendar_credentials','automator_google_sheets_migrate_58','automator_google_sheets_spreadsheets','_uncannyowl_google_sheet_settings','uncanny_automator_google_sheets_migrated','automator_clickup_client','_uncannyowl_facebook_group_settings','_uncannyowl_facebook_pages_settings','_uncannyowl_facebook_settings','automator_facebook_group_token_info','ua_facebook_group_saved_groups','automator_popup_maker_migrated','automator_display_popup_','automator_wplms4_to_wplms_migration','automator_rafflepress_hook_migration','automator_tin_canny_trigger_moved','automator_pmpmembershipexpires_updated','automator_buddyboss_universal_tokens','automator_bp_joinprivategroup_updated','automator_bp_profile_trigger_moved','automator_bp_user_removed_from_group_updated','automator_bp_xprofile_fields','bdbuserregisterwithfield_action_migrated','bpuserregisterwithfield_action_migrated','uncanny_automator_background_actions','uncanny_automator_advanced_automator_cache','automator_usage_reports_stats','automator_usage_reports_enabled','automator_recipe_completion_count','automator_usage_reports_page_views','usage_report_stats','automator_migrations','automator_option_types_migration_offset','automator_option_types_migration','uaul_plugin_version','uaul_enabled','uaul_settings','uaul_restriction_message','uarc_plugin_version','uarc_enabled','uarc_restriction_message','uadc_plugin_version','uadc_refresh_interval','uacuf_plugin_version','uacuf_enabled','uacuf_all_fields','uap_cuf_initial_migration_occurred','uaei_plugin_version','uap_pro_db_version','automator_salesforce_token','automator_salesforce_user','automator_salesforce_api_key','uap_quickbooks_credentials','uap_quickbooks_site_identifier','uap_quickbooks_vault_signature','uap_quickbooks_company_profile','quickbooks_credentials','quickbooks_site_identifier','quickbooks_vault_signature','uoa_setup_wiz_has_connected','automator_ai_provider_api_key','automator_notifications_settings','automator_notification_dismissed','automator_notifications','automator_review_dismissed','automator_review_conditions_met','automator_db_size','automator_manual_purge_days','automator_last_manual_prune_date','automator_dismiss_log_last_dismissed','automator_settings_debug_enabled','automator_settings_debug_notices_enabled','uap_automator_pro_license_key','uap_automator_pro_license_status','uap_automator_free_license_key','uap_automator_free_license_status','automator_integration_settings','automator_webhook_settings','automator_api_credentials','automator_options_migration_completed','automator_options_migration_timestamp','automator_options_migration_version','automator_Aweber_api_key','automator_aweber_credentials','automator_bluesky_credentials','automator_brevo_account','automator_brevo_api_key','automator_completed_recipes','automator_generator_action_moved','automator_getresponse_account','automator_getresponse_api_key','automator_health_check_generator_moved','automator_health_check_magic_button_moved','automator_health_check_run_code_moved','automator_health_check_webhook_sample_values_moved','automator_in_walkthough_mode','automator_keap_account','automator_keap_companies','automator_keap_company_custom_fields','automator_keap_contact_custom_fields','automator_keap_credentials','automator_keap_tags','automator_keap_users','automator_linkedin_client','automator_magic_button_trigger_moved','automator_mailerlite_api_token','automator_mailerlite_client','automator_notion_credentials','automator_ontraport_api_key','automator_ontraport_app_id','automator_ontraport_is_connected','automator_pro_gform_post_payment_transaction_migrated','automator_pro_mp_usermecancelledprod','automator_pro_mp_usermempausedprod','automator_run_code_trigger_moved','automator_sendy_api','automator_trello_token','automator_triggers_has_migrated','automator_uoa_call_function_everyone_migrate','automator_uoa_do_function_everyone_migrate','automator_wcs_migration_backup','automator_woo_order_item_trigger_migrated','automator_wp_send_email_action_moved__4.3','automator_wpwebhooks_action_moved','automator_wpwebhooks_trigger_moved','automtor_multiple_triggers_restore_failed_logs','ld_failquiz_action_migrated','ld_passquiz_action_migrated','UO_REDIRECTURL_0','uoa_recipe_completed_migrated','uoa_recipenumtimes_changed_to_numtimes','USERROLEADDED_migrated','webhook_key_github','wp_elementor_after_post_insert_action_migrated','zoho_campaigns_credentials','zoho_campaigns_credentials_last_refreshed','affwp_insert_referral_migrated','_uncanny_automator_tracking_reminder','_uncanny_automator_tracking_reminder_date','_uoa_sendwebhook_wp_uoa','_uoa_sendwebhook_wp_uoa_any','_uoa_wpanonwebhook_wp_uoa','_uoa_wpanonwebhook_wp_uoa_any','_uoa_wpmagicbutton_wp_uoa','_uoa_wpmagicbutton_wp_uoa_any')
AND NOT EXISTS (
SELECT 1 FROM rlu_uap_options AS uap_row
WHERE uap_row.option_name = wp_row.option_name
)
ALEXANDRA BURLAKA
NADAV BEN-DAHAN
October 25, 2023