Hi .
I get “Error when connecting to Piwik: HTTP Error 500: Internal Server Error” when trying to get log files.
Xampp
PHP 5.6.23
Piwik 2.16.2
Python
D:\Products\xampp\php>D:\Products\xampp\htdocs\piwik\misc\log-analytics\import_logs.py --url=http://localhost/piwik C:\Users\fnsw\Desktop\test\u_ex160822.log --idsite=3 --login=*** --password=***
0 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
Parsing log C:\Users\fnsw\Desktop\test\u_ex160822.log…
2016-08-24 15:29:55,604: [INFO] Error when connecting to Piwik: HTTP Error 500: Internal Server Error
2016-08-24 15:29:55,605: [INFO] Retrying request, attempt number 2
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2207 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
2016-08-24 15:30:06,003: [INFO] Error when connecting to Piwik: HTTP Error 500: Internal Server Error
In my apache error log I find:
[Wed Aug 24 12:28:34.967178 2016] [:error] [pid 4988:tid 1616] [client 127.0.0.1:57300] Error in Piwik (tracker): Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_provider’ in ‘field list’ In query: INSERT INTO piwik_log_visit (location_provider, idvisitor, config_id, location_ip, idsite, user_id, visit_first_action_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visitor_days_since_first, visitor_days_since_order, visitor_returning, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_exit_idaction_name, visit_exit_idaction_url, visit_total_actions, visit_total_searches, referer_keyword, referer_name, referer_type, referer_url, location_browser_lang, config_browser_engine, config_browser_name, config_browser_version, config_device_brand, config_device_model, config_device_type, config_os, config_os_version, visit_total_events, visitor_localtime, visitor_days_since_last, config_resolution, config_cookie, config_director, config_flash, config_gears, config_java, config_pdf, config_quicktime, config_realplayer, config_silverlight, config_windowsmedia, visit_total_time, location_country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => ‘unknown’, 1 => ‘K\xf2\xf2\xb8\x056<\’’, 2 => ‘\xaf|\xd0}9\xcd+6’, 3 => ’ \xe4f3’, 4 => 3, 5 => ‘0#.w|corporativo\\svcprd_spintadmin’, 6 => ‘2016-08-22 04:00:29’, 7 => 0, 8 => 0, 9 => ‘2016-08-22 04:00:29’, 10 => ‘0’, 11 => 0, 12 => 0, 13 => 1, 14 => 0, 15 => 50, 16 => 0, 17 => 50, 18 => 1, 19 => 0, 20 => NULL, 21 => NULL, 22 => 1, 23 => ‘’, 24 => ‘’, 25 => ‘’, 26 => ‘UNK’, 27 => ‘’, 28 => ‘’, 29 => ‘’, 30 => 0, 31 => ‘WIN’, 32 => ‘’, 33 => 0, 34 => ‘04:00:29’, 35 => 0, 36 => ‘unknown’, 37 => 0, 38 => 0, 39 => 0, 40 => 0, 41 => 0, 42 => 0, 43 => 0, 44 => 0, 45 => 0, 46 => 0, 47 => 0, 48 => ‘xx’, )
Can anyone help me ?
Regards