WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_options`]SELECT option_name, option_value
FROM wpab_options
WHERE autoload = 'yes' 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')
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT option_name, option_value FROM wpab_uap_options WHERE autoload = 'yes'
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'uncanny_automator_advanced_automator_cache'),
(SELECT option_value FROM wpab_options WHERE option_name = 'uncanny_automator_advanced_automator_cache')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'automator_settings_debug_enabled'),
(SELECT option_value FROM wpab_options WHERE option_name = 'automator_settings_debug_enabled')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'AUTOMATOR_PLUGIN_VERSION'),
(SELECT option_value FROM wpab_options WHERE option_name = 'AUTOMATOR_PLUGIN_VERSION')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'AUTOMATOR_PLUGIN_VERSION'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'AUTOMATOR_PLUGIN_VERSION'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('AUTOMATOR_PLUGIN_VERSION', '7.6.1.1', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_postmeta`]SELECT DISTINCT
code_meta.meta_value AS item_code,
int_meta.meta_value AS integration_code
FROM wpab_postmeta code_meta
INNER JOIN wpab_postmeta int_meta
ON int_meta.post_id = code_meta.post_id
AND int_meta.meta_key = 'integration'
INNER JOIN wpab_posts part
ON part.ID = code_meta.post_id
AND part.post_status = 'publish'
AND part.post_type IN ('uo-trigger', 'uo-action', 'uo-closure')
INNER JOIN wpab_posts recipe
ON recipe.ID = part.post_parent
AND recipe.post_status = 'publish'
AND recipe.post_type = 'uo-recipe'
WHERE code_meta.meta_key = 'code'
UNION
SELECT DISTINCT
code_meta.meta_value AS item_code,
int_meta.meta_value AS integration_code
FROM wpab_postmeta code_meta
INNER JOIN wpab_postmeta int_meta
ON int_meta.post_id = code_meta.post_id
AND int_meta.meta_key = 'integration'
INNER JOIN wpab_posts loop_child
ON loop_child.ID = code_meta.post_id
AND loop_child.post_status = 'publish'
AND loop_child.post_type IN ('uo-action', 'uo-closure', 'uo-loop-filter')
INNER JOIN wpab_posts loop_post
ON loop_post.ID = loop_child.post_parent
AND loop_post.post_status = 'publish'
AND loop_post.post_type = 'uo-loop'
INNER JOIN wpab_posts recipe
ON recipe.ID = loop_post.post_parent
AND recipe.post_status = 'publish'
AND recipe.post_type = 'uo-recipe'
WHERE code_meta.meta_key = 'code'
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_postmeta`]SELECT DISTINCT pm.meta_value AS conditions_json
FROM wpab_postmeta pm
INNER JOIN wpab_posts recipe
ON recipe.ID = pm.post_id
AND recipe.post_status = 'publish'
AND recipe.post_type = 'uo-recipe'
WHERE pm.meta_key = 'actions_conditions'
AND pm.meta_value != ''
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'automator_recipe_manifest'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'automator_recipe_manifest'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('automator_recipe_manifest', 'a:3:{s:7:\"version\";i:1;s:8:\"built_at\";i:1789995709;s:4:\"data\";a:0:{}}', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_posts`]SELECT
recipe.ID AS recipe_id,
recipe.post_status AS recipe_status,
recipe_type_meta.meta_value AS recipe_type,
trigger_post.ID AS trigger_id,
trigger_post.post_status AS trigger_status,
trigger_meta.meta_key,
trigger_meta.meta_value
FROM wpab_posts recipe
INNER JOIN wpab_posts trigger_post
ON trigger_post.post_parent = recipe.ID
AND trigger_post.post_type = 'uo-trigger'
AND trigger_post.post_status = 'publish'
INNER JOIN wpab_postmeta trigger_meta
ON trigger_meta.post_id = trigger_post.ID
LEFT JOIN wpab_postmeta recipe_type_meta
ON recipe_type_meta.post_id = recipe.ID
AND recipe_type_meta.meta_key = 'uap_recipe_type'
WHERE recipe.post_type = 'uo-recipe'
AND recipe.post_status = 'publish'
ORDER BY recipe.ID, trigger_post.ID
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'automator_trigger_index'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'automator_trigger_index'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('automator_trigger_index', 'a:0:{}', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'uap_database_version'),
(SELECT option_value FROM wpab_options WHERE option_name = 'uap_database_version')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'automator_over_time'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'automator_over_time'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('automator_over_time', 'a:1:{s:14:\"installed_date\";i:1789995709;}', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'uap_database_version'),
(SELECT option_value FROM wpab_options WHERE option_name = 'uap_database_version')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_count`]DELETE rc FROM wpab_uap_recipe_count rc
INNER JOIN (
SELECT recipe_id, (
SELECT ID FROM wpab_uap_recipe_count rc2
WHERE rc2.recipe_id = grouped.recipe_id
ORDER BY rc2.runs DESC, rc2.ID DESC
LIMIT 1
) AS keep_id
FROM (
SELECT recipe_id
FROM wpab_uap_recipe_count
GROUP BY recipe_id
HAVING COUNT(*) > 1
) grouped
) dup ON rc.recipe_id = dup.recipe_id AND rc.ID != dup.keep_id
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_count`]SHOW INDEX FROM wpab_uap_recipe_count WHERE Key_name = 'recipe_id'
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_log`]CREATE TABLE wpab_uap_recipe_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint unsigned NOT NULL,
`automator_recipe_id` bigint unsigned NOT NULL,
`log_number` bigint unsigned,
`completed` tinyint(1) NOT NULL,
`run_number` mediumint unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (`ID`),
KEY completed (`completed`),
KEY user_id (`user_id`),
KEY automator_recipe_id (`automator_recipe_id`),
KEY recipe_completed (`automator_recipe_id`, `completed`),
KEY date_completed (`date_time`, `completed`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_log_meta`]
CREATE TABLE wpab_uap_recipe_log_meta (
`ID` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint NOT NULL,
`recipe_id` bigint NOT NULL,
`recipe_log_id` bigint NOT NULL,
`meta_key` varchar(255) NOT NULL,
`meta_value` longtext NOT NULL,
PRIMARY KEY (`ID`),
KEY recipe_id (`recipe_id`),
KEY user_id (`user_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_tokens_log`]
CREATE TABLE wpab_uap_tokens_log (
`ID` bigint NOT NULL AUTO_INCREMENT,
`recipe_id` bigint NOT NULL,
`recipe_log_id` bigint NOT NULL,
`run_number` bigint NOT NULL,
`tokens_record` longtext NOT NULL,
`date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
KEY recipe_id (`recipe_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_api_log_response`]
CREATE TABLE wpab_uap_api_log_response (
`ID` bigint NOT NULL AUTO_INCREMENT,
`api_log_id` bigint NOT NULL,
`item_log_id` bigint NOT NULL,
`result` varchar(255) NOT NULL,
`message` text NOT NULL,
`date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_trigger_log`]
CREATE TABLE wpab_uap_trigger_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint unsigned NOT NULL,
`automator_trigger_id` bigint unsigned NOT NULL,
`automator_recipe_id` bigint unsigned NOT NULL,
`automator_recipe_log_id` bigint unsigned NULL,
`completed` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY completed (`completed`),
KEY automator_recipe_id (`automator_recipe_id`),
KEY automator_trigger_id (`automator_trigger_id`),
KEY automator_recipe_log_id (`automator_recipe_log_id`),
KEY trigger_completed (`automator_trigger_id`, `completed`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_trigger_log_meta`]
CREATE TABLE wpab_uap_trigger_log_meta (
`ID` bigint unsigned NOT NULL auto_increment,
`user_id` bigint unsigned NOT NULL,
`automator_trigger_log_id` bigint unsigned NULL,
`automator_trigger_id` bigint unsigned NOT NULL,
`meta_key` varchar(255) DEFAULT '' NOT NULL,
`meta_value` longtext NULL,
`run_number` mediumint unsigned NOT NULL DEFAULT 1,
`run_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY run_number (`run_number`),
KEY automator_trigger_id (`automator_trigger_id`),
KEY automator_trigger_log_id (`automator_trigger_log_id`),
KEY meta_key (meta_key(20))
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_action_log`]
CREATE TABLE wpab_uap_action_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint unsigned NOT NULL,
`automator_action_id` bigint unsigned NOT NULL,
`automator_recipe_id` bigint unsigned NOT NULL,
`automator_recipe_log_id` bigint unsigned NULL,
`completed` tinyint(1) unsigned NOT NULL,
`error_message` longtext NULL,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY completed (`completed`),
KEY automator_action_id (`automator_action_id`),
KEY automator_recipe_log_id (`automator_recipe_log_id`),
KEY automator_recipe_id (`automator_recipe_id`),
KEY action_completed (`automator_action_id`, `completed`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_action_log_meta`]
CREATE TABLE wpab_uap_action_log_meta (
`ID` bigint unsigned NOT NULL auto_increment,
`user_id` bigint unsigned NOT NULL,
`automator_action_log_id` bigint unsigned NULL,
`automator_action_id` bigint unsigned NOT NULL,
`meta_key` varchar(255) DEFAULT '' NOT NULL,
`meta_value` longtext NULL,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY automator_action_log_id (`automator_action_log_id`),
KEY automator_action_id (`automator_action_id`),
KEY meta_key (meta_key(20))
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_closure_log`]
CREATE TABLE wpab_uap_closure_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint unsigned NOT NULL,
`automator_closure_id` bigint unsigned NOT NULL,
`automator_recipe_id` bigint unsigned NOT NULL,
`automator_recipe_log_id` bigint unsigned NOT NULL,
`completed` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY automator_recipe_id (`automator_recipe_id`),
KEY automator_closure_id (`automator_closure_id`),
KEY completed (`completed`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_closure_log_meta`]
CREATE TABLE wpab_uap_closure_log_meta (
`ID` bigint unsigned NOT NULL auto_increment,
`user_id` bigint unsigned NOT NULL,
`automator_closure_id` bigint unsigned NOT NULL,
`automator_closure_log_id` bigint unsigned NOT NULL,
`meta_key` varchar(255) DEFAULT '' NOT NULL,
`meta_value` longtext NULL,
PRIMARY KEY (`ID`),
KEY user_id (`user_id`),
KEY automator_closure_id (`automator_closure_id`),
KEY meta_key (meta_key(15))
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_api_log`]
CREATE TABLE wpab_uap_api_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`type` varchar(255) DEFAULT '' NOT NULL,
`recipe_log_id` bigint unsigned NOT NULL,
`item_log_id` bigint unsigned NOT NULL,
`endpoint` varchar(255) DEFAULT '' NULL,
`params` longtext NULL,
`request` longtext NULL,
`response` longtext NULL,
`status` varchar(255) DEFAULT '' NULL,
`price` bigint unsigned NULL,
`balance` bigint unsigned NULL,
`time_spent` bigint unsigned NULL,
`notes` longtext NULL,
PRIMARY KEY (`ID`),
KEY item_log_id (`item_log_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_count`]
CREATE TABLE wpab_uap_recipe_count (
`ID` bigint unsigned NOT NULL auto_increment,
`recipe_id` bigint unsigned NOT NULL,
`runs` bigint unsigned DEFAULT 0 NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY recipe_id (`recipe_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]
CREATE TABLE wpab_uap_options (
`option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`option_name` varchar(191) NOT NULL DEFAULT '',
`option_value` longtext NOT NULL,
`autoload` varchar(8) NOT NULL DEFAULT 'yes',
`type` varchar(10) NOT NULL DEFAULT 'string',
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`),
KEY `autoload` (`autoload`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_throttle_log`]
CREATE TABLE wpab_uap_recipe_throttle_log (
`ID` bigint unsigned NOT NULL auto_increment,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint unsigned NOT NULL,
`recipe_id` bigint unsigned NOT NULL,
`meta_key` varchar(255) NOT NULL,
`last_run` int unsigned NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `user_recipe_key` (`user_id`,`recipe_id`,`meta_key`),
KEY `cleanup` (`last_run`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_error_log`]
CREATE TABLE wpab_uap_error_log (
`ID` bigint unsigned NOT NULL auto_increment,
`recipe_log_id` bigint unsigned NOT NULL,
`action_log_id` bigint unsigned NULL,
`item_type` varchar(20) DEFAULT 'action' NOT NULL,
`error_code` varchar(50) DEFAULT '' NOT NULL,
`error_message` longtext NULL,
`is_actionable` tinyint(1) unsigned NOT NULL DEFAULT 1,
`error_context` longtext NULL,
`date_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
KEY recipe_log_id (`recipe_log_id`),
KEY action_log_id (`action_log_id`),
KEY error_code (`error_code`),
KEY actionable_by_recipe (`recipe_log_id`, `is_actionable`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [CREATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_run_snapshots`]
CREATE TABLE wpab_uap_run_snapshots (
`ID` bigint unsigned NOT NULL auto_increment,
`recipe_log_id` bigint unsigned NOT NULL,
`recipe_id` bigint unsigned NOT NULL,
`user_id` bigint unsigned NOT NULL,
`snapshot_data` longblob NOT NULL,
`checksum` char(32) NOT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`expires_at` TIMESTAMP NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY recipe_log_id (`recipe_log_id`),
KEY expires_at (`expires_at`),
KEY recipe_user (`recipe_id`, `user_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'uap_database_version'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'uap_database_version'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('uap_database_version', '7.3.1', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_log`]ANALYZE TABLE `wpab_uap_recipe_log`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_action_log`]ANALYZE TABLE `wpab_uap_action_log`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_action_log_meta`]ANALYZE TABLE `wpab_uap_action_log_meta`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_closure_log`]ANALYZE TABLE `wpab_uap_closure_log`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_closure_log_meta`]ANALYZE TABLE `wpab_uap_closure_log_meta`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_trigger_log`]ANALYZE TABLE `wpab_uap_trigger_log`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_trigger_log_meta`]ANALYZE TABLE `wpab_uap_trigger_log_meta`;
WordPress database error: [SELECT, INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_api_log`]ANALYZE TABLE `wpab_uap_api_log`;
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'uap_database_views_version'),
(SELECT option_value FROM wpab_options WHERE option_name = 'uap_database_views_version')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'uap_database_views_version'),
(SELECT option_value FROM wpab_options WHERE option_name = 'uap_database_views_version')
) as option_value
WordPress database error: [CREATE VIEW command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_logs_view`]CREATE OR REPLACE SQL SECURITY INVOKER VIEW wpab_uap_recipe_logs_view AS SELECT
r.ID AS recipe_log_id,
r.user_id,
r.date_time AS recipe_date_time,
r.completed AS recipe_completed,
r.run_number,
r.log_number,
r.completed,
r.automator_recipe_id,
u.user_email,
u.display_name,
p.post_title AS recipe_title
FROM wpab_uap_recipe_log r
LEFT JOIN wpab_users u
ON u.ID = r.user_id
JOIN wpab_posts p
ON p.ID = r.automator_recipe_id
WordPress database error: [CREATE VIEW command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_trigger_logs_view`]CREATE OR REPLACE SQL SECURITY INVOKER VIEW wpab_uap_trigger_logs_view AS SELECT u.ID AS user_id, u.user_email,
u.display_name,
t.automator_trigger_id,
t.date_time AS trigger_date,
t.completed AS trigger_completed,
t.automator_recipe_id,
t.ID,
pt.post_title AS trigger_title,
tm.meta_value AS trigger_sentence,
tm.run_number AS trigger_run_number,
tm.run_time AS trigger_run_time,
pm.meta_value AS trigger_total_times,
p.post_title AS recipe_title,
t.automator_recipe_log_id AS recipe_log_id,
r.date_time AS recipe_date_time,
r.completed AS recipe_completed,
r.run_number AS recipe_run_number
FROM wpab_uap_trigger_log t
LEFT JOIN wpab_users u
ON u.ID = t.user_id
LEFT JOIN wpab_posts p
ON p.ID = t.automator_recipe_id
LEFT JOIN wpab_posts pt
ON pt.ID = t.automator_trigger_id
LEFT JOIN wpab_uap_trigger_log_meta tm
ON tm.automator_trigger_log_id = t.ID AND tm.meta_key = 'sentence_human_readable'
LEFT JOIN wpab_uap_recipe_log r
ON t.automator_recipe_log_id = r.ID
LEFT JOIN wpab_postmeta pm
ON pm.post_id = t.automator_trigger_id AND pm.meta_key = 'NUMTIMES'
WordPress database error: [CREATE VIEW command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_action_logs_view`]CREATE OR REPLACE SQL SECURITY INVOKER VIEW wpab_uap_action_logs_view AS SELECT a.automator_action_id,
a.date_time AS action_date,
a.completed AS action_completed,
a.error_message,
a.automator_recipe_id,
a.ID AS action_log_id,
a.automator_recipe_log_id AS recipe_log_id,
r.date_time AS recipe_date_time,
r.completed AS recipe_completed,
r.run_number AS recipe_run_number,
pa.post_title AS action_title,
am.meta_value AS action_sentence,
p.post_title AS recipe_title,
u.ID AS user_id,
u.user_email,
u.display_name
FROM wpab_uap_action_log a
LEFT JOIN wpab_uap_recipe_log r
ON a.automator_recipe_log_id = r.ID
LEFT JOIN wpab_posts p
ON p.ID = a.automator_recipe_id
JOIN wpab_posts pa
ON pa.ID = a.automator_action_id
LEFT JOIN wpab_uap_action_log_meta am
ON a.automator_action_id = am.automator_action_id AND am.automator_action_log_id = a.ID AND am.user_id = a.user_id AND am.meta_key = 'sentence_human_readable_html'
LEFT JOIN wpab_users u
ON a.user_id = u.ID GROUP BY a.ID
WordPress database error: [CREATE VIEW command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_api_logs_view`]CREATE OR REPLACE SQL SECURITY INVOKER VIEW wpab_uap_api_logs_view AS SELECT
api.ID,
api.date_time AS date,
u.user_email,
u.display_name,
u.ID AS user_id,
pr.post_title AS recipe_title,
rl.automator_recipe_id,
al.automator_recipe_log_id AS recipe_log_id,
rl.date_time AS recipe_date_time,
rl.completed AS recipe_completed,
rl.run_number AS recipe_run_number,
pa.post_title AS title,
asen.meta_value AS sentence,
al.automator_action_id as item_id,
al.completed AS completed,
al.error_message as error_message,
api.type,
api.item_log_id,
api.status,
api.params,
api.price,
api.balance,
api.notes,
api.time_spent,
api.endpoint
FROM wpab_uap_api_log api
LEFT JOIN wpab_uap_action_log al
ON al.ID = api.item_log_id
LEFT JOIN wpab_uap_recipe_log rl
ON al.automator_recipe_log_id = rl.ID
LEFT JOIN wpab_posts pr
ON pr.ID = al.automator_recipe_id
JOIN wpab_posts pa
ON pa.ID = al.automator_action_id
LEFT JOIN wpab_uap_action_log_meta asen
ON asen.automator_action_log_id = al.ID AND asen.meta_key = 'sentence_human_readable_html'
LEFT JOIN wpab_users u
ON al.user_id = u.ID
WHERE api.type = 'action'
UNION SELECT
api.ID,
api.date_time AS date,
u.user_email,
u.display_name,
u.ID AS user_id,
pr.post_title AS recipe_title,
rl.automator_recipe_id,
tl.automator_recipe_log_id as recipe_log_id,
rl.date_time AS recipe_date_time,
rl.completed AS recipe_completed,
rl.run_number AS recipe_run_number,
pt.post_title AS title,
tsen.meta_value AS sentence,
tl.automator_trigger_id as item_id,
tl.completed AS completed,
'' as error_message,
api.type,
api.item_log_id,
api.status,
api.params,
api.price,
api.balance,
api.notes,
api.time_spent,
api.endpoint
FROM wpab_uap_api_log api
LEFT JOIN wpab_uap_trigger_log tl
ON tl.ID = api.item_log_id
LEFT JOIN wpab_uap_recipe_log rl
ON tl.automator_recipe_log_id = rl.ID
LEFT JOIN wpab_posts pr
ON pr.ID = tl.automator_recipe_id
JOIN wpab_posts pt
ON pt.ID = tl.automator_trigger_id
LEFT JOIN wpab_uap_trigger_log_meta tsen
ON tsen.automator_trigger_log_id = tl.ID AND tsen.meta_key = 'sentence_human_readable'
LEFT JOIN wpab_users u
ON tl.user_id = u.ID
WHERE api.type = 'trigger'
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'uap_database_views_version'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'uap_database_views_version'
) as combined LIMIT 1
WordPress database error: [INSERT, UPDATE command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload)
VALUES ('uap_database_views_version', '7.2', 'yes')
ON DUPLICATE KEY UPDATE option_value = VALUES(option_value), autoload = VALUES(autoload)
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'automator_upload_dir_sanitized_v1'),
(SELECT option_value FROM wpab_options WHERE option_name = 'automator_upload_dir_sanitized_v1')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_options`]SHOW FULL COLUMNS FROM `wpab_options`
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT COALESCE(
(SELECT option_value FROM wpab_uap_options WHERE option_name = 'automtor_multiple_triggers_restore_failed_logs'),
(SELECT option_value FROM wpab_options WHERE option_name = 'automtor_multiple_triggers_restore_failed_logs')
) as option_value
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_recipe_log`]SELECT ID, completed FROM wpab_uap_recipe_log WHERE completed = 14
WordPress database error: [SELECT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]SELECT 1 FROM (
SELECT 1 FROM wpab_uap_options WHERE option_name = 'automtor_multiple_triggers_restore_failed_logs'
UNION
SELECT 1 FROM wpab_options WHERE option_name = 'automtor_multiple_triggers_restore_failed_logs'
) as combined LIMIT 1
WordPress database error: [INSERT command denied to user 'u512970945_qdNnn'@'127.0.0.1' for table `u512970945_B1oii`.`wpab_uap_options`]INSERT INTO wpab_uap_options (option_name, option_value, autoload) VALUES ('automtor_multiple_triggers_restore_failed_logs', '1789995710', 'yes')
