How to Enable status updates for all members?Profile setting

[Maxxius]

hi guys, you know perhaps a query I could run to enable status updates for all members.

as if everyone turned this on:

[Adriano Faria]

ACP -> Members -> Profiles -> Profile Settings tab -> Status Updates -> choose Enabled by default.

[Maxxius]

The strange thing was that this was enabled for all groups BUT when I logged in as one member who was like "hey where did the status updates went?" I noticed that it was not turned on in his account settings. Very strange. Waiting for his answer to verify if he did not turn it off by mistake sometime in the past.

[Adriano Faria]

This is for new members. For existing members, you will have to run a query.

[Maxxius]

Oh.. well the query is what I hoped somebody would share in the topic which needs to be ran to turn it on for everybody. 🙂

[Adriano Faria]

Query:

updare core_members set pp_setting_count_comments = 1;

This will enable Status Updates to all existing members.

Add the Db prefix (sql_tbl_prefix from conf_global.php) to the table name in case you use one.

[Maxxius]

Sweet, thank you @Adriano Faria!!

[Jordan Miller]

On 1/22/2020 at 4:34 AM, Adriano Faria said:

Query:

updare core_members set pp_setting_count_comments = 1;

This will enable Status Updates to all existing members.

Add the Db prefix (sql_tbl_prefix from conf_global.php) to the table name in case you use one.

Can someone help me understand this a little better please 🙂

I want to enable status updates for all existing members. Everyone has it off. I'm not quite sure what to do here. Any help would be greatly appreciated. 

[Maxxius]

go into phpMyAdmin, click on your database on the left, then in center top search for SQL tab click it, and when a windows loads copy the code that is in the post above and click go. also make sure if you have a prefix in the database tables to include that into the command too.

[Zhana]

On 1/22/2020 at 3:16 PM, Adriano Faria said:

ACP -> Members -> Profiles -> Profile Settings tab -> Status Updates -> choose Enabled by default.

Thanks, had to disable it on my board as they were abusing it for spam.

[Sheffielder]

6 hours ago, Zhana said:

Thanks, had to disable it on my board as they were abusing it for spam.

Same here - spammers fully abused it