XF 2.2 Activity summary email sql unpaused state

[Biarritz64]

Mike answered this above. Essentially if a user has "Receive news and update emails" enabled then they will be opted-in, but in a "paused" state.

While in that state, you do not receive emails, but if you visit the forum again you become unpaused and will receive emails again if you become inactive.

Hi
Is there an SQL query that can make all users in pause state to unpause state for Activity summary email?

 

[Onlyme]

I would also like to know if this is possible?

 

[Onlyme]

This is how i got it working:

UPDATE `xf_user` SET `last_activity` = '1607519593';
UPDATE `xf_user` SET `last_summary_email_date` = '1607519593';