I have a zen cart site that is not generating any data. I’ve installed Piwik before without problems, but this site is on a diff host/server so maybe there’s a system problem.
I ran the visit generator and received the following report
Generated 523 unique visitors and 2 actions per visit for the 2009-01-13
Total actions: 1038
Total requests per sec: 61
Time elapsed: 16.89sBreakdown by query Executed 1038 times in 12478.9ms (average = 12ms) SELECT visitor_idcookie, UNIX_TIMESTAMP(visit_last_action_time) as visit_last_action_time,UNIX_TIMESTAMP(visit_first_action_time) as visit_first_action_time,idvisit,visit_exit_idaction FROM piwik_log_visit WHERE visit_server_date = ?AND idsite = ?AND config_md5config = ? ORDER BY visit_last_action_time DESC LIMIT 1Executed 1038 times in 347.1ms (average = 0.3ms) /* SHARDING_ID_SITE = 1 / SELECT idaction FROM piwik_log_action WHERE name = ? AND type = ?Executed 957 times in 248.9ms (average = 0.3ms) INSERT INTO piwik_log_visit (idsite, visitor_localtime, visitor_idcookie, visitor_returning, visit_first_action_time, visit_last_action_time, visit_server_date, visit_entry_idaction, visit_exit_idaction, visit_total_actions, visit_total_time, referer_type, referer_name, referer_url, referer_keyword, config_md5config, 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_cookie, location_ip, location_browser_lang, location_country, location_continent) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)Executed 1038 times in 117ms (average = 0.1ms) / SHARDING_ID_SITE = 1 / INSERT INTO piwik_log_link_visit_action (idvisit, idaction, idaction_ref, time_spent_ref_action) VALUES (?,?,?,?)Executed 288 times in 53.1ms (average = 0.2ms) / SHARDING_ID_SITE = 1 / INSERT INTO piwik_log_action( name, type ) VALUES (?,?)Executed 81 times in 14.6ms (average = 0.2ms) / SHARDING_ID_SITE = 1 */UPDATE piwik_log_visit SET visit_last_action_time = ?, visit_exit_idaction = ?, visit_total_actions = visit_total_actions + 1, visit_total_time = UNIX_TIMESTAMP(visit_last_action_time) - UNIX_TIMESTAMP(visit_first_action_time)WHERE idvisit = ?LIMIT 1Executed 1 time in 0.2ms connect