Variable USERNAME in mass mail

[Ulenka]

Thank you very much! Everything turned out, if I send letters to a small group. With a group of 700 users the database generated an error. Are there any ideas how to fix it? I have a dedicated server, I used to send a letter to large groups without problems.

Code: Select all

SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

SQL

SELECT group_name, group_type FROM phpbb_groups WHERE group_id = 245

BACKTRACE

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

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

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

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

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

FILE: [ROOT]/includes/acp/acp_email.php
LINE: 283
CALL: get_group_name()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_email->main()

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

[kasimi]

Pretty sure this is a side effect of sending the mails individually. According to this, increasing these two PHP config values helps:

Code: Select all

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);

Add these two lines after $max_chunk_size = 0;

Careful, it's possible you've already sent the email to some of your users. Those users will get a second email if you send another mail to every user again.

[Ulenka]

Kasimi, I am very grateful to you!

[Ulenka]

Please, help me. After updating forum to 3.2.8 when I send Mass mail messages an error occurs:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 272661476 bytes) in /public_html/forum/includes/functions_messenger.php on line 1060

Line 1060 in function_messenger.php is

Code: Select all

fwrite($fp, "<?php\nif (!defined('IN_PHPBB')) exit;\n\$this->queue_data = unserialize(" . var_export(serialize($this->data), true) . ");\n\n?>");

[Mick]

It means the 256MB allocated to PHP has run out, you need to increase that.