Forum OpenACS Development: Null value in column "session_id"

Collapse
1: Null value in column "session_id"
Posted by Malte Sussdorff on 11/16/06 01:54 PM
Any clue how I can get rid of:

Error: Ns_PgExec: result status: 7 message: ERROR: null value in column "session_id" violates not-null constraint

Not that it has any effect, it is just painfully annoying 😊.

Collapse
2: Re: Null value in column "session_id" (response to 1)
Posted by Ryan Gallimore on 08/30/08 11:47 PM
Hi Malte,

Did you ever figure this out? I can't see how sec_session_properties.session_id could ever be null.

Collapse
3: Re: Null value in column "session_id" (response to 1)
Posted by Ryan Gallimore on 08/22/11 10:51 PM
Turn off user-switching in developer support.

A request from a user who is not logged in will try to set a client property (see trace below). This will fail since [ad_conn session_id] is null - it hasn't been set yet when ds_collect_connection_info runs.

invoked from within
  ad_set_client_property developer-support user_id 0
invoked from within
  ds_replace_get_user_procs 1
invoked from within
  ds_collect_connection_info
invoked from within
  rp_filter preauth