Jump to content

Statistics a mess after update, can I import to new install?


Recommended Posts

I updated the system a few months ago and it caused all the stats to be crazy. I tried everything I could find to fix it with no luck, so I had to do a clean install and start from scratch. Not the end of the world, but advertisers are requesting and need their results. 

It seems even the far back stats show incorrectly, so I decided to check the actual data tables and see what was in there. From what I can guess, the data there looks OK, but for some reason the stat page and exports are doing something to the numbers. ??? Very weird. 

If I take a clean install, is is possible to import just specific tables to recreate the environment and clean stats?

Which tables should I be looking to verify stat data?

Thanks for any help!

Link to post
Share on other sites

Hi @ajotadmin,

It would be very difficult to take a clean install, and then, later on, try and merge in specific stats from an older, different instance, because the statistics are all stored relative to the IDs of the entities. This means that with your clean install having been used, the IDs are likely to be different, so merging things in would be pretty much impossible to do.

It might be better to use your pre-upgrade backup of the database and code base to simply restore the old instance in a separate location, so that you can historically access the stats there via a different URL, to allow your advertisers to get the stats they need from before the migration to the clean install?

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...