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

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