MODS.DB9.DK

[mcyates]

I am using the lastest phpbb 2.0.2 and the latest version of this mod and i still get the error

82
Coult not select group members!

I can send to usergroups but not to the all users

[Niels]

in this mod, there are 2 ways to send out to users , either through admin panel, or calling the link directly, witch have you been using..

[Niels]

I have checked this, and in the admin panel version in the pre-loaded pack is a bug
to correct this
[FIND]
$sql = "SELECT user_email, user_lang
FROM " . USERS_TABLE." WHERE u.user_email <> '' ORDER BY user_lang";

[REPLACE WITH]
$sql = "SELECT user_email, user_lang
FROM " . USERS_TABLE." WHERE user_email <> '' ORDER BY user_lang";

Note: I alway use the direct link way to call this
( www.yoursite.com/phpbb/mass_email.php )

it have some more features than the one included into the admin panel, "user name in email" and custom number of client in eatch email

[mcyates]

its working now. the mass_mail.php was in the wrong directory. I put it into the admin directory by mistake. Thanks, its a great script!!

[mcyates]

the mass_mail.php works but the admin_mass_mail.php does not work, comes up with the

82
Coult not select group members!


Is there anyway I can fix this

[Holger]

Hi Niels!

I get the following error-message:

268

Could not select group names!

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_allow_email' in 'where clause'

Line : /is/htdocs/32261/www.manual-forum.de/phpbb/mass_email.php
File : SELECT DISTINCT g.group_id, g.group_name FROM phpbb_groups g, phpbb_user_group ug WHERE g.group_single_user <> 1 AND ( ('1'='1') OR (g.group_allow_email='3' AND g.group_moderator = '2') OR (g.group_allow_email='2' AND ug.user_id = 2 AND ug.group_id = g.group_id ) OR (g.group_allow_email='1' AND '2'!='-1' ) OR (g.group_allow_email='0') )

It worked some days ago, but now (after the security-update) it doesn't ...

/Holger

[Niels]

Hi Niels!

I get the following error-message:

268

Could not select group names!

It worked some days ago, but now (after the security-update) it doesn't ...

/Holger

When you do the update, then you must follow the how-to again, since basically the how-to new code.
The change to admin_mass_email.php are no longer included, so to roll back this, simply use a original admin_mass_email.php

when the how-to is done, you may once again use the included mass_email.php file, now with more flexeble options in admin panel

[Holger]

Ah! Thanks! Will try that!

/Holger