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.