Forum OpenACS Q&A: Spam module in 3.2.5 trouble?

Hi everyone,

I recently decided that I wanted to spam the registered users of my
little friends-and-family oACS installation.  I wrote up the spam,
and waited for it to go out.  The spam goes to "sending" fairly
quickly, but then never actually seems to get sent.  (I didn't
receive it, I didn't get a bounce, it continues to list as "sending"
24 hours later, with 0 messages sent.)

Obviously something is screwy here.

oACS successfully sends errors in the logs, bboard postings, etc.  So
mail from other modules is working.  But not spam.

I got this spam by doing a search for users and clicking "spam these
users."  I don't have any user classes defined.  (Is this part of the
problem?)

Before I pull any hair out (lacking an error message anywhere), can
anyone suggest where I might start to look for the problem?  This one
has me stumped!

Thanks!

Cathy

She did say "everything but spam" is working...

So I tried sending more spam, this time using a user group for selecting spamees, and the spam sent just fine.  Apparently leaving all the selection fields blank, while it does produce a list of all users, does not work for actually sending out spam.  I'll SDM this one once I've had a chance to look at the code a bit more.

I bet it uses the users_spammable view. On Oracle that view breaks and has to be recompiled any time you add a column to users (because the view is defined as "select * from users where..."). You might try the PostGres equivalent of "select object_name, object_type from user_objects where status = 'INVALID';" to see if your data dictionary shows any invalid views (or functions, etc). I would however expect that if this were the problem that there would be a database error logged to the server error log.