[phplib] maybe a silly newbie question.... From: lynn (lmurray <email protected>)
Date: 05/11/00

Hi,
I'm using PHPLIB 7.2 with mysql. I've been getting the same error many
people have : invalid sql on insert into active_sessions and duplicate
entry for key 1 and the session dies. This only happens (so far) when I
use my modification of new_user_md5 to insert a new user. Everything
else works without problems including killing and editing users. There
are no other references to page_close that I can find in any includes
(this was offered as a potential solution in an earlier post). Any
suggestions? I' m relatively new to PHP and PHPLIB, but it's been
working.

Database error: Invalid SQL: insert into active_sessions ( sid, name,
val, changed ) values ('8e2c1b60f0130ab2af5800df4976354b', 'TVIdata',
'VFZJZGF0YTokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICR0aGlzLT5wdFsnZGVwdCddID0gJzEnOyAkdGhpcy0+cHRbJ2RpdiddID0gJzEnOyAkR0xPQkFMU1snYXV0aCddID0gbmV3IFRWSV9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnYjI2Y2QxZDU4MTU1MWY1YjZjZmE0M2UxMWQzZjJkYWMnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydwZXJtJ10gPSAnYWRtaW4nOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICc5NTgwNjc4OTEnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnOTU4MDY3ODEyJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndW5hbWUnXSA9ICdseW5uJzsgJEdMT0JBTFNbJ2NoYWxsZW5nZSddID0gJzI3MTUyZDAxMjMxNGIyOGEyNTNjOWY2MzU5OTFiMmQ2JzsgJEdMT0JBTFNbJ2RlcHQnXSA9ICcyMzA0JzsgJEdMT0JBTFNbJ2RpdiddID0gJzEzMDAnOyA=',

'20000511115711')
MySQL Error: 1062 (Duplicate entry
'TVIdata-8e2c1b60f0130ab2af5800df4976354b' for key 1)
Session halted.

Another question, mysql appears to have at least two connections usually
more when I use PHP to access the database. Is this usual? Will it cause
problems when there are more users than just me? This is just in
development for the time being.

Yet another question about new_user_md5 ( a wonderful thing if it
works). I am a newbie so maybe I've missed something from the manual
and from Professional PHP Programming. Is it legal to intersperse ?>
tags with curly brackets like:
 function my_error($msg) {
?>
  <table border=0 bgcolor="#eeeeee" align="center" cellspacing=0
cellpadding=4 width=540>
   <tr>
    <td><font color=#FF2020>Error: <?php print ($msg) ?></font></td>
   </tr>
  </table>
  <BR>
<?php
}

## my_msg($msg):
##
## Display success messages
  function my_msg($msg) {
?>
 <table border=0 bgcolor="#eeeeee" align="center" cellspacing=0
cellpadding=4 width=540>
  <tr>
   <td><font color=#008000>O.K.: <?php print $msg ?></font></td>
  </tr>
 </table>
 <br>
<?php
}

I don't understand why that works. Thanks for your help.

Lynn in Albuquerque, New Mexico

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