Moin
I have insert a little code to get infos to the insert on piwik_log_visit:
Code in mysqli.php at line 276:
public function get_error()
{
return mysqli_error($this->connection);
}
in visit.php at line 510 (after $ bind=):
mail("*myaddr*","piwik","$sql\n----\n".print_r($bind,true));
and after Piwik_Tracker::getDatabase()->query( $sql, $bind);:
mail("*myaddr*","piwik-query",Piwik_Tracker::getDatabase()->get_error());
The mail “piwik”:
INSERT INTO piwik_log_visit (idsite, visitor_localtime, idvisitor, visitor_returning, visitor_count_visits, visitor_days_since_last, visitor_days_since_first, visit_first_action_time, visit_last_action_time, visit_entry_idaction_url, visit_entry_idaction_name, visit_exit_idaction_url, visit_exit_idaction_name, visit_total_actions, visit_total_time, visit_goal_converted, referer_type, referer_name, referer_url, referer_keyword, config_id, config_os, config_browser_name, config_browser_version, config_resolution, config_pdf, config_flash, config_java, config_director, config_quicktime, config_realplayer, config_windowsmedia, config_gears, config_silverlight, config_cookie, location_ip, location_browser_lang, location_country, location_provider, location_continent) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
----
Array
(
[0] => 1
[1] => 08:22:05
[2] => Ö�áܬ�í
[3] => 1
[4] => 12
[5] => 0
[6] => 7
[7] => 2011-04-09 06:22:08
[8] => 2011-04-09 06:22:08
[9] => 33
[10] => 1
[11] => 33
[12] => 1
[13] => 1
[14] => 0
[15] => 0
[16] => 1
[17] =>
[18] => https://www.clauss.east.de/main/links/index.php
[19] =>
[20] => L&€Ä�Èþ
[21] => WI7
[22] => FF
[23] => 4.0
[24] => 1920x1080
[25] => 1
[26] => 1
[27] => 1
[28] => 0
[29] => 1
[30] => 0
[31] => 0
[32] => 0
[33] => 1
[34] => 1
[35] => 3232252161
[36] => de-de,de,en-us,en
[37] => de
[38] => east.de
[39] => eur
)
and the mail “piwik-query”:
Unknown column 'location_provider' in 'field list'
The field location_provider do not exist in my database
I have Inserts in log_visit :-)))))))