xenforo mail settings?

[#Anakin]

Hi everyone,

I'm seeking support regarding an issue I'm facing with XenForo. Is it possible to configure XenForo to send only registration emails and disable all other email notifications for topics and replies?

I'm on the verge of being banned by my hosting provider because too many emails are being sent, resulting in a lot of bouncing emails. My provider limits me to a maximum of 50 emails per hour, and exceeding this limit puts me at risk of being banned from the platform, even though these emails are auto-generated and beyond my control.

Any guidance on how to set XenForo to send only registration emails and no other notifications would be greatly appreciated. Thank you in advance for your help!

Best regards, Anakin

 

[olgert zerbaska]

On the registration settings make the changes as shown in screenshot


Then with css or template modification hideo or remove the unchecked options shown on the screenshot so the user won’t change it back


What I showed is for new registrations, to make those changes (screenshot 2) for the old members you will need sql query

 

[#Anakin]

thank you very much.. and what about sql query.. sorry im a newbie

 

[philmckrackon]

thank you very much.. and what about sql query.. sorry im a newbie

Some email query examples - Change state as needed:

https://xenforo.com/community/threa...ications-for-all-members.203493/#post-1562815

 

[#Anakin]

how do i remove from the preferences of all users the email notification

 

[#Anakin]

Some email query examples - Change state as needed:

https://xenforo.com/community/threa...ications-for-all-members.203493/#post-1562815

excuse me.. where should i copy past that code? thank you for help

 

[MentaL]

excuse me.. where should i copy past that code? thank you for help

phpmyadmin would be the easiest.

 

[#Anakin]

it exist a guide step by step? im a n00b.. lol
i have downloaded phpmyadmin

 

[#Anakin]

im inside phpmyadmin

and set in the search bar "xf_thread_watch"
but cant find it

 

[philmckrackon]

it exist a guide step by step? im a n00b.. lol
i have downloaded phpmyadmin

Modifying the DB can kill your site. MAKE A BACKUP.
Are you on a managed server? Might want to contact your host.

MySQL :: MySQL 8.0 Reference Manual :: 15.2 Data Manipulation Statements

dev.mysql.com

1) Selecet DB


2) Select SQL tab

 

[#Anakin]

i cant find these parameters

update xf_forum_watch
set send_email = 0
where send_email = 1;

i just have to change 1 to 0. dont think i can destroy the website.. but i cant find it

 

[MentaL]

i cant find these parameters

update xf_forum_watch
set send_email = 0
where send_email = 1;

i just have to change 1 to 0. dont think i can destroy the website.. but i cant find it

Those are SQL querys that you run on a database.

 

[#Anakin]

Those are SQL querys that you run on a database.

i cant find those parameters to edit. sorry guys. im probably retarded..
can u link a topic or video for dumb people like me so i can do it and resolve the issue. thank you very much for your patience

 

[philmckrackon]

You don't edit, you run the query in the SQL tab that is shown as item 2 here. -->> https://xenforo.com/community/threads/xenforo-mail-settings.221843/post-1683232

 

[#Anakin]

like this?

 

[philmckrackon]

Just do one query at a time as a test before you commit.
Did you make a copy / backup of your database? Please do so!

 

[#Anakin]

succesful queries

MariaDB [ilfoinsn_database]> update xf_user_option
-> set creation_watch_state = 'watch_no_email'
-> where creation_watch_state = 'watch_email';
Query OK, 902 rows affected (0.011 sec)
Rows matched: 902 Changed: 902 Warnings: 0

MariaDB [ilfoinsn_database]> update xf_user_option
-> set interaction_watch_state = 'watch_no_email'
-> where interaction_watch_state = 'watch_email';
Query OK, 901 rows affected (0.010 sec)
Rows matched: 901 Changed: 901 Warnings: 0

MariaDB [ilfoinsn_database]> update xf_thread_watch
-> set email_subscribe = 0
-> where email_subscribe = 1;
Query OK, 39981 rows affected (0.517 sec)
Rows matched: 39981 Changed: 39981 Warnings: 0


Only the last one didn't went through, as it is missing:

update xf_thread_watch

-> set send_email = 0
-> where send_email = 1;
ERROR 1054 (42S22): Unknown column 'send_email' in 'where clause'

 

[#Anakin]

It is missing:

SELECT COLUMN_NAME

-> FROM INFORMATION_SCHEMA.COLUMNS
-> WHERE TABLE_NAME = 'xf_thread_watch' AND COLUMN_NAME = 'send_email';
Empty set (0.021 sec)

 

[MentaL]

succesful queries

MariaDB [ilfoinsn_database]> update xf_user_option
-> set creation_watch_state = 'watch_no_email'
-> where creation_watch_state = 'watch_email';
Query OK, 902 rows affected (0.011 sec)
Rows matched: 902 Changed: 902 Warnings: 0

MariaDB [ilfoinsn_database]> update xf_user_option
-> set interaction_watch_state = 'watch_no_email'
-> where interaction_watch_state = 'watch_email';
Query OK, 901 rows affected (0.010 sec)
Rows matched: 901 Changed: 901 Warnings: 0

MariaDB [ilfoinsn_database]> update xf_thread_watch
-> set email_subscribe = 0
-> where email_subscribe = 1;
Query OK, 39981 rows affected (0.517 sec)
Rows matched: 39981 Changed: 39981 Warnings: 0


Only the last one didn't went through, as it is missing:

-> set send_email = 0
-> where send_email = 1;
ERROR 1054 (42S22): Unknown column 'send_email' in 'where clause'

I checked mine on a fresh DB and it doesn't exist that is why.

 

[#Anakin]

so i should be fine with queries i already entered? its all right?
no one will receive push up mails anymore.. i mean old uses..
new users wont have mail notifications by default