WampServer

I installed wampserver 2.0 (on Windows XP) a few months back, and everything worked fine. However, since yesterday, I keep on getting error messages.
This is what I get:

1) Often, when I request a page, I get a server timeout.
2) Apache crashes every time, with a message to send a Microsoft Bug Report.
3) Very (very!) occasionally, a page will work. However, since PHPMyAdmin won't work, I can't make a backup of my DB.

These are the Apache errors from the log:

[Mon Jun 15 14:26:03 2009] [notice] Server built: Dec 10 2008 00:10:06
[Mon Jun 15 14:26:03 2009] [notice] Parent: Created child process 5944
[Mon Jun 15 14:26:03 2009] [notice] Child 5944: Child process is running
[Mon Jun 15 14:26:03 2009] [notice] Child 5944: Acquired the start mutex.
[Mon Jun 15 14:26:03 2009] [notice] Child 5944: Starting 64 worker threads.
[Mon Jun 15 14:26:03 2009] [notice] Child 5944: Starting thread to listen on port 80.
[Mon Jun 15 15:16:48 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Jun 15 15:16:48 2009] [notice] Apache/2.2.11 (Win32) PHP/5.2.8 configured -- resuming normal operations
[Mon Jun 15 15:16:48 2009] [notice] Server built: Dec 10 2008 00:10:06
[Mon Jun 15 15:16:48 2009] [notice] Parent: Created child process 2004
[Mon Jun 15 15:16:49 2009] [notice] Child 2004: Child process is running
[Mon Jun 15 15:16:49 2009] [notice] Child 2004: Acquired the start mutex.
[Mon Jun 15 15:16:49 2009] [notice] Child 2004: Starting 64 worker threads.
[Mon Jun 15 15:16:49 2009] [notice] Child 2004: Starting thread to listen on port 80.

When I "listen" to port 80, I get yet another Microfost Bug Report ("In Apache server an error occurred and must be shut down"... etc)
The command prompt says: "Your port 80 is actually used by...
Information ot available (might be Skype)."

However, Skype has been configured a long time ago, and worked perfectly. Same with IIS (which I also have running). A conflict with port 80 has been resolved a long time ago and both IIS and WAMP worked perfectly next to each other.

This is what I use:

Apache/2.2.11 (Win32) PHP/5.2.8
MySQL client version: 5.0.51a
PHP extension: mysqli

This is what I get from my PHP error log (this is just a snippet):

[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0
[15-Jun-2009 14:19:23] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[15-Jun-2009 14:19:23] PHP Stack trace:
[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0
[15-Jun-2009 14:19:23] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[15-Jun-2009 14:19:23] PHP Stack trace:
[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0
[15-Jun-2009 14:19:23] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[15-Jun-2009 14:19:23] PHP Stack trace:
[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0
[15-Jun-2009 14:19:23] PHP Notice: Undefined variable: list in C:\wamp\scripts\wampserver.lib.php on line 33
[15-Jun-2009 14:19:23] PHP Stack trace:
[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0
[15-Jun-2009 14:19:23] PHP 2. listDir() C:\wamp\scripts\refresh.php:490
[15-Jun-2009 14:19:23] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\scripts\refresh.php on line 497
[15-Jun-2009 14:19:23] PHP Stack trace:
[15-Jun-2009 14:19:23] PHP 1. {main}() C:\wamp\scripts\refresh.php:0

And here just a snippet from my MySQL error log:

090615 14:19:27 InnoDB: Started; log sequence number 0 46449
090615 14:19:27 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090615 14:19:27 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
090615 14:19:27 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090615 14:19:27 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)

Turning off Skype, my Firewall and IIS had no effect, the problem persisted...

Does anybody have a clue?

I keep mentioning about this all the time that IIS and Apache are both web server, so even if you've already configured each runs on different port, eventually they would conflict in some ways, so you should eliminate 1 and install add-ons for the other; for example, if using IIS, install php and mysql add-on, or vice versus, if using wamp, you can install asp.net and sql add-on
before doing so, check your host file in folder C:\WINDOWS\system32\drivers\etc and make sure it has only this line
127.0.0.1 localhost

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Thank you for your quick reply. I uninstalled IIS, and checked the host file: it is as you specified (it was actually missing, but I generated a new one).

The first time I listened to port 80, it worked fine. But the second time, I get the same error message again and Apache crashes.

Is there any way to solve the problem, other than re-installing WAMP Server 2.0?

I do wonder: how can it be that IIS and WAMP run fine for months, and then suddenly, without any particular reason, Apacha crashes?

Thanks,
Emiel

this happens to a lot of people since most people tend to set windows and firewalls/antivirus to auto update and 1 day they're in the nightmare since they have no clue what happen because new update might new rules which would prevent wamp works properly, and that's why I always set update manually and ONLY update what I really need

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Well, I uninstalled IIS, made a back-up and re-installed Wampserver. So far, everything seems to work again.
I think I'll start using VMWare server to run IIS on a virtual machine. Hopefully that will eliminate future problems.