[phplib] active_sessions From: William Jackson (wj <email protected>)
Date: 07/24/00

I seem to have fixed the problem that I mentioned below:

-----------------------------------------------------------
I get errors on the active_sessions table

Warning: SQL error: , SQL state ب,tb1D×ÿ¿zE p*ð<2 in SQLExecDirect in
db_odbc.inc on line 67
Database error: Invalid SQL: select val from ACTIVE_SESSIONS where sid =
'e74cf7b0180304c17c212fbbaf1deb49' and name = 'Fid_Session'
ODBC Error: 1 (General Error (The ODBC interface cannot return detailed
error messages).)
Session halted.

-------------------------------------------------------------
what I did was

swap the first line in ct_sql.inc in the ac_get_value function

to be:

$SQL = sprintf("select val from %s where sid = '%s' and name = '%s'",
      $this->database_table,
      $id,
      addslashes($name));
$this->db->query($SQL);

instead of:
$this->db->query(sprintf("select val from %s where sid = '%s' and name =
'%s'",
  $this->database_table,
  $id,
  addslashes($name)));

I found that on other pages the sprintf inside the query() was crashing as
well
and since I have done this the problem hasnt appeared!

any comments?

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