Forum .LRN Q&A: Problem sending spam

Collapse
Posted by Ricard Garrido on
I dont have any idea about if this bug is fixed or something, so i post here the bug :)

When sending spam, if u dont want to send the mail to everyone in the subject, but only to the teachers, and u select the apropiate option that is given, the mail will be sent to everyone in the subject, not only teachers, but also students.

If the bug is not already solved, its good to have care about it, cause it can be dangerous if u want to spam teachers with a private mail and everyone get it :)

Collapse
2: Re: Problem sending spam (response to 1)
Posted by Dario Roig on
Hi!

The bug that Ricardo says, is in the production platform, "http://pizarra.uv.es" of University of Valencia.

In "pizarra.uv.es" we have installed the branch oacs-5-1.

The query /packages/dotlrn/www/spam-postgresql.xql not  this prepared one to select groups.

Is solved this bug in HEAD?

Thanks

Collapse
3: Re: Problem sending spam (response to 1)
Posted by Enrique Catalan on
Hi Ricard,

Did you report it in bugtracker ?

if not, can you add the bug please ?

thanks

Regards,
Enrique

Collapse
4: Re: Problem sending spam (response to 3)
Posted by Jose Agustin Lopez Bueno on
Hello!

We are curently using oacs 5-1.

The bulk mail code do not works well. If I choose
send mail only to students (or teachers) the mail
is sent to all members. I am looking at the code
and appears the code is not finished. I am now trying
the spam* code from HEAD and the code appears
more robust. But it do not works too.

I am stuck with spam.tcl and the last step before send
bulk mail. I get the next error:

can't read "segment_id": no such variable
    while executing
"subst -nobackslashes {
        select '$from' as from_addr,
              '$sender_first_names' as sender_first_names,
              '$sender_last_n..."
    ("uplevel" body line 1)
    invoked from within

In spam-postgresql.xql the sql needs a "segment_id"
variable I do not find anywhere:

...
where party_approved_member_map.party_id = $segment_id
  and party_approved_member_map.member_id <> $segment_id
...

Any help, please?
I will like this funcionality for my production
environment.

Best regards,
Agustin

Collapse
5: Re: Problem sending spam (response to 1)
Posted by Enrique Catalan on
Hi,

I fixed that bug for oacs-5-1. I commited it too.

You need to update your ...../packages/dotlrn/www/spam.tcl and ...../packages/dotlrn/www/spam-postgresql.xql.

Regards,
Enrique.

Collapse
6: Re: Problem sending spam (response to 5)
Posted by Jose Agustin Lopez Bueno on
Ok.

Thanks you very much!

I am testing it a bit and works Ok!

Again, thanks!

Regards,
Agustin