Contactez-nous
Gestion locative, estimation, location ou vente : notre équipe répond à vos questions. N’hésitez pas à nous contacter.
Erreur de la base de données WordPress : [Column 'hits' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_hourly` (`date_bucket`, `page_path`, `referrer_domain`, `device_class`, `hits`) SELECT old.`date_bucket`, old.`page_path`, old.`referrer_domain`, old.`device_class`, old.`hits` FROM `wp_bpa_hourly` old ON DUPLICATE KEY UPDATE `hits` = `hits` + VALUES(`hits`)
Erreur de la base de données WordPress : [Column 'hits' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_hits_daily` (`date_bucket`, `page_path`, `referrer_domain`, `source_category`, `hits`) SELECT old.`date_bucket`, old.`page_path`, old.`referrer_domain`, old.`source_category`, old.`hits` FROM `wp_bpa_hits_daily` old ON DUPLICATE KEY UPDATE `hits` = `hits` + VALUES(`hits`)
Erreur de la base de données WordPress : [Column 'hits' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_daily_source_category` (`date_bucket`, `page_path`, `referrer_domain`, `source_category`, `hits`, `visits`) SELECT old.`date_bucket`, old.`page_path`, old.`referrer_domain`, old.`source_category`, old.`hits`, old.`visits` FROM `wp_bpa_daily_source_category` old ON DUPLICATE KEY UPDATE `hits` = `hits` + VALUES(`hits`), `visits` = `visits` + VALUES(`visits`)
Erreur de la base de données WordPress : [Column 'hits' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_404s_daily` (`date_bucket`, `page_path`, `hits`) SELECT old.`date_bucket`, old.`page_path`, old.`hits` FROM `wp_bpa_404s_daily` old ON DUPLICATE KEY UPDATE `hits` = `hits` + VALUES(`hits`)
Erreur de la base de données WordPress : [Column 'hits' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_search_terms_daily` (`date_bucket`, `search_term`, `hits`) SELECT old.`date_bucket`, old.`search_term`, old.`hits` FROM `wp_bpa_search_terms_daily` old ON DUPLICATE KEY UPDATE `hits` = `hits` + VALUES(`hits`)
Erreur de la base de données WordPress : [Column 'entries' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_entry_exit_daily` (`date_bucket`, `page_path`, `entries`, `exits`) SELECT old.`date_bucket`, old.`page_path`, old.`entries`, old.`exits` FROM `wp_bpa_entry_exit_daily` old ON DUPLICATE KEY UPDATE `entries` = `entries` + VALUES(`entries`), `exits` = `exits` + VALUES(`exits`)
Erreur de la base de données WordPress : [Column 'entries' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_entry_exit_hourly` (`date_bucket`, `page_path`, `entries`, `exits`) SELECT old.`date_bucket`, old.`page_path`, old.`entries`, old.`exits` FROM `wp_bpa_entry_exit_hourly` old ON DUPLICATE KEY UPDATE `entries` = `entries` + VALUES(`entries`), `exits` = `exits` + VALUES(`exits`)
Erreur de la base de données WordPress : [Column 'city_geoname_id' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_geo_daily` (`date_bucket`, `country_code`, `region_code`, `city_name`, `city_geoname_id`, `latitude`, `longitude`, `hits`, `visits`) SELECT old.`date_bucket`, old.`country_code`, old.`region_code`, old.`city_name`, old.`city_geoname_id`, old.`latitude`, old.`longitude`, old.`hits`, old.`visits` FROM `wp_bpa_geo_daily` old ON DUPLICATE KEY UPDATE `city_geoname_id` = IF(`city_geoname_id` = '' OR `city_geoname_id` IS NULL, VALUES(`city_geoname_id`), `city_geoname_id`), `latitude` = IF(`latitude` = '' OR `latitude` IS NULL, VALUES(`latitude`), `latitude`), `longitude` = IF(`longitude` = '' OR `longitude` IS NULL, VALUES(`longitude`), `longitude`), `hits` = `hits` + VALUES(`hits`), `visits` = `visits` + VALUES(`visits`)
Erreur de la base de données WordPress : [Column 'first_view_at' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_visitors` (`visitor_id`, `first_view_at`, `last_view_at`, `entry_page`, `exit_page`, `total_views`, `active_time_ms`, `country_code`, `country`, `city`, `referrer_domain`, `source_category`, `browser`, `browser_version`, `device_class`, `operating_system`, `screen_resolution`, `has_enriched_data`) SELECT old.`visitor_id`, old.`first_view_at`, old.`last_view_at`, old.`entry_page`, old.`exit_page`, old.`total_views`, old.`active_time_ms`, old.`country_code`, old.`country`, old.`city`, old.`referrer_domain`, old.`source_category`, old.`browser`, old.`browser_version`, old.`device_class`, old.`operating_system`, old.`screen_resolution`, old.`has_enriched_data` FROM `wp_bpa_visitors` old ON DUPLICATE KEY UPDATE `first_view_at` = LEAST(`first_view_at`, VALUES(`first_view_at`)), `last_view_at` = GREATEST(`last_view_at`, VALUES(`last_view_at`)), `entry_page` = IF(`entry_page` = '' OR `entry_page` IS NULL, VALUES(`entry_page`), `entry_page`), `exit_page` = IF(`exit_page` = '' OR `exit_page` IS NULL, VALUES(`exit_page`), `exit_page`), `total_views` = `total_views` + VALUES(`total_views`), `active_time_ms` = `active_time_ms` + VALUES(`active_time_ms`), `country_code` = IF(`country_code` = '' OR `country_code` IS NULL, VALUES(`country_code`), `country_code`), `country` = IF(`country` = '' OR `country` IS NULL, VALUES(`country`), `country`), `city` = IF(`city` = '' OR `city` IS NULL, VALUES(`city`), `city`), `referrer_domain` = IF(`referrer_domain` = '' OR `referrer_domain` IS NULL, VALUES(`referrer_domain`), `referrer_domain`), `source_category` = IF(`source_category` = '' OR `source_category` IS NULL, VALUES(`source_category`), `source_category`), `browser` = IF(`browser` = '' OR `browser` IS NULL, VALUES(`browser`), `browser`), `browser_version` = IF(`browser_version` = '' OR `browser_version` IS NULL, VALUES(`browser_version`), `browser_version`), `device_class` = IF(`device_class` = '' OR `device_class` IS NULL, VALUES(`device_class`), `device_class`), `operating_system` = IF(`operating_system` = '' OR `operating_system` IS NULL, VALUES(`operating_system`), `operating_system`), `screen_resolution` = IF(`screen_resolution` = '' OR `screen_resolution` IS NULL, VALUES(`screen_resolution`), `screen_resolution`), `has_enriched_data` = IF(`has_enriched_data` = '' OR `has_enriched_data` IS NULL, VALUES(`has_enriched_data`), `has_enriched_data`)
Erreur de la base de données WordPress : [Column 'device_class' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_visitor_activity_daily` (`date_bucket`, `visitor_id`, `device_class`, `country_code`, `country`, `city`, `has_enriched_data`, `first_seen_at`, `last_seen_at`, `page_views`) SELECT old.`date_bucket`, old.`visitor_id`, old.`device_class`, old.`country_code`, old.`country`, old.`city`, old.`has_enriched_data`, old.`first_seen_at`, old.`last_seen_at`, old.`page_views` FROM `wp_bpa_visitor_activity_daily` old ON DUPLICATE KEY UPDATE `device_class` = IF(`device_class` = '' OR `device_class` IS NULL, VALUES(`device_class`), `device_class`), `country_code` = IF(`country_code` = '' OR `country_code` IS NULL, VALUES(`country_code`), `country_code`), `country` = IF(`country` = '' OR `country` IS NULL, VALUES(`country`), `country`), `city` = IF(`city` = '' OR `city` IS NULL, VALUES(`city`), `city`), `has_enriched_data` = IF(`has_enriched_data` = '' OR `has_enriched_data` IS NULL, VALUES(`has_enriched_data`), `has_enriched_data`), `first_seen_at` = LEAST(`first_seen_at`, VALUES(`first_seen_at`)), `last_seen_at` = GREATEST(`last_seen_at`, VALUES(`last_seen_at`)), `page_views` = `page_views` + VALUES(`page_views`)
Erreur de la base de données WordPress : [Column 'active_ms_total' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_time_daily` (`date_bucket`, `active_ms_total`, `visits_with_time`) SELECT old.`date_bucket`, old.`active_ms_total`, old.`visits_with_time` FROM `wp_bpa_time_daily` old ON DUPLICATE KEY UPDATE `active_ms_total` = `active_ms_total` + VALUES(`active_ms_total`), `visits_with_time` = `visits_with_time` + VALUES(`visits_with_time`)
Erreur de la base de données WordPress : [Column 'active_ms_total' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_page_time_daily` (`date_bucket`, `page_path`, `active_ms_total`, `visits_with_time`) SELECT old.`date_bucket`, old.`page_path`, old.`active_ms_total`, old.`visits_with_time` FROM `wp_bpa_page_time_daily` old ON DUPLICATE KEY UPDATE `active_ms_total` = `active_ms_total` + VALUES(`active_ms_total`), `visits_with_time` = `visits_with_time` + VALUES(`visits_with_time`)
Erreur de la base de données WordPress : [Column 'page_views' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_overview_daily` (`date_bucket`, `page_views`, `visits`, `visitors`, `bounces`, `active_ms_total`, `visits_with_time`, `bot_page_views`) SELECT old.`date_bucket`, old.`page_views`, old.`visits`, old.`visitors`, old.`bounces`, old.`active_ms_total`, old.`visits_with_time`, old.`bot_page_views` FROM `wp_bpa_overview_daily` old ON DUPLICATE KEY UPDATE `page_views` = `page_views` + VALUES(`page_views`), `visits` = `visits` + VALUES(`visits`), `visitors` = `visitors` + VALUES(`visitors`), `bounces` = `bounces` + VALUES(`bounces`), `active_ms_total` = `active_ms_total` + VALUES(`active_ms_total`), `visits_with_time` = `visits_with_time` + VALUES(`visits_with_time`), `bot_page_views` = `bot_page_views` + VALUES(`bot_page_views`)
Erreur de la base de données WordPress : [Column 'events_count' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_event_actions_daily` (`day_bucket`, `event_id`, `action_type`, `status`, `events_count`) SELECT old.`day_bucket`, old.`event_id`, old.`action_type`, old.`status`, old.`events_count` FROM `wp_bpa_event_actions_daily` old ON DUPLICATE KEY UPDATE `events_count` = `events_count` + VALUES(`events_count`)
Erreur de la base de données WordPress : [Column 'last_triggered_at' in UPDATE is ambiguous]INSERT INTO `wp_bbpa_events_daily` (`day_bucket`, `last_triggered_at`, `event_id`, `trigger_type`, `page_path`, `action_status`, `triggered_count`) SELECT old.`day_bucket`, old.`last_triggered_at`, old.`event_id`, old.`trigger_type`, old.`page_path`, old.`action_status`, old.`triggered_count` FROM `wp_bpa_events_daily` old ON DUPLICATE KEY UPDATE `last_triggered_at` = GREATEST(`last_triggered_at`, VALUES(`last_triggered_at`)), `triggered_count` = `triggered_count` + VALUES(`triggered_count`)