Question Same/Double Achievements Error

[HaZaRd]

My server is slow and sometimes gave the error "MySQL server has gone away". Now I have solved the problem (thanks to vBOptimise) but on those rare occasions, some achievements have been awarded several times for a single user. There are users with the same Achievements repeated for 4 times, gained at the same time.

I have already taken steps to delete the data and do the recalculation of Achievements but nothing has changed. I then deleted the achievements and I created it again, I redid the recalculation and the problem was solved, but this in the local copy of the site!!

Why the recalculation have no effect? And why cancel and redo the achievements from scratch work?

Thank!!

 

[Fillip H.]

The recalculation won't work because it won't truncate a user's achievements, just re-check whether they should have each individual achievement they do have.

Try running

DELETE FROM dbtech_vbactivity_rewards WHERE feature = 'achievement'

then run the re-calculate functionality, see if that works.

 

[HaZaRd]

OOooohhhhh yeah!! Problem solved!

The only sin: the achievements are now in a row, and not in order of acquisition. But... this is not a problem!

Thank you very much! DBTech 4 Life heheh...