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

OK! Just for the interest and information of people who got the same problem as mine. It's a strange problem with PHPLib code. Answer and fixes found here: http://marc.theaimsgroup.com/?t=96520745000001&w=2&r=1 Bye Koo 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