Still have not be able to restore my stats. Can anyone tell me how? This is pretty disastrous.
I found from another thread (https://wordpress.org/support/topic/location-of-jetpack-stats-database?replies=4) that the stats are supposed to be stored on WordPress.com…
OK how can that be? I needed to create a new version of the old site for a new market so I cloned the server. I changed almost everything about the site except the basic theme. I even changed my admin user, I changed mywordpress.com account. I deleted jetpack reinstalled it. I changed my askimet API key.
I try to set up jetpack on the new site, new WordPress.org (my installation) user, new WordPress.com user, new Akismet API key… I get the old states that are missing from the other site. But I cannot get a new fresh set of stats no matter what I do!
Now I have not one but two sites with destroyed stats. How can this bee if stats are safely stored on WordPress.com?
This is a disaster.
The stats are indeed stored on WordPress.com, where they’re stored based on your site URL. If that site URL ever changes, a new data set is created for the new site URL.
That’s most likely what happened here, when you cloned your first site’s database and created a brand new site, using existing data from a site with a different URL.
Looking at your site stats I see that you’ve managed to solve the issue on your own, and you got your old stats back. You should be all set now!
If you still experience issues, let me know!
I wasn’t exactly able to fix it to myself, I found another way to contact support and one of your colleagues helped me to fix it, kind of.
For site 1: http://bit.ly/1MF1Pxm The correct stats have been reconnected but I am missing the data from April 4 – April 16. I suppose that is not retrievable and that’s OK no big deal.
For site 2: http://bit.ly/1XGaIrR Now the correct stats are being recorded but all of the missing data from April 4 – April 16 for site 1 are being shown as part of site 2’s stats history. I would like to erase site 2’s stats and start from scratch there and not have this data history from the other site applied to it if possible. I do not care about any of the data that has been compiled for site 2 so far, starting from scratch as of today or tomorrow or the next day would be fine.
I don’t really understand how the sites can be based on the URL if they got switched like this. When I cloned the site my first order of business was change the site’s URL. In fact I manually changed it in the database before I even logged into /wp-admin the first time. I didn’t activate Jetpack or Jetpack stats until some time after that. At that point the sites to the wrong site were displayed and my old site somehow got the stats for my new site.
Even more bizarre the problem losing the old stats on site 1 began before I even started working on site 2.
I still don’t really understand what happened or how to prevent it but updating the sites URL alone does not seem to fix it and neither does deactivating, uninstalling and reinstalling Jetpack. Whatever was done to fix it so far was done by your colleague.
Thanks.
I suppose that is not retrievable and that’s OK no big deal.
That’s correct. Since your site wasn’t properly connected to WordPress.com during that period, no stats were collected for that data set.
I would like to erase site 2’s stats and start from scratch there and not have this data history from the other site applied to it if possible. I do not care about any of the data that has been compiled for site 2 so far, starting from scratch as of today or tomorrow or the next day would be fine.
Could you reply to my colleagues with that request? I can’t do that for you here, since we’d need to prove that you’re the site owner first.
Thanks!
I don’t really understand how the sites can be based on the URL if they got switched like this. When I cloned the site my first order of business was change the site’s URL. In fact I manually changed it in the database before I even logged into /wp-admin the first time.
Although you changed the site URL in your database, you didn’t change or remove the site ID stored in the jetpack_options row in your database. That site ID matches a specific data set on WordPress.com, and a specific site URL. Once your cloned site went live, you consequently had 2 sites, with 2 different site URLs, linked to a single site ID and a single data set. That obviously messes things up, as you’ve seen.
I hope this clarifies things a bit.
I understand.
So is it a good idea to find that site id and delete it manually when cloning a site? A new one will generated automatically I assume?
I will reply again to your colleague.
Thank you again for the explanations.
Yes, you can delete the whole jetpack_options row. A new set of options will be created when you activate and connect Jetpack to WordPress.com.
