3.3.x Extensions Database 3.2 / 3.3 ⇒ Newsletter

[medic]

Happy to hear that
Thanks again for the extension I'm using it to send 75 mail /hour manually by choosing members to avoid reaching limits

[dmzx]

First post updated.

[ssl]

Hi
French translation for 1.0.3 version here

[John_Smith]

Questions:

I'm currently using phpbbde/newsletter by Oliver Schramm. This one offers me to add a "Newsletter Subscribe" option (always active on sign-up) in the UCP. There is one problem though, it is an additional button for the Mass Email feature (ACP), results in an extra post to the admin account, and I can't send anything in HTML.

Your extension seems to be a "global" one. meaning, people can not decided to change their subscription. Is this implemented in some shape or form? (control via UCP / subscription handling as link in footer of mail, etc)



Additionally, since this seems to be another mass email type function, is this bound to the forum email engine (mail limits/chunks)?



And for understandable purposes:

This EXT needs:
- HTML email extension (if I want to send HTML emails)
- Editor extension (in order for the HTML email extension to work)

But if I use the plain EXT, I don't need the Editor extension?



Thank you for answering my questions.

[John_Smith]

Since nobody answered me this so far, a couple of findings

1) the Newsletter EXT creates a dedicated option in the ACP (ADM) > System > General Tasks > Email Newsletter

2) in order for this EXT to send out HTML, it needs both the HTML email EXT and the Editor extension.

3) if you activated the HTML email EXT, every message sent through this extension, then it's not sent as Plain Text, but HTML (therefore it ignores your layout)

4) there is no option like other Newsletter EXTs where you can set "Newsletter: When this is activated you will receive the newsletter frequently".

5) this EXT uses the "Administrators can email me information" function in UCP > Board Preferences > Edit global settings. If you got this turned off, nobody will get your newsletter


BONUS:
Add-on works in phpBB 3.3.4 (didn't test 3.3.5 yet - as it was just released)




As good as this add-on is, it needs one essential function, or rather two:


A) it needs an option in the UCP to let users turn the newsletter on/off

Due to laws in Europe, this is a highly risky topic (spam and unwanted advertising). This needs to be available as option, as I do not see/know of a method to manually turn on/off newsletters for certain users. A workaround might be a custom group, but creating one for 1000+ users currently is not an option for me.


B) on initial installation / activation, "force enable" newsletter for everyone

Also see A. On first install, everyone should be signed up to the newsletter. If not, there should be a global override option that you can access if needed (for example: fix newsletters once every year). This way, an already "live" forum can be updated with a new Newsletter engine (as mentioned in my previous post, I am using phpbbde/newsletter by Oliver Schramm -- but the requests for HTML options don't seem to happen) anytime soon, also "still alpha", even though it works perfectly).



I would love to use this add-on as this would finally fix a long-term issue on my end (readability of info mails). But without an option in the UCP (User Control Panel), I currently can't use this. If you could add this option on short notice (as in 3-5 weeks), that would be outstanding.

[medic]

Hi and thank you for this extension im just waiting for the option to not sent it immediately it caused me to be banned every time i use it so if it can handle the send by quota 150/ hour that will be awesome
queu mail option

[SpIdErPiGgY]

Please help...

Code: Select all

[Sat Jun 29 06:04:39.233726 2024] [proxy_fcgi:error] [pid 24380:tid 140413620975360] [client 2a02:1812:1e10:400:ad77:3d4c:36dc:bf7a:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined method messenger::set_mail_html() in /var/www/vhosts/myarea51secrets.com/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php:373\nStack trace:\n#0 /var/www/vhosts/myarea51secrets.com/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php(253): dmzx\\newsletter\\controller\\acp_controller->email_member()\n#1 /var/www/vhosts/myarea51secrets.com/httpdocs/ext/dmzx/newsletter/acp/main_module.php(44): dmzx\\newsletter\\controller\\acp_controller->display_options()\n#2 /var/www/vhosts/myarea51secrets.com/httpdocs/includes/functions_module.php(676): dmzx\\newsletter\\acp\\main_module->main()\n#3 /var/www/vhosts/myarea51secrets.com/httpdocs/adm/index.php(81): p_master->load_active()\n#4 {main}\n  thrown in /var/www/vhosts/myarea51secrets.com/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php on line 373', referer: https://www.myarea51secrets.com/adm/index.php?sid=90fc20090c813e41190f1243ee3a7595&i=-dmzx-newsletter-acp-main_module&mode=newsletter

phpBB 3.3.12
PHP 8.3.8
MySQL(i) 10.11.8-MariaDB-deb10

[dmzx]

First post updated.

[Aragon Burner]

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'u.user_ip' in 'SELECT' [1054]

SQL

SELECT u.user_id, u.user_ip, u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type FROM (phpbb_ailabs_users u) WHERE u.user_allow_massemail = 1 AND u.user_type IN (0, 3) ORDER BY u.user_lang, u.user_notify_type

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 213
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/dmzx/newsletter/controller/acp_controller.php
LINE: 218
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/newsletter/acp/main_module.php
LINE: 44
CALL: dmzx\newsletter\controller\acp_controller->display_options()

FILE: [ROOT]/includes/functions_module.php
LINE: 684
CALL: dmzx\newsletter\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

When i try to send the email

[dmzx]

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'u.user_ip' in 'SELECT' [1054]

SQL

SELECT u.user_id, u.user_ip, u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type FROM (phpbb_ailabs_users u) WHERE u.user_allow_massemail = 1 AND u.user_type IN (0, 3) ORDER BY u.user_lang, u.user_notify_type

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 213
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/dmzx/newsletter/controller/acp_controller.php
LINE: 218
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/newsletter/acp/main_module.php
LINE: 44
CALL: dmzx\newsletter\controller\acp_controller->display_options()

FILE: [ROOT]/includes/functions_module.php
LINE: 684
CALL: dmzx\newsletter\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

When i try to send the email

can you check the user_ip in user database table

[Aragon Burner]

I would have no idea how to do so mate

[ivailo95]

I would have no idea how to do so mate

go to ur hosting panel, look for database panel
click on it and u will see ur data, the prefix of ur board is smth like mybb_ smth like this
try to find what sniper said

[SpIdErPiGgY]

Still this error

Code: Select all

Fatal error: Uncaught Error: Call to undefined method messenger::set_mail_html() in /var/www/vhosts/phpbbextnl.be/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php:375 Stack trace: #0 /var/www/vhosts/phpbbextnl.be/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php(263): dmzx\newsletter\controller\acp_controller->email_member() #1 /var/www/vhosts/phpbbextnl.be/httpdocs/ext/dmzx/newsletter/acp/main_module.php(44): dmzx\newsletter\controller\acp_controller->display_options() #2 /var/www/vhosts/phpbbextnl.be/httpdocs/includes/functions_module.php(684): dmzx\newsletter\acp\main_module->main() #3 /var/www/vhosts/phpbbextnl.be/httpdocs/adm/index.php(81): p_master->load_active() #4 {main} thrown in /var/www/vhosts/phpbbextnl.be/httpdocs/ext/dmzx/newsletter/controller/acp_controller.php on line 375

[Sniper_E]

I know little about those kinds of errors to help out, but I run PHP version: 8.3.15 and this extension installed and works fine for me.
SpIdErPiGgY told me he was running PHP version: 8.4 if that makes a difference. I have no advice in that area.

Please wait for our next representative, someone will with you shortly. And thank you for shopping at dmxz-web!

[SpIdErPiGgY]

I found it.

I disabled HTML email, and removed data.
Then installed again and yes... Newsletter sended without issue 🫣