Thank You Like - Recount very slow

[lost puppy]

There are 6 queries (I think lol) and the first 4 .... each took seconds (I mean the db states 0.0004 for each one)

Excellent - I was hoping it would be fast even on a site with millions of thanks/likes.

Only problem was on the 5th query

Oh, I see - that's because the tyl_tnumtyls column was mistakenly removed (by me) from the core threads table in version 3.1.0 (August, 2018) of the plugin, and only reinstated in the latest version 3.4.5 (August, 2023), to which you have not yet upgraded.

I've updated the script (as attached in my previous post) to handle scenarios like yours. Please test the new version of the script (1.1.0) and let me know whether the error is avoided this time.

But it would definitely seem that it worked anyway 

Taking 2 members:

On the real site forum Member 1 has 29671 'likes' >> but now on the 'test' site the member has 33690
Member 2 on the real forum has 381953 'likes' >> on 'test' site they now have 424704

Speed wise .... well what can I say ... last time it took near 24 hours and didn't complete (I had to stop it) 

This took seconds!!

Stunning ... thank you so very much ... you are a super star 

That's great news. Cheers for the positive feedback.

I tested it and all was well until the 5th query (creation of tyl_tnumtyls column) and the error given was:

Error
SQL query: Copy


PREPARE stmt FROM @query;
MySQL said: Documentation

#1044 - Access denied for user 'REDACTED'@'%' to database 'information_schema'

The Redacted part was the correct db user name .... so is that something I need to sort out somehow?

The last 2 queries came back with the same error as before (which I guess it would as the column isn't there).

Thanks again Laird