HI,
I'm running pc with Vista and Apache (xampp) as well as mysql. When I go into the control panel and run queries in my database, I have no problems. However, when my php programs run, they seem to encounter some kind of "clogging." When I first restart the computer, I can get to my main page very easily and it displays correctly. Then I go to a page requiring a login, and that is okay, too. Then I can even update the database through my php pages -- so far so good. Then if I log out and try to go into another part of the site, it hangs and I get a progress bar that doesn't move. Meanwhile, I can go to the database using the xampp control panel and everything appears to be working fine. Eventually, the system gets so clogged, that I can't even open the start page. So, in a word, things work and then slow down and then stop working.
I thought maybe this problem was a result of security software which was recently reinstalled when I had a software crash and all everything had to be reinstalled. I turned off all of the security, but it didn't help. I put the names and ports in the services so that they would be allowed, but that didn't seem to help either.
When the screen goes blank or gets hung up, is there any facility I can turn on in order to figure out where the system is getting hung? Any ideas on this would be greatly appreciated.
Here is some technical info copied from my xampp admin:
Apache/2.2.12 (Win32) DAV/2 mod_ssl/2.2.12 OpenSSL/0.9.8k mod_autoindex_color PHP/5.3.0 mod_perl/2.0.4 Perl/v5.10.0
MySQL client version: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
PHP extension: mysqli.
One other thought -- in my latest programming I was making extensive use of $_SESSION -- could that cause these problems? Thanks.
PS: An update on this last (SESSION) -- I restarted the computer and used only the pages which have not been changed by the recent programming effort. These pages hung up in exactly the same clogging way -- so it is not the SESSION variable. When I went to my website to test the same facility, it works perfectly (sigh of relief!).
All security I can find has been disabled. Any suggestions on this would be very greatly appreciated. Thanks, Ilene
I have more information on this problem now -- it looks to me like a program I didn't have before and am not using in mysql implementation for some reason thinks it has to run. Here is the error log:
091224 4:27:09 [Note] Plugin 'FEDERATED' is disabled.
091224 04:27:10 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
091224 04:27:10 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
091224 4:27:11 InnoDB: Started; log sequence number 0 1898733
091224 04:27:12 [Note] PBXT: Recovering from 1-43, bytes to read: 33554389
091224 04:27:12 [Note] PBXT: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
091224 04:27:13 [Note] PBXT: 26 27 28 29 30 091224 4:27:14 [Note] Event Scheduler: Loaded 0 events
091224 4:27:14 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.37' socket: '' port: 3306 Source distribution
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
091224 04:27:14 [Note] PBXT: 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
091224 04:27:15 [Note] PBXT: 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
091224 04:27:17 [Note] PBXT: Recovering complete at 1-43, bytes read: 33554389
Looks like I need to reinstall the Apache package and remove pxbt. Any confirmation of this would be greatly appreciated.