Re: Do I have to recompile PHP after....

You have sid and name as primary keys, it seems, and there's already sid and name fields with that key pair value (the one shown inside the '()'). Check the database. -- André Fadel fadel@fee.unicamp.br Hoje E Sempre GUARANI! On Tue, 8 Aug 2000, Koo wrote: > Hehe.. just recompiled the WHOLE thing (it didn't really take me much > time to do that coz I got every single procedure written down already. > just cut and paste the commands...) and now Apache is compiled with > MySQL 3.23.22-beta client API. > > The PHPLib problem still exists, so I think it's not the problem of > PHP+APACHE... It should be the inconsistence between old and new > MySQL or the PHPLib code itself... I'll download newest version of > PHPLib (phplib-7.2c) and see if it helps anything. > > Thanks all for reading this thread. Sorry for posting this problem > here in this php list as I found PHPLib list is kind of dead these > days... > > Thanks again. :-) > Koo > > Koo wrote: > > > > Thanks for reading me again! Thanks for guys who have confirmed me > > that I don't need to recompile my Apache+everything... > > > > While I'm happy and ready to go on with my job... a serious problem > > occurs... > > > > PROBLEM: > > =========error============= > > 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-06af2aa25b4b7aef22e20fe0b8 > > 844461' for key 1) > > Session halted. > > =========================== > > > > The above error message appears at the bottom of some pages after I > > have upgraded MySQL from mysql-3.22.32 to mysql-3.23.22-beta. It > > *never* happened before the MySQL upgrade. *sigh* > > > > The message disappeared after I reloaded those pages. > > > > Every page in my web site is PHPLIBed. > > > > 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 > > > > From the PHP4+MySQL+Apache point of view, what are the possible causes > > for the problem?? > > > > I'm about to reboot my server soon and see if it helps... > > > > Help, > > Koo > > > > MySQL+(PHP4+MODSSL+OPENSSL+APACHE...) All latest versions. > > RH Linux 6.2 Kernel 2.2.16-3 > > > > Rasmus Lerdorf wrote: > > > > > > > I have PHP4+MODSSL+OPENSSL+MYSQL... compiled with APACHE. Now I have > > > > upgraded my MySQL from 3.22.32 to 3.23.22-beta. Having tested the > > > > new features of MySQL in PHP scripts. Worked fine. > > > > > > > > Question: Do I have to recompiled PHP4+MODSSL+OPENSSL..+APACHE?? > > > > > > No, you shouldn't need to, especially since it looks like your mysql > > > client library is a shared library. At most you would have to restart > > > your web server. > > > > > > -Rasmus > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >