Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not able to track Referrer URL in local setup #5352

Closed
anonymous-matomo-user opened this issue Jun 16, 2014 · 2 comments
Closed

Not able to track Referrer URL in local setup #5352

anonymous-matomo-user opened this issue Jun 16, 2014 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. worksforme The issue cannot be reproduced and things work as intended.

Comments

@anonymous-matomo-user
Copy link

Hi,

I have deployed piwik in my local setup, and trying to track Referrer URL by passing urlref as below

http://172.16.29.60/analytics/piwik/piwik.php?idsite=2&rec=1&action_name=Home&cvar={1:[PhoneModel,Firefox],2:[msisdn,9900250501]}&**urlref=http://172.19.4.131:8081/partner/affiliate.jsp**&_id=af344a398df83874&url=http://172.19.4.131:8081/partner/affiliate.jsp

But it is not reflecting in GUI/Dashboard. Below is the debug displayed on browser. please check and resolve.

DEBUG Piwik\Common10:59:21 [841d1] Debug enabled - Input parameters:

DEBUG Piwik\Common10:59:21 [841d1] array (

DEBUG Piwik\Common10:59:21 [841d1] 'idsite' => '2',

DEBUG Piwik\Common10:59:21 [841d1] 'rec' => '1',

DEBUG Piwik\Common10:59:21 [841d1] 'action_name' => 'Home',

DEBUG Piwik\Common10:59:21 [ 'cvar' => '{1:PhoneModel,Firefox,2:[msisdn,9900250501]}',

DEBUG Piwik\Common10:59:21 [841d1] 'urlref' => 'http://172.19.4.131:8081/partner/affiliate.jsp',

DEBUG Piwik\Common10:59:21 [841d1] '_id' => 'af344a398df83874',

DEBUG Piwik\Common10:59:21 [841d1] 'url' => 'http://172.19.4.131:8081/partner/affiliate.jsp',

DEBUG Piwik\Common10:59:21 [841d1] )

DEBUG Piwik\Common10:59:21 [841d1] Loading plugins: { Provider,Goals,PrivacyManager,UserCountry,Login,UsersManager,SitesManager }

DEBUG Piwik\Common10:59:21 [841d1] Current datetime: 2014-06-16 10:59:21

DEBUG PrivacyManager10:59:21 [841d1] Visitor IP was not anonymized: 172.19.18.131

DEBUG Piwik\Common10:59:21 [841d1](this is not a Site Search request)

DEBUG Piwik\Common10:59:21 [841d1] Action is a PAGE_URL,

DEBUG Piwik\Common10:59:21 [841d1] Action name = Home,

DEBUG Piwik\Common10:59:21 [841d1] Action URL = http://172.19.4.131:8081/partner/affiliate.jsp

DEBUG Piwik\Common10:59:21 [841d1] Recorded a new action (PAGE_URL) in the lookup table: 172.19.4.131:8081/partner/affiliate.jsp (idaction = 80)

DEBUG Piwik\Common10:59:21 [841d1] Matching visitors with: visitorId=af344a398df83874 OR configId=bf17ba7859e365b7

DEBUG Piwik\Common10:59:21 [841d1] The visitor is known (idvisitor = 101b84b6e885edd2,

DEBUG Piwik\Common10:59:21 [841d1] config_id = bf17ba7859e365b7,

DEBUG Piwik\Common10:59:21 [841d1] idvisit = 13,

DEBUG Piwik\Common10:59:21 [841d1] last action = Mon, 16 Jun 2014 10:58:06 +0000,

DEBUG Piwik\Common10:59:21 [841d1] first action = Mon, 16 Jun 2014 09:58:18 +0000,

DEBUG Piwik\Common10:59:21 [841d1] visit_goal_buyer' = 0)

DEBUG Piwik\Common10:59:21 [841d1] Visit is known (IP = 172.19.18.131)

DEBUG Piwik\Common10:59:21 [841d1] Updating existing visit: array (

DEBUG Piwik\Common10:59:21 [841d1] 'visit_exit_idaction_name' => '63',

DEBUG Piwik\Common10:59:21 [841d1] 'visit_exit_idaction_url' => 80,

DEBUG Piwik\Common10:59:21 [841d1] 'visit_total_actions' => 'visit_total_actions + 1',

DEBUG Piwik\Common10:59:21 [841d1] 'visit_last_action_time' => '2014-06-16 10:59:21',

DEBUG Piwik\Common10:59:21 [841d1] 'visit_total_time' => 3664,

DEBUG Piwik\Common10:59:21 [841d1] 'idvisitor' => '101b84b6e885edd2',

DEBUG Piwik\Common10:59:21 [841d1] )

DEBUG Piwik\Common10:59:21 [841d1] Inserted new action:

DEBUG Piwik\Common10:59:21 [841d1] array (

DEBUG Piwik\Common10:59:21 [841d1] 'idvisit' => '13',

DEBUG Piwik\Common10:59:21 [841d1] 'idsite' => 2,

DEBUG Piwik\Common10:59:21 [841d1] 'idvisitor' => '',

DEBUG Piwik\Common10:59:21 [841d1] 'server_time' => '2014-06-16 10:59:21',

DEBUG Piwik\Common10:59:21 [841d1] 'idaction_url' => '80',

DEBUG Piwik\Common10:59:21 [841d1] 'idaction_url_ref' => '0',

DEBUG Piwik\Common10:59:21 [841d1] 'idaction_name_ref' => '63',

DEBUG Piwik\Common10:59:21 [841d1] 'time_spent_ref_action' => 75,

DEBUG Piwik\Common10:59:21 [841d1] 'idaction_name' => '63',

DEBUG Piwik\Common10:59:21 [841d1] 'idlink_va' => '103',

DEBUG Piwik\Common10:59:21 [841d1] )

DEBUG Piwik\Common10:59:21 [841d1] -> Scheduled tasks not triggered.

DEBUG Piwik\Common10:59:21 [841d1] Next run will be from: 2014-06-16 11:58:06 UTC

DEBUG Piwik\Common10:59:21 [841d1] Nothing to notice => default behaviour

DEBUG Piwik\Common10:59:21 [841d1] End of the page.

DEBUG Piwik\Profiler10:59:21 [841d1] <hr /><strong>Breakdown by query</strong><br/>Executed <b>4</b> times in <b>37.2ms</b> (average = <b>9.3ms</b>) <pre> UPDATE piwik_log_visit SET visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_last_action_time = ?, visit_total_time = ?, idvisitor = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>6</b> times in <b>31.9ms</b> (average = <b>5.3ms</b>) <pre> INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, server_time, idaction_url, idaction_url_ref, idaction_name_ref, time_spent_ref_action, idaction_name) VALUES (?,?,?,?,?,?,?,?,?)</pre>Executed <b>2</b> times in <b>11.5ms</b> (average = <b>5.8ms</b>) <pre> UPDATE piwik_log_visit SET visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_last_action_time = ?, visit_total_time = ?, idvisitor = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>1</b> time in <b>7.4ms</b> <pre> INSERT INTO piwik_log_action( name, hash, type, url_prefix ) VALUES (?,CRC32(?),?,?)</pre>Executed <b>6</b> times in <b>6.1ms</b> (average = <b>1ms</b>) <pre> connect</pre>Executed <b>1</b> time in <b>4.7ms</b> <pre> INSERT INTO piwik_option (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>27</b> times in <b>2.6ms</b> (average = <b>0.1ms</b>) <pre> SELECT option_value FROM piwik_option WHERE option_name = ?</pre>Executed <b>2</b> times in <b>2.4ms</b> (average = <b>1.2ms</b>) <pre> SHOW COLUMNS FROM piwik_log_link_visit_action</pre>Executed <b>4</b> times in <b>2.3ms</b> (average = <b>0.6ms</b>) <pre> SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type , custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5 FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND config_id = ? ORDER BY visit_last_action_time DESC LIMIT 1</pre>Executed <b>4</b> times in <b>1.6ms</b> (average = <b>0.4ms</b>) <pre> SELECT idaction, type, name FROM piwik_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) </pre>Executed <b>2</b> times in <b>1.6ms</b> (average = <b>0.8ms</b>) <pre> ( SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type , custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5 , 0 as priority FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND config_id = ? ORDER BY visit_last_action_time DESC LIMIT 1 ) UNION ( SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type , custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5 , 1 as priority FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND idvisitor = ? ORDER BY visit_last_action_time DESC LIMIT 1 ) ORDER BY priority DESC LIMIT 1</pre>Executed <b>2</b> times in <b>1.6ms</b> (average = <b>0.8ms</b>) <pre> SHOW COLUMNS FROM piwik_log_visit</pre>Executed <b>2</b> times in <b>1.3ms</b> (average = <b>0.7ms</b>) <pre> SELECT option_value, option_name FROM piwik_option WHERE autoload = 1</pre>Executed <b>2</b> times in <b>1.3ms</b> (average = <b>0.7ms</b>) <pre> SHOW COLUMNS FROM piwik_log_conversion</pre>Executed <b>4</b> times in <b>0.6ms</b> (average = <b>0.2ms</b>) <pre> SELECT * FROM piwik_site WHERE idsite = ?</pre>Executed <b>1</b> time in <b>0.5ms</b> <pre> SELECT login, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC</pre>Executed <b>3</b> times in <b>0.4ms</b> (average = <b>0.1ms</b>) <pre> SELECT idsite FROM piwik_site</pre>Executed <b>2</b> times in <b>0.4ms</b> (average = <b>0.2ms</b>) <pre> SELECT * FROM piwik_goal WHERE idsite IN (2) AND deleted = 0</pre>Executed <b>2</b> times in <b>0.3ms</b> (average = <b>0.2ms</b>) <pre> SELECT login FROM piwik_access WHERE idsite = ? AND access = ?</pre>Executed <b>2</b> times in <b>0.2ms</b> (average = <b>0.1ms</b>) <pre> SELECT url FROM piwik_site_url WHERE idsite = ?</pre>Executed <b>1</b> time in <b>0.2ms</b> <pre> SELECT access, t2.idsite FROM piwik_access as t1 JOIN piwik_site as t2 USING (idsite) WHERE login = ?</pre>Executed <b>1</b> time in <b>0.2ms</b> <pre> SELECT * FROM piwik_user WHERE login = ?</pre>

DEBUG Piwik\Common10:59:21 [841d1] array (

DEBUG Piwik\Common10:59:21 [841d1] )

DEBUG Piwik\Common10:59:21 [841d1] Time elapsed: 0.077s

@mattab
Copy link
Member

mattab commented Jun 20, 2014

please URL encode the &url= parameter before sending the tracking API request.

Reference: http://developer.piwik.org/api-reference/tracking-api#supported-query-parameters

 Note: all parameters values that are strings (such as 'url', 'action_name', etc.) must be URL encoded. ```

@mattab
Copy link
Member

mattab commented Jun 20, 2014

Also maybe this will help: http://piwik.org/faq/troubleshooting/faq_51/

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

2 participants