Forum OpenACS Q&A: Is OpenACS emailing you errors?

Collapse
Posted by Jade Rubick on
I am frequently mailed error messages from OpenACS. The error messages vary a great deal, but I'm wondering if anyone has a 3.2.2 installation with the intranet working that is not getting any error messages mailed to them. If so, I guess I need to set things up better... This might be dull, but here's a sample of a few of the messages:
[12/Sep/2000:11:58:40]
    Error: Ns_PgExec: result status: 7 message: ERROR:  btree scan
list trashed; can't
find 0x0x40ba6ba0
    [this seems to be a variation of a bug in Postgres 7.02 that I
thought I had fixed]

[12/Sep/2000:12:58:13]
    Error: Ns_PgExec: result status: 7 message: ERROR:  parser: parse
error at or near
"("

[12/Sep/2000:12:58:13]
    Error: dbinit: error(localhost::intranet,ERROR:  parser: parse
error at or near "("
    ): 'select count(*) from ticket_issues
    where one_line = 'Test issue #2'
    and project_id = 1
    and dbms_lob.instr(message,'Make sure this issue is deal with :)')
> 0'
    Notice: failed trying to look up previous posting: Database
operation "1row" failed
(exception NSDB, "Query was not a statement returning rows.")

[12/Sep/2000:13:01:23]
    Error: dbinit: error(localhost::intranet,ERROR:  No such attribute
or function
'screen_name'
    ): 'select u.last_name || ', ' || u.first_names as full_name,
email, u.user_id
               from users_active u, user_group_map ugm, users_contact
uc
              where upper(u.last_name||' '||u.first_names||'
'||u.email||'
'||uc.aim_screen_name||' '||u.screen_name) like '%ASDF%'
                and u.user_id=ugm.user_id
                and ugm.group_id=8
                and u.user_id=uc.user_id
    union
    select u.last_name || ', ' || u.first_names as full_name, email,
u.user_id
               from users_active u, user_group_map ugm
              where upper(u.last_name||' '||u.first_names||'
'||u.email||' '||''||'
'||u.screen_name) like '%ASDF%'
                and u.user_id=ugm.user_id
                and ugm.group_id=8
                and not exists (select 1 from users_contact 
                                where user_id = u.user_id)
              order by lower(trim(full_name))'
I'm wondering if my Postgres installation might be the cause of it. I'm getting so used to reinstalling that it probably won't take that long to do this time... but if you have any ideas, I'd appreciate it.
Collapse
Posted by Chris Hardy on
Something screwed up with one of your indexes, basically, drop all intranet related indexes (and perhaps even views, I can't remember anymore) then add them back in.  Should fix it. (If I remember correctly.) As for the ticket stuff, I haven't gotten to it, but it looks like it might be choking on your :) in the query (Though I don't know yet).. You aught to turn on Full Debug, so it's clearer what's happening.  And last off.. Looks like the screen_name isn't in the users_active table, pop into psql and see what the schema looks like for the table.