Bonjour,
J’ai eu les mêmes problèmes sur ovh après avoir obtenu des tests corrects en local et me suis aperçue que 2 tables avaient une structure incomplète. Il s’agit de log_link_visit_action et log_visit
Je les ai supprimé par le PHPMYADMIN d’ovh, ai exporté leur structure en local et ai récupéré le code sql correspondant pour les recréer dans OVH.
Voici les codes correspondants :
CREATE TABLE IF NOT EXISTS piwik_log_link_visit_action
(
idlink_va
int(11) unsigned NOT NULL AUTO_INCREMENT,
idsite
int(10) unsigned NOT NULL,
idvisitor
binary(8) NOT NULL,
server_time
datetime NOT NULL,
idvisit
int(10) unsigned NOT NULL,
idaction_url
int(10) unsigned DEFAULT NULL,
idaction_url_ref
int(10) unsigned DEFAULT ‘0’,
idaction_name
int(10) unsigned DEFAULT NULL,
idaction_name_ref
int(10) unsigned NOT NULL,
idaction_event_category
int(10) unsigned DEFAULT NULL,
idaction_event_action
int(10) unsigned DEFAULT NULL,
time_spent_ref_action
int(10) unsigned NOT NULL,
custom_float
float DEFAULT NULL,
custom_var_k1
varchar(200) DEFAULT NULL,
custom_var_v1
varchar(200) DEFAULT NULL,
custom_var_k2
varchar(200) DEFAULT NULL,
custom_var_v2
varchar(200) DEFAULT NULL,
custom_var_k3
varchar(200) DEFAULT NULL,
custom_var_v3
varchar(200) DEFAULT NULL,
custom_var_k4
varchar(200) DEFAULT NULL,
custom_var_v4
varchar(200) DEFAULT NULL,
custom_var_k5
varchar(200) DEFAULT NULL,
custom_var_v5
varchar(200) DEFAULT NULL,
PRIMARY KEY (idlink_va
),
KEY index_idvisit
(idvisit
),
KEY index_idsite_servertime
(idsite
,server_time
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
et pour la deuxième
CREATE TABLE IF NOT EXISTS piwik_log_visit
(
idvisit
int(10) unsigned NOT NULL AUTO_INCREMENT,
idsite
int(10) unsigned NOT NULL,
idvisitor
binary(8) NOT NULL,
visitor_localtime
time NOT NULL,
visitor_returning
tinyint(1) NOT NULL,
visitor_count_visits
smallint(5) unsigned NOT NULL,
visitor_days_since_last
smallint(5) unsigned NOT NULL,
visitor_days_since_order
smallint(5) unsigned NOT NULL,
visitor_days_since_first
smallint(5) unsigned NOT NULL,
visit_first_action_time
datetime NOT NULL,
visit_last_action_time
datetime NOT NULL,
visit_exit_idaction_url
int(11) unsigned DEFAULT ‘0’,
visit_exit_idaction_name
int(11) unsigned NOT NULL,
visit_entry_idaction_url
int(11) unsigned NOT NULL,
visit_entry_idaction_name
int(11) unsigned NOT NULL,
visit_total_actions
smallint(5) unsigned NOT NULL,
visit_total_searches
smallint(5) unsigned NOT NULL,
visit_total_events
smallint(5) unsigned NOT NULL,
visit_total_time
smallint(5) unsigned NOT NULL,
visit_goal_converted
tinyint(1) NOT NULL,
visit_goal_buyer
tinyint(1) NOT NULL,
referer_type
tinyint(1) unsigned DEFAULT NULL,
referer_name
varchar(70) DEFAULT NULL,
referer_url
text NOT NULL,
referer_keyword
varchar(255) DEFAULT NULL,
config_id
binary(8) NOT NULL,
config_os
char(3) NOT NULL,
config_browser_name
varchar(10) NOT NULL,
config_browser_version
varchar(20) NOT NULL,
config_resolution
varchar(9) NOT NULL,
config_pdf
tinyint(1) NOT NULL,
config_flash
tinyint(1) NOT NULL,
config_java
tinyint(1) NOT NULL,
config_director
tinyint(1) NOT NULL,
config_quicktime
tinyint(1) NOT NULL,
config_realplayer
tinyint(1) NOT NULL,
config_windowsmedia
tinyint(1) NOT NULL,
config_gears
tinyint(1) NOT NULL,
config_silverlight
tinyint(1) NOT NULL,
config_cookie
tinyint(1) NOT NULL,
location_ip
varbinary(16) NOT NULL,
location_browser_lang
varchar(20) NOT NULL,
location_country
char(3) NOT NULL,
location_region
char(2) DEFAULT NULL,
location_city
varchar(255) DEFAULT NULL,
location_latitude
float(10,6) DEFAULT NULL,
location_longitude
float(10,6) DEFAULT NULL,
location_provider
varchar(100) DEFAULT NULL,
custom_var_k1
varchar(200) DEFAULT NULL,
custom_var_v1
varchar(200) DEFAULT NULL,
custom_var_k2
varchar(200) DEFAULT NULL,
custom_var_v2
varchar(200) DEFAULT NULL,
custom_var_k3
varchar(200) DEFAULT NULL,
custom_var_v3
varchar(200) DEFAULT NULL,
custom_var_k4
varchar(200) DEFAULT NULL,
custom_var_v4
varchar(200) DEFAULT NULL,
custom_var_k5
varchar(200) DEFAULT NULL,
custom_var_v5
varchar(200) DEFAULT NULL,
PRIMARY KEY (idvisit
),
KEY index_idsite_config_datetime
(idsite
,config_id
,visit_last_action_time
),
KEY index_idsite_datetime
(idsite
,visit_last_action_time
),
KEY index_idsite_idvisitor
(idsite
,idvisitor
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
Je ne sais pas pourquoi la création des tables était incomplète mais maintenant, ça fonctionne normalement