WampServer
Apache, PHP, MySQL
on Windows
Urgent help needed
Posted by:
netmln
(---.l.pppool.de)
Date: March 01, 2009 04:16PM
Hi everyone,
Just installed wamp 2.0 today with very latest version. After that I always got the error message "cannot load MySQL extension, please check PHP Configuration".
Before I post this topic, I have tried many different ways to solve it like. unstall wamp, delete all traces in registry edit.
new download from [download.jlbn.net]. Nothing helps. So I put my erroer logs here. In hope some one can help me out, it's really frustrating not to get it run before you can start with real project:
Apache_erroer:
---------------
Sun Mar 01 15:54:59 2009] [warn] pid file C:/wamp/bin/apache/Apache2.2.10/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sun Mar 01 15:54:59 2009] [notice] Apache/2.2.10 (Win32) PHP/5.2.7 configured -- resuming normal operations
[Sun Mar 01 15:54:59 2009] [notice] Server built: Oct 10 2008 12:39:04
[Sun Mar 01 15:54:59 2009] [notice] Parent: Created child process 504
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Child process is running
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Acquired the start mutex.
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Starting 64 worker threads.
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Starting thread to listen on port 80.
[Sun Mar 01 15:55:10 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 01 15:55:10 2009] [notice] Child 504: Exit event signaled. Child process is ending.
[Sun Mar 01 15:55:11 2009] [notice] Child 504: Released the start mutex
[Sun Mar 01 15:55:12 2009] [notice] Child 504: All worker threads have exited.
[Sun Mar 01 15:55:12 2009] [notice] Child 504: Child process is exiting
[Sun Mar 01 15:55:12 2009] [notice] Parent: Child process exited successfully.
[Sun Mar 01 15:55:13 2009] [notice] Apache/2.2.10 (Win32) PHP/5.2.7 configured -- resuming normal operations
[Sun Mar 01 15:55:13 2009] [notice] Server built: Oct 10 2008 12:39:04
[Sun Mar 01 15:55:13 2009] [notice] Parent: Created child process 736
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Child process is running
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Acquired the start mutex.
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Starting 64 worker threads.
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Starting thread to listen on port 80.
[Sun Mar 01 15:55:30 2009] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Sun Mar 01 15:55:30 2009] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Sun Mar 01 15:55:47 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 01 15:55:47 2009] [notice] Child 736: Exit event signaled. Child process is ending.
[Sun Mar 01 15:55:48 2009] [notice] Child 736: Released the start mutex
[Sun Mar 01 15:55:49 2009] [notice] Child 736: All worker threads have exited.
[Sun Mar 01 15:55:49 2009] [notice] Child 736: Child process is exiting
[Sun Mar 01 15:55:49 2009] [notice] Parent: Child process exited successfully.
MySQL log:
-----------
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090301 15:54:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090301 15:55:00 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090301 15:55:01 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090301 15:55:02 InnoDB: Started; log sequence number 0 0
090301 15:55:02 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090301 15:55:02 [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
090301 15:55:02 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090301 15:55:02 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
090301 15:55:47 [Note] wampmysqld: Normal shutdown
090301 15:55:47 InnoDB: Starting shutdown...
090301 15:55:48 InnoDB: Shutdown completed; log sequence number 0 46409
090301 15:55:48 [Note] wampmysqld: Shutdown complete
090301 15:57:31 InnoDB: Started; log sequence number 0 46409
090301 15:57:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090301 15:57:31 [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
090301 15:57:31 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090301 15:57:31 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
php error:
----------
just empty....
SQLitem Manager:
----------------
The SQLite extension can't be loaded.
Appreciate it for your help! Thx
Edited 4 time(s). Last edit at 03/03/2009 09:31AM by netmln.
Just installed wamp 2.0 today with very latest version. After that I always got the error message "cannot load MySQL extension, please check PHP Configuration".
Before I post this topic, I have tried many different ways to solve it like. unstall wamp, delete all traces in registry edit.
new download from [download.jlbn.net]. Nothing helps. So I put my erroer logs here. In hope some one can help me out, it's really frustrating not to get it run before you can start with real project:
Apache_erroer:
---------------
Sun Mar 01 15:54:59 2009] [warn] pid file C:/wamp/bin/apache/Apache2.2.10/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sun Mar 01 15:54:59 2009] [notice] Apache/2.2.10 (Win32) PHP/5.2.7 configured -- resuming normal operations
[Sun Mar 01 15:54:59 2009] [notice] Server built: Oct 10 2008 12:39:04
[Sun Mar 01 15:54:59 2009] [notice] Parent: Created child process 504
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Child process is running
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Acquired the start mutex.
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Starting 64 worker threads.
[Sun Mar 01 15:54:59 2009] [notice] Child 504: Starting thread to listen on port 80.
[Sun Mar 01 15:55:10 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 01 15:55:10 2009] [notice] Child 504: Exit event signaled. Child process is ending.
[Sun Mar 01 15:55:11 2009] [notice] Child 504: Released the start mutex
[Sun Mar 01 15:55:12 2009] [notice] Child 504: All worker threads have exited.
[Sun Mar 01 15:55:12 2009] [notice] Child 504: Child process is exiting
[Sun Mar 01 15:55:12 2009] [notice] Parent: Child process exited successfully.
[Sun Mar 01 15:55:13 2009] [notice] Apache/2.2.10 (Win32) PHP/5.2.7 configured -- resuming normal operations
[Sun Mar 01 15:55:13 2009] [notice] Server built: Oct 10 2008 12:39:04
[Sun Mar 01 15:55:13 2009] [notice] Parent: Created child process 736
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Child process is running
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Acquired the start mutex.
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Starting 64 worker threads.
[Sun Mar 01 15:55:14 2009] [notice] Child 736: Starting thread to listen on port 80.
[Sun Mar 01 15:55:30 2009] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Sun Mar 01 15:55:30 2009] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Sun Mar 01 15:55:47 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 01 15:55:47 2009] [notice] Child 736: Exit event signaled. Child process is ending.
[Sun Mar 01 15:55:48 2009] [notice] Child 736: Released the start mutex
[Sun Mar 01 15:55:49 2009] [notice] Child 736: All worker threads have exited.
[Sun Mar 01 15:55:49 2009] [notice] Child 736: Child process is exiting
[Sun Mar 01 15:55:49 2009] [notice] Parent: Child process exited successfully.
MySQL log:
-----------
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090301 15:54:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090301 15:55:00 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090301 15:55:01 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090301 15:55:02 InnoDB: Started; log sequence number 0 0
090301 15:55:02 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090301 15:55:02 [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
090301 15:55:02 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090301 15:55:02 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
090301 15:55:47 [Note] wampmysqld: Normal shutdown
090301 15:55:47 InnoDB: Starting shutdown...
090301 15:55:48 InnoDB: Shutdown completed; log sequence number 0 46409
090301 15:55:48 [Note] wampmysqld: Shutdown complete
090301 15:57:31 InnoDB: Started; log sequence number 0 46409
090301 15:57:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090301 15:57:31 [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
090301 15:57:31 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090301 15:57:31 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
php error:
----------
just empty....
SQLitem Manager:
----------------
The SQLite extension can't be loaded.
Appreciate it for your help! Thx
Edited 4 time(s). Last edit at 03/03/2009 09:31AM by netmln.
Sorry, only registered users may post in this forum.
