Thank you very much for your exhaustive reply.
The query indeed showed that users didn’t visit the forum the day it was read-only.
I’ll grant the badge from the console, thank you for this additional info 
Couldn’t grant the badge as the Devotee badge can’t be granted multiple times. But good to know anyway!