WP-Piwik stopped tracking visitors

  • Resolved Rafael

    (@jordh)


    9 years, 10 months ago

    Starting two days ago, my Piwik stopped tracking my visitors: I got 0 visitors for three days straight now. I had visits tough, I have accessed my site from another PC several times to test this.

    This is my site (it’s german): https://flugplatz.tagblatt.de/

    The Piwik version is 2.0.3 and the WP-Piwik version is 0.9.9.18.

    If it helps, here’s my test script:

    *** Test 1/2: SitesManager.getSitesWithAtLeastViewAccess ***
Using: cURL
SSL peer verification: enabled
User Agent:
Call: https://flugplatz.tagblatt.de/Piwik/piwik/?module=API&method=SitesManager.getSitesWithAtLeastViewAccess&format=XML&token_auth= + TOKEN
Result:
HTTP/1.1 200 OK
Date: Fri, 17 Apr 2015 10:09:17 GMT
Server: Apache
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: PIWIK_SESSID=7fcaa08279509a46d7087fc281b8321d; path=/; HttpOnly
Transfer-Encoding: chunked
Content-Type: text/xml; charset=utf-8

<?xml version="1.0" encoding="utf-8" ?>
<result>
	<row>
		<idsite>1</idsite>
		<name>flugplatz.tagblatt.de</name>
		<main_url>https://flugplatz.tagblatt.de</main_url>
		<ts_created>2014-02-28 10:32:54</ts_created>
		<ecommerce>0</ecommerce>
		<sitesearch>1</sitesearch>
		<sitesearch_keyword_parameters />
		<sitesearch_category_parameters />
		<timezone>Europe/Berlin</timezone>
		<currency>USD</currency>
		<excluded_ips />
		<excluded_parameters />
		<excluded_user_agents />
		<group />
		<type>website</type>
		<keep_url_fragment>0</keep_url_fragment>
	</row>
</result>
Time: 0.07s

*** Test 2/2: SitesManager.getSitesIdFromSiteUrl ***
Using: cURL
SSL peer verification: enabled
User Agent:
Call: https://flugplatz.tagblatt.de/Piwik/piwik/?module=API&method=SitesManager.getSitesIdFromSiteUrl&url=http%3A%2F%2Fflugplatz.tagblatt.de&format=XML&token_auth= + TOKEN
Result:
HTTP/1.1 200 OK
Date: Fri, 17 Apr 2015 10:09:17 GMT
Server: Apache
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: PIWIK_SESSID=f02644e00309751ddd2ca5ae444b70fd; path=/; HttpOnly
Transfer-Encoding: chunked
Content-Type: text/xml; charset=utf-8

<?xml version="1.0" encoding="utf-8" ?>
<result>
	<row>
		<idsite>1</idsite>
	</row>
</result>
Time: 0.08s

    I hope you can help me to resolve this issue.
    ~ Jordh

    https://www.ads-software.com/plugins/wp-piwik/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author braekling

    (@braekling)

    First, according to the plugin description you should at least use Piwik 2.7.

    Second, I had a look at your tracking code. Following the Piwik URL shown there, I got a error message by Piwik itself: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbflugplatz.piwik_access' doesn't exist

    So it looks like there is something wrong with your Piwik. I just wonder how your test script could work? Did you change anything afterwards?

    Thread Starter Rafael

    (@jordh)

    The Piwik version I have is the one displayed in my WP-Piwik settings. How do I update my Piwik version?

    I didn’t change anything after running the test script.

    It seems the database is somehow corrupt – I looked into my backups, but have found no file containing “piwik-access”. Where would it be saved?

    Plugin Author braekling

    (@braekling)

    If you login to Piwik, you get further instructions to Piwik. Because your Piwik seems to be broken, you should try the manual update: https://piwik.org/docs/update/

    piwik_access is a database table, not a file. So you have to check your database. Maybe this problem will be solved by updating Piwik.

    WP-Piwik can’t work if Piwik is not working. To get support on Piwik itself, please visit the Piwik website: https://piwik.org

    Thread Starter Rafael

    (@jordh)

    Luckily, I was able to export the missing table from one of my hoster’s backups. Now I was able to update Piwik (it even denied the manual update before) and it works again as intended.

    Thank you for your help – I might not have been able to find what caused the problem by myself (I’m not a homepage pro).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WP-Piwik stopped tracking visitors’ is closed to new replies.