SiteID changed and multiple site duplicates at Piwik after upgrade

  • Hi!

    We have troubles after upgrading Matomo 3.2.0 to 3.5.1 . Some WordPress (from our multisite WP installation) sites have been reregistered as new sites in Matomo (some even multiple times) and siteID is now changed. For example:

    If I do query sites in Piwik database for last few rows in sites table I get:

    *************************** 1. row ***************************
    idsite: 21458
    name: hd test
    main_url: https://hd16.test-domain
    ts_created: 2018-07-25 00:00:00
    ecommerce: 0
    sitesearch: 1
    sitesearch_keyword_parameters:
    sitesearch_category_parameters:
    timezone: Europe/Ljubljana
    currency: EUR
    exclude_unknown_urls: 0
    excluded_ips:
    excluded_parameters:
    excluded_user_agents:
    group:
    type: website
    keep_url_fragment: 0
    *************************** 2. row ***************************
    idsite: 21457
    name: hd test
    main_url: https://hd16.test-domain
    ts_created: 2018-07-26 07:53:00
    ecommerce: 0
    sitesearch: 1
    sitesearch_keyword_parameters:
    sitesearch_category_parameters:
    timezone: Europe/Ljubljana
    currency: EUR
    exclude_unknown_urls: 0
    excluded_ips:
    excluded_parameters:
    excluded_user_agents:
    group:
    type: website
    keep_url_fragment: 0
    *************************** 3. row ***************************
    idsite: 21456
    name: hd test
    main_url: https://hd16.test-domain
    ts_created: 2018-07-25 00:00:00
    ecommerce: 0
    sitesearch: 1
    sitesearch_keyword_parameters:
    sitesearch_category_parameters:
    timezone: Europe/Ljubljana
    currency: EUR
    exclude_unknown_urls: 0
    excluded_ips:
    excluded_parameters:
    excluded_user_agents:
    group:
    type: website
    keep_url_fragment: 0

    Timestamp seems to be off…

    This is original first entry (as you can see by ts_created and idsite which is much lower than last entries from table):

    idsite: 8002
    name: hd test
    main_url: https://hd16.production-domain
    ts_created: 2016-02-25 10:36:55
    ecommerce: 0
    sitesearch: 1
    sitesearch_keyword_parameters:
    sitesearch_category_parameters:
    timezone: Europe/Ljubljana
    currency: EUR
    exclude_unknown_urls: 0
    excluded_ips:
    excluded_parameters:
    excluded_user_agents:
    group:
    type: website
    keep_url_fragment: 0

    Upgrade has been made in our test environment, where we tried to replicate our production evironmant as close as we could get.

    So we have:
    – WordPress multisite installation 4.7.3
    – WP Piwik plugin: 1.0.19
    – Piwik(Matomo) 3.2.0 database that has been imported from production and then upgraded to 3.5.1.

    I try to figure out what caused this new sites registration. Was that requested from WP-piwik plugin because site url has changed https://hd16.production-domain -> https://hd16.test-domain . More than that, why in some cases same site was registered multiple times…

    Unfortunatelly I don’t know how to debug POST requests to track what has been sent to Piwik.

    I would really appriciate if you could give me some hints where to look, or what you think caused this.

    • This topic was modified 6 years, 7 months ago by nordlolek.
Viewing 1 replies (of 1 total)
  • Plugin Author braekling

    (@braekling)

    Changing the URL will cause this, because WP-Matomo uses the URL to get the Matomo site ID. So, it just sends the currents blog URL and if Matomo does not recognise the URL, the plugin asks to create a new site.

    But I’ve no idea why the site is created multiple times… can you check the site configuration in Piwik itself? Is the URL configured correctly?

Viewing 1 replies (of 1 total)
  • The topic ‘SiteID changed and multiple site duplicates at Piwik after upgrade’ is closed to new replies.