Thanks stats

[hornstar]

I just upgraded to the latest available version.

After I ran the maintenance tools (because I thought I had to).

But now I realize that many members stats have dropped hugely.

eg. My thanks Received is now 2. Where as before it was a few thousand. and my Likes received is 3, where as before it was huge too.

Than it crossed my mind, that maybe it is because I was originally on the vb.org Post Thanks Hack, and because I had imported those stats over to this one. Is that why?

I just need to know how to either get those stats back by importing the old data over (and not loosing any new data), or if this is a bug and how should I get it fixed?

Thanks.

 

[Fillip H.]

First you need to run UPDATE post_thanks SET __imported = 0
Remember to add your table prefix.

Also, if you're using Pro, you need to change entrytype to varname in the thanksimport.php file.
Then you can import again

 

[hornstar]

Alright I ran:
UPDATE vb3_post_thanks SET __imported = 0

Changed in thanksimport.php

$db->query_write("
				INSERT INTO " . TABLE_PREFIX . "dbtech_thanks_entry
					(entrytype, userid, contenttype, contentid, dateline)

to

$db->query_write("
				INSERT INTO " . TABLE_PREFIX . "dbtech_thanks_entry
					(varname, userid, contenttype, contentid, dateline)

Uploaded the file.
Ran the file.


Now my question is. Which of the 3 maintenance tools can I run and can I not run?

There is Clean Up, Recalculate and Rebuild Statistics.

 

[Fillip H.]

Clean Up would be a bad thing potentially, it'll erase everything that's not linked to an existing post.

 

[hornstar]

Alright I will run the other 2 now. Thanks.

 

[hornstar]

I think the importer added the stats to Thanks Given. Because that is now 1871, but my Thanks Received is only 2 and Likes Received is only 3. Very strange.

 

[Fillip H.]

Ah yeah, that's something that will be fixed in the importer for when 1.1.x goes Final

 

[hornstar]

oh :/ bummer. Hopefully wont be like this for long tho, it is only time until members notice they have lost thousands of thanks and kick up a stink lol