Forum OpenACS Development: Re: ad_proc [cc_email_user] returns blank

Collapse
Posted by Iuri Sampaio on
Going further on debugging, the email has been storaged on table acs_users_all.

Context:
ad_proc cc_email_user runs the private ad_proc cc_lookup_email_user, which runs the SQL line as follows.

select user_id from acs_users_all where lower(email) = lower(:email)

Furthermore,
By runing the query alone within pgsql shell prompt, the user_id is properly returned.

Thus, I have flushed the memory and restarted NaviServer, but the problem still persists.

Best wishes