11.000 users registered, all in the "Registered" group.
No condition, just users who belong to the group.
Only 435 recipients.
Why?
How can I solve the problem?
It seems the problem is the "allownotices" field in the users table.
Users imported from PHPBB3 have
allownotices=0, so I can't send them emails.
A quick solution, a bit intrusive yeah:
UPDATE `mybb_users` SET `allownotices`=1 WHERE `allownotices`=0
Quick followup question... where (what file) to edit below code ?
(2012-10-30, 05:25 PM)Salvatore Wrote: [ -> ]It seems the problem is the "allownotices" field in the users table.
Users imported from PHPBB3 have allownotices=0, so I can't send them emails.
A quick solution, a bit intrusive yeah:
UPDATE `mybb_users` SET `allownotices`=1 WHERE `allownotices`=0
In order to send mass email to all members of group, need to go to database and set '0' to '1' per below.
But seems like only temporary fix.
How, if possible, to make it so the 'allownotices = 1' without needing to edit the database ?
At phpMyAdmin>_databasename>mybb_users>SQL>)...
replace...
SELECT * FROM `mybb_users` WHERE 1
with...
UPDATE `mybb_users` SET `allownotices`=1 WHERE `allownotices`=0
...for make mass mailings send to all in group.
(2012-10-30, 05:25 PM)Salvatore Wrote: [ -> ]11.000 users registered, all in the "Registered" group.
No condition, just users who belong to the group.
Only 435 recipients.
Why?
How can I solve the problem?
It seems the problem is the "allownotices" field in the users table.
Users imported from PHPBB3 have allownotices=0, so I can't send them emails.
A quick solution, a bit intrusive yeah:
UPDATE `mybb_users` SET `allownotices`=1 WHERE `allownotices`=0
(2014-09-28, 02:33 AM)rahlzel Wrote: [ -> ]So far, 95% of the forum is in good shape after using ACP > Tools > Recount & Rebuild and Cache Manager.
The only issues I've seen thus far are:
- All users have "Hide from the Who's Online list" set to ON
- All forums have their settings "Yes, posts in this forum should count towards user post counts" OFF and "Yes, threads in this forum should count towards user thread counts" OFF.
- Avatars are missing.
#1 and #2 are fairly easy to fix with the following queries:
UPDATE `mybb_users` SET `invisible` = 0;
UPDATE `mybb_forums` SET `usepostcounts`=1, `usethreadcounts`=1;
Now to battle with the MyBB 1.8 bugs.
Thanks, I had to use
UPDATE `mybb_users` SET `allownotices`=1 WHERE `allownotices`=0
to fix this myself in 1.8.