Coult not select group members! (Using latest phpbb & mo

This mod, will add the ability to make "newsletters" and other customised mass emails, status is showen while sending mass email
It will also be posible to grant other users permissions to send mass email to a specific usergroup
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

Coult not select group members! (Using latest phpbb & mo

Postby mcyates on Sun 03. Nov, 2002 20:39

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
mcyates
Poster
Poster
 
Posts: 24
Joined: Sun 03. Nov, 2002 20:36

Postby Niels on Mon 04. Nov, 2002 14:09

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..
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46

Postby Niels on Mon 04. Nov, 2002 14:19

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
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46

Postby mcyates on Thu 07. Nov, 2002 19:12

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!! :D
mcyates
Poster
Poster
 
Posts: 24
Joined: Sun 03. Nov, 2002 20:36

Postby mcyates on Thu 07. Nov, 2002 20:12

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
mcyates
Poster
Poster
 
Posts: 24
Joined: Sun 03. Nov, 2002 20:36

Postby Holger on Mon 18. Nov, 2002 17:08

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
~~~~~~~~~~~~~~~~~~~~~~~~~
www.manual-forum.de
Holger
Poster
Poster
 
Posts: 56
Joined: Wed 17. Jul, 2002 13:13

Postby Niels on Mon 18. Nov, 2002 17:46

Holger wrote: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
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46

Postby Holger on Mon 18. Nov, 2002 17:57

Ah! Thanks! Will try that!

/Holger
~~~~~~~~~~~~~~~~~~~~~~~~~
www.manual-forum.de
Holger
Poster
Poster
 
Posts: 56
Joined: Wed 17. Jul, 2002 13:13


Return to Custom mass email [2.0.8/EM]

Who is online

Users browsing this forum: No registered users and 0 guests

cron