• Resolved Rafael

    (@jordh)


    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): http://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: http://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>http://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: http://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://wordpress.org/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: http://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: http://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.