in reply to Updating a new column entry for CGI::Session 'sessions' table

Not sure if this will help but... what value are you putting into user_id when you create the row as user_id is not null? Perhaps this is related to the problem (ie DB is blocking the update due to referential intergrity problems, same for delete)...

--tidiness is the memory loss of environmental mnemonics

Replies are listed 'Best First'.
Re: Re: Updating a new column entry for CGI::Session 'sessions' table
by soon_j (Scribe) on Mar 25, 2004 at 14:09 UTC

    The $user_id is verified to be a real value and not NULL. I even tried hard-coding in my code:

    $sth = $dbh->do ("UPDATE sessions SET user_id='20' WHERE id='$CGISESSID'");

    Still I got the same results

[reply]
[d/l]
      I was refering to the value that is in user_id in the database when you try to update it, not the value you are trying to insert.

      --tidiness is the memory loss of environmental mnemonics

[reply]
[d/l]
        The column was defined as NOT NULL and the default was set to 0.
[reply]

In Section Seekers of Perl Wisdom