Re: [phplib] After Upgrading MySQL.. error appeared.

try doing full stop of mysql and httpd in other words do not do a "restart" then, start /etc/rc.d/init.d/mysql start -h somehost then, start /etc/rc.d/init.d/httpd start -S 1. full shutdown of both 2. THEN start mysql PRIOR to httpd ************** On Mon, 07 Aug 2000, you wrote: > 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@lists.netuse.de > For additional commands, e-mail: phplib-help@lists.netuse.de -- Gerald Howse Edmonton, AB, Canada zend@one.powersurfr.com