Question sort out the statistic problem after upgrading last time?

[hornstar]

I am pretty sure you know about my problem already, however I just want clear instructions before I touch anything and screw things up.

I was originally on Post Thanks hack 7.7, until I installed Thanks/Likes and exported my thanks over (this was when the hack first came out too).

However since one of the last updates, where I had to run some of the maintenance tools, all my statistics got ruined.

My personal stats are:
Thanks (Given): 1874
Thanks (Received): 68
Likes (Given): 130
Likes (Received): 97

However I have received thousands of thanks, so this is clearly wrong. Same with lots of my members.

What do I need to do to sort this out. I am afraid of using the export function incase I lose all my members latest thanks/likes since originally updating from post thanks months and months ago.

I upgraded to thanks/likes 1.1.3 but what do I have to do now?

 

[Fillip H.]

Could you try running /admincp/thanks.php?do=finalise&version=111 - then run the Recalc function in Thanks' Maintenance section?

I believe that should fix the counters.

I've identified the original cause for the problem, which is that upon import, it would redirect to that finalise script - which would only work if you ran it with an administrator thats either Super Admin (as per config.php) or someone who had been given the Can Administer Thanks permission - which isn't always the case.

The solution provided above has worked for others who were in the same boat, so hopefully it will work for you too

 

[hornstar]

Thanks. It worked.

My stats are now:
Thanks (Given): 1874
Thanks (Received): 12162
Likes (Given): 130
Likes (Received): 392

Which would be about right.

The script is still running.....I am user ID 1 so I was able to check out my updated stats straight away, however the recalculate script is really slow. For the last 30+ minutes it has been running and it is now processing user 790

The problem I fear is that since I have now over 600 000 members it will take weeks lol. Another problem is if the script times out or my browser times out, or something like that, I am hoping the script won't have to be run again from the start as I may never be able to reach user 600 000 if that is the case.

 

[Fillip H.]

It doesn't matter if it times out, if you observe the URL you should see parameters like "perpage", "startat" and "version".

In the event of a timeout, you can simply refresh the page and it will, at most, process 249 users before continuing.

What you can also do is copy the current URL it's at, close the tab, then re-open a new tab and set the "perpage" in the URL to a lower number, say 10.

It will then process 10 users per page, leaving almost no chance of it timing out

 

[hornstar]

My url is not changing, it is still my standard admincp url .com/forums/admincp

Give me an example of what the url looks like for you, and I might be able to mimic it, if things do time out.

I don't really want to stop things now, as it has been running for a few hours now. I am up to user 5000

 

[Fillip H.]

admincp/thanks.php?do=finalise&version=111&startat=5000&perpage=250

That would be an example of how to resume starting at User ID #5000

 

[hornstar]

That looks like the first script that I ran. I have finished that one (that did all 600 000 users in about an hour), the one I am running now is the 2nd one you told me about. "Recalc function in Thanks' Maintenance section"

 

[Fillip H.]

Ohhhh, I see.

In that case it's admincp/thanks.php?do=maintenance&action=recalc&startat=5000&perpage=1000 to do 1000 users per page starting at 5000. Modify the URL parameters as needed