No More Crashes!

From: Date: Mon, 22 Jan 2001 17:47:18 +0000
Subject: No More Crashes!
Groups: php.windows 
Request: Send a blank email to php-windows+get-5142@lists.php.net to get a copy of this message
First, I want to thank all for helping me with lots of suggestions for questions I posted ("Disabling ODBC", "Tracing crashes", "ODBC vs. Straight MySQL", ...)in the last couple of months. Even if my problem was not fully solved it was more due to my having an old platform nobody else used, than lack of insight or experience on those who helped me: their insight finally pointed on the right direction. I would like to post, if it were of any use to somebody else, the partial solution (still not 100%, but now it is a reproduceable bug) to the problem I experienced (PHP crashing erratically, after serving a perfect, complete script): 1. PHP (3 and 4) crashes erratically when using ODBC connections with Access 95. The ODBC32.DLL from 1995 that comes with it is buggy, so it sometimes crashes without "declaring itself" as the offender. Not even the ODBC log reports any error. 2. Upon installing and de-installing Access 97, the dll's were updated to new ones dated 1996, which solved the crashing problem 100%. Access 95 still works perfect (well, as far as it goes ;) ) with these new dll's. 3. Better yet, I didn't know of the existence of "Microsoft's Data Access pak". I got it form an Abriasoft Lite (pretty good Win installer that sets apache, php and mysql), as a standalone application that updates ODBC management, with dll's dated 1998. These work better yet and no need to mess up the registry by installing and de-installing Access 97. Result: zero crashes!!! Passing from an average 10 crashes a day, this truly fills me with joy. Still three bugs, one of them already reported here, I have to check if they have been posted on the site: 1. With PHP running as an apache module, launching applications from context menus freezes explorer, messing up the display by having to kill the application and having Win run it again (thus, losing all tray icons). 2. With PHP as module, several second delay (freezing windows) when launching applications using Windows' hot-keys. (Related to n. 1 ?) 3. Again, when running as module, there's a conflict with some applications (my best example is Eudora lite 3.0.6): it freezes upon launching, unfreezes when I stop apache, and works ok from then on when I re-start apache. None of this happens with php as CGI. Thanks again to everybody for the help. This is a great list! Gonzalo. INFO: Win95b, Apache 1.3.14, PHP 4.0.4pl1, Access 95 updated with Data Access Pak.

« previous php.windows (#5142) next »