Re: [PHPLIB] just starting out From: darcy w. christ (darcy <email protected>)
Date: 04/25/00

so now i'm wondering whether there is something wrong with my table. i
did use the create_db_mysql script that came with phplib, however i
suppose it's possible that there is something wrong with it. Here's
what my table lloks like:

#
# Table structure for table 'active_sessions'
#

CREATE TABLE active_sessions (
   sid varchar(32) NOT NULL,
   name varchar(32) NOT NULL,
   val text,
   changed varchar(14) NOT NULL,
   PRIMARY KEY (name, sid),
   KEY changed (changed)
);

The line below about the duplicate entry looks wierd to me since it
seems to be combining both the sid and name of the active_sessions
together (ie. Example_Session-26b51b02e96459328fb22c705ee1e2a4 is
name-sid). Does this look right?

> >Database error: Invalid SQL: insert into active_sessions ( sid, name,
> >val, changed ) values ('26b51b02e96459328fb22c705ee1e2a4',
> >'Example_Session',
> >'RXhhbXBsZV9TZXNzaW9uOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy0+cHRbJ2F1dGgnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBFeGFtcGxlX0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA9ICdmb3JtJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnMjE0NzQ4MzY0Nyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3VuYW1lJ10gPSAna3Jpcyc7IA==',
> >'20000425121159')
> >MySQL Error: 1062 (Duplicate entry
> >'Example_Session-26b51b02e96459328fb22c705ee1e2a4' for key 1)
> >Session halted. 

-- 
~darcy w. christ
Elegant Communications Inc.
416.362.9772 x222 | 416.362.8324 fax
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.