[phplib] After Upgrading MySQL.. error appeared. From: Koo (koo <email protected>)
Date: 08/07/00

Thanks for reading me! Hope you can offer me some help...

PROBLEM:

Database error: Invalid SQL: insert into active_sessions ( sid, name,
val, changed ) values ('06af2aa25b4b7aef22e20fe0b8844461', 'sessid',
'c2Vzc2lkOiR..long long crypted characters..jt9Jzsg', '20000808000004')
MySQL Error: 1062 (Duplicate entry
'sessid-06af2aa25b4b7aef22e20fe0b8844461' for key 1)
Session halted.

The above error message appears at the bottom of some pages after I
have upgraded MySQL from original mysql-3.22.32 to mysql-3.23.22-beta

   ./configure --prefix=/usr/local --localstatedir=/var/mysql/data \
   --with-berkeley-db \
   --with-berkeley-db-includes=/usr/local/BerkeleyDB.3.1/include \
   --with-berkeley-db-libs=/usr/local/BerkeleyDB.3.1/lib
   make
   make install
   cp support-files/mysql.server /etc/rc.d/init.d/

For installation of previous mysql-3.22.32, I tried
   ./configure --prefix=/usr/local --localstatedir=/var/mysql/data
   make
   make install
   cp support-files/mysql.server /etc/rc.d/init.d/

The message disappeared after I reload those pages.

WHAT I'VE TRIED:
- compiled and installed new MySQL
- restarted mysql server
- restarted apache server
- tested new features of MySQL with a PHP script. worked fine.
- emptied all data in the table "active_sessions"
- close and open my browser (Netscape)

WHAT I'VE NOT TRIED:
- recompiled Apache+PHP+...etc

What causes the problem?? Do I really have to recompile
Apache+PHP+MODSSL... again from scratch to solve the problem??

Thanks you very much!
Koo

MySQL+(PHP4+MODSSL+OPENSSL+APACHE) All latest versions.
RH Linux 6.2 Kernel 2.2.16-3

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