[phplib] ct_sql: ac_store problem on AIX From: darcy w. christ (darcy <email protected>)
Date: 04/26/00

ok, now i may be getting somewhere.

whatever seems to be causing the trouble with duplicate entries into the
active_sessions table seems to be happening in ct_sql in the ac_store
function

  function ac_store($id, $name, $str) {
    $ret = true;

    switch ( $this->encoding_mode ) {
      case "slashes":
        $str = addslashes($name . ":" . $str);
      break;

      case "base64":
      default:
        $str = base64_encode($name . ":" . $str);
    };

    $name = addslashes($name);

    ## update duration of visit
    global $HTTP_REFERER, $HTTP_USER_AGENT, $REMOTE_ADDR;

    $now = date("YmdHis", time());
    $uquery = sprintf("update %s set val='%s', changed='%s' where
sid='%s' and name='%s'",
      $this->database_table,
      $str,
      $now,
      $id,
      $name);
    $iquery = sprintf("insert into %s ( sid, name, val, changed ) values
('%s', '%s', '%s', '%s')",
      $this->database_table,
      $id,
      $name,
      $str,
      $now);

    $this->db->query($uquery);

    if ( $this->db->affected_rows() == 0
      && !$this->db->query($iquery)) {
        $ret = false;
    }
    return $ret;
  }

what i have determined is that on AIX 4.3, i am choking at the code:

    if ( $this->db->affected_rows() == 0
      && !$this->db->query($iquery)) {
        $ret = false;
    }

i haven't had a good chance to go throw it yet to understand exactly why
it is happening, but first i wanted to send this to the maillist to see
if anyone else has every encountered strange behaviour in this section.
Anyway, please let me know if you have. Thanks. 

-- 
~darcy w. christ
Elegant Communications Inc.
416.362.9772 x222 | 416.362.8324 fax

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>