dreeves Posted October 9, 2009 Report Share Posted October 9, 2009 I've seen this problem all over the Internet, but since I'm using Uniform Server, I was hoping to get a solution that was catered to US. Here are the details: Apache/2.2.13 (Win32) mod_ssl/2.2.13 OpenSSL/0.9.8k PHP/5.3.0 DAV/2 I am entering information into a form, which then gets put on to a mysql database. When I submit the form, the page displays "The connection to the server was reset while the page was loading." The data gets entered in the database successfully, however. The error log displays: - [Fri Oct 09 16:42:05 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.- [Fri Oct 09 16:42:06 2009] [notice] Apache/2.2.13 (Win32) mod_ssl/2.2.13 OpenSSL/0.9.8k PHP/5.3.0 DAV/2 configured -- resuming normal operations- [Fri Oct 09 16:42:06 2009] [notice] Server built: Aug 6 2009 15:50:50- [Fri Oct 09 16:42:06 2009] [notice] Parent: Created child process 3456- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Child process is running- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Acquired the start mutex.- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting 250 worker threads.- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting thread to listen on port 443.- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting thread to listen on port 80. One solution I've tried was to copy the libmysql.dll file from the PHP installation folder to the system32 folder. That did not work. Since I downloaded this just a few days ago, I didn't think that there were any updates required. Let me know if you would like me to include the php code, in case that will help. Quote Link to comment Share on other sites More sharing options...
Ric Posted October 9, 2009 Report Share Posted October 9, 2009 Can you please try 5.3-Nano? This includes all the latest components. All the bestRic Quote Link to comment Share on other sites More sharing options...
dreeves Posted October 12, 2009 Author Report Share Posted October 12, 2009 Can you please try 5.3-Nano? This includes all the latest components. All the bestRic Thanks! Just a quick question though about updating to the new version, Do I need to uninstall the old version?I have 5.1 directly on C:// and when installing 5.3 it wants to replace some files. What is the best way to update to 5.3 without losing any work I've done in 5.1? Apache/php/mysql is new to me, so I'm not 100% on how it all works together. Any guidance would be appreciated. Quote Link to comment Share on other sites More sharing options...
Ric Posted October 12, 2009 Report Share Posted October 12, 2009 I never recommend installing over an older version. You currently have C:\\UniServer rename the folder to give C:\\UniServer1 (It can have any name must not include spaces.) Now extract 5.3 to your C drive again this will give C:\\UniServer rename this to C:\\UniServer2 Assuming you have not changed any configuration files, the quickest way to up date without losing any work: The following updates your server root folder:Delete folder C:\\UniServer2\wwwCopy folder C:\\UniServer1\www to C:\\UniServer2 If you have created databases copy these to the new server:Go to folder: UniServer\usr1\local\mysql\dataCopy all new folders (not mysql or phpmyadmin)To folder: UniServer\usr2\local\mysql\data Run UniServer2 and check your website works.You can delete folder UniServer1 generally it’s a good idea to keep this as a backup. All the bestRic Quote Link to comment Share on other sites More sharing options...
dreeves Posted October 13, 2009 Author Report Share Posted October 13, 2009 Thanks. That worked. Now I'm dealing with html/form/php code issues. It never seems to end. Quote Link to comment Share on other sites More sharing options...
Ric Posted October 13, 2009 Report Share Posted October 13, 2009 Ace, thanks for the feedback. Uniform Server 5.3 is looking like a stable core. Any one of an infinite number of permutations can kill. I do understand “html/form/php code issues” depends on your outlook either a pain or an exciting chase to resolve. All the bestRic Quote Link to comment Share on other sites More sharing options...
dreeves Posted October 14, 2009 Author Report Share Posted October 14, 2009 When I submit form.html, it sends the info to insert.php and successfully enters the info into a mysql database. However, I get "Problem loading Page: The connection to the server was reset while the page was loading." I have to restart the servers inorder for apanel/phpMyAdmin to work again. From the error log, I think the problem occurs when attempting to close the connection to the mysql database. Here is the error: - [Wed Oct 14 09:39:38 2009- ] [notice] EACCELERATOR(3332): PHP crashed on opline 99 of mysql_close() at C:\UniServer\www\insert.php:33- [Wed Oct 14 09:39:38 2009] [crit] Parent: child process exited with status 3 -- Aborting.- [Wed Oct 14 09:39:59 2009] [notice] Apache/2.2.14 (Win32) mod_ssl/2.2.14 OpenSSL/0.9.8k PHP/5.3.0 DAV/2 configured -- resuming normal operations- [Wed Oct 14 09:39:59 2009] [notice] Server built: Sep 28 2009 22:41:08- [Wed Oct 14 09:39:59 2009] [notice] Parent: Created child process 3024- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Child process is running- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Acquired the start mutex.- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting 250 worker threads.- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting thread to listen on port 443.- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting thread to listen on port 80. I've numbered the lines of code for you and eliminated some things for convenience. Does the "33" mean that the problem is on line 33 of insert.php? Is it something to do with EACCELERATOR? (29) $query="INSERT INTO reimbursements (column_name1, column_name2) VALUES (value1, value2)";(30) mysql_query($query) or die("reimbursements insert failed - " . mysql_errno() . ": " .(31) mysql_error()); (33)mysql_close(); I'm happy that data finally gets entered, but Apache shouldn't crash every time I submit this form. Thanks for being so helpful. Quote Link to comment Share on other sites More sharing options...
Ric Posted October 14, 2009 Report Share Posted October 14, 2009 A quick test to confirm its eAccelerator; before running script disable eAccelerator In Apanel under Plugin Manager click link eAccelerator cPanelThis opens a new page, under actions click disable.Run your script All the bestRic Quote Link to comment Share on other sites More sharing options...
r-a-y Posted October 15, 2009 Report Share Posted October 15, 2009 I'm getting identical errors as dreeves; I've upgraded to v5.3 and have disabled eAccelerator like Ric stated above. I'm getting this in the error logs: [Wed Oct 14 20:26:01 2009 ] [notice] EACCELERATOR(2732): PHP crashed on opline 33 of mysql_close() at C:\UniServer\www\wp-content\plugins\bp-chat\chat\lib\class\CustomAJAXChat.php:170 [Wed Oct 14 20:26:01 2009] [crit] Parent: child process exited with status 3 -- Aborting. It's also failing on mysql_close() like dreeves. Any other ideas? Quote Link to comment Share on other sites More sharing options...
Ric Posted October 15, 2009 Report Share Posted October 15, 2009 This is not an issue with eAccelerator it’s a bug in PHP 5.3.0 Check this bug report:http://bugs.php.net/bug.php?id=48754 Confirmed this crashes:<?phpprint "fred";mysql_connect('127.0.0.1', 'root', 'root');mysql_close();?> You require an handle to close:<?phpprint "fred";$a=mysql_connect('127.0.0.1', 'root', 'root');mysql_close($a);?> “Fix should be part of 5.3.1” All the bestRic Quote Link to comment Share on other sites More sharing options...
r-a-y Posted October 15, 2009 Report Share Posted October 15, 2009 Thanks Ric! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.