Hi all, and thank to you for this module which should be able to make my life much easier!

I have Drupal 5 and have installed the latest version of the module. I have a field called "country of residence" in my profile. I have tried to include in the filtering by ticking the box on the configuration page.

When I go to the "advanced management" page, I get the typical filtering options and at the bottom I can choose "country of residence" except that there is no drop-down menu next to it!!! I don't understand why.

I posted a screenshot here: http://pyrn.ways.org/files/example.JPG

Would be great if there was a solution to it. Thanks in advance.

If you happen to look at it, do you think it could be possible to make the drop-down selection field for "country" formatted so that multiple choices are possible? I would like for instance to email all members from China, Nigeria and Norway at the same time.

Comments

gostram’s picture

gostram commented

Hi again. I tried to sort the users by "country" to bypass the issue and check all users manually by country, but when I click on the field title it gives me this:

user warning: Unknown column 'profile_cor' in 'order clause' query: SELECT DISTINCT u.uid, u.name, u.status, u.created, u.access FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid WHERE u.uid != 0 ORDER BY profile_cor ASC LIMIT 0, 50 in /home/ways/public_html/pyrn/includes/database.mysql.inc on line 172.

Anonymous’s picture

Anonymous (not verified) commented

I'm not sure yet how I am going to handle this issue. I may prevent sorting on the profile fields; but, that is the last measure.

gostram’s picture

gostram commented

Thanks Earnie. The error I get when sorting profile fields is not a big deal though. The best thing would be to be able to filter according to these profile fields and email the resulting list. I am not sure how much work it would require to fix this but thanks in advance for looking into it.

gostram’s picture

gostram commented

Hi earnie, any update on this issue? I am trying to figure out out to mass email some members but I really don't know how to do this without advanced user. Maybe with another module??

Anonymous’s picture

Anonymous (not verified) commented

As of Friday/Saturday you should be able to email your chosen group. I need to work more on the profile filtering. I plan to do some more work this week. I'll keep you updated.

Anonymous’s picture

Anonymous (not verified) commented

BTW, as of last Friday/Saturday I have the email functions working as they should. You should always use a test sample before sending mail to everyone.

gostram’s picture

gostram commented

thanks earnie, already looking forward to use the profile filtering function.

mitchh’s picture

mitchh commented

Is initial problem (#1) same as in http://drupal.org/node/109916 ?
if so patch provided may help.

gostram’s picture

gostram commented

Ye I think that's it. thanks mitchh. Will check right now.

gostram’s picture

gostram commented

Well, it seems that I am unable to apply patches to the module without disrupting my entire site. Hum, would be great if it'd be incorporated in the module, we'll see I guess.

gostram’s picture

gostram commented

hum, I just mass e-mailed everyone on my site out of desperation. I hope it will be possible to fix it in the module file. Thanks for the help earnie and mitchh

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (duplicate)

#255777: Refining search on more than one profile field produces SQL error