MODS.DB9.DK

[Holger]

Hi Niels!

I am using the MOD for my board with 1.019 members.
I get the following error:

131

Coult not select group members!

DEBUG MODE

SQL Error : 2013 Lost connection to MySQL server during query

Line : /is/htdocs/32261/www.manual-forum.de/phpbb/mass_email.php
File : SELECT distinct u.user_email, u.user_lang, u.username, u.user_id FROM phpbb_users u, phpbb_user_group ug, phpbb_groups g WHERE ug.group_id = 535 AND ug.user_pending <> 1 AND u.user_id = ug.user_id AND u.user_email <> '' ORDER BY u.user_lang

after the mail has been sent to round about 100 users (MAX_CLIENTS-function = 100)

Is this only a problem at my providers side or can this also be caused by invalide mail-addresses? I know that the phpBB stopps sending mass-emails when detecting invalide email-addresses. Can you make a workaround for that? Or am I wrong at that point?

/Holger

[Niels]

this must be due to a slow SMTP server, the data is partly fetched on the scripts initialization, and when the first email have been send out, the script will fetch the next 100 users data from the DB

after the first 100 email have been send out (and apperently it took long time) the DB is repporting a timeout, when trying to query for the next 100.

a solution would be to try lower the MAX_CLIENT_IN_EMAIL, you could try different values e.g. 20, and see if this runs better, even a value of 2000 could help, becouse all users would be fetched in one query, thereby eliminate the DB problem.
Some SMTP servers will however not send sutch large emails, so it all depends on this, wether to lower or higer the value.

[Holger]

I tried it with 1.000 and it worked! Thank you for the hint!

Now, the only problem is that I cannot use it with the function that put the username on top of the mail. But that does not matter.

Thanks!

/Holger

[Niels]

have you tryed to lower the value...try with a value of 1, it migth work, this way eatch user get a "private" email with his/her own name

[Holger]

Yes, I had it running with the setting "1".
The problem was: There was only ONE mail sent out every MINUTE. And I received a copy of each mail (over 1.000)! And: the mail-transfer was interrupted like described above.

So it is better to use it like I do now.
Or is it possible to disable the selfcopy?

/Holger

[Niels]

this only confirm that your problem was a slow SMTP server...

it would be posible to awoid the "self copy" BUT ONLY if MAX_CLIENT_IN_EMAIL is set to 1, I will proberly make a upgrade, witch makes the mod work so

[Holger]

I will keep the setting 1.000 now.
Thank you very much for your support!

/Holger