Re: phpMyAdmin does not work
Posted by:
zhang24246
(---.hsd1.ca.comcast.net)
Date: January 25, 2009 12:35AM
same problem here. wamp2.0f + windows xp sp3
neither phpmyadmin nor sqlitemanager works,
phpmyadmin says "Cannot load mysqli extension"
sqlitemanager says "The SQLite extension can't be loaded."
bunch of error msg in php_error.log as below:
[24-Jan-2009 13:08:00] PHP Notice: Undefined variable: mywampfp in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 13:08:00] PHP Notice: Undefined variable: i in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 13:08:00] PHP Notice: Undefined variable: mywampini in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 13:08:00] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[24-Jan-2009 13:08:00] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[24-Jan-2009 13:08:00] PHP Notice: Undefined variable: list in C:\wamp\scripts\wampserver.lib.php on line 33
[24-Jan-2009 13:08:00] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\scripts\refresh.php on line 497
[24-Jan-2009 15:22:48] PHP Notice: Undefined variable: mywampfp in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 15:22:48] PHP Notice: Undefined variable: i in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 15:22:48] PHP Notice: Undefined variable: mywampini in C:\wamp\scripts\refresh.php on line 252
[24-Jan-2009 15:22:48] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[24-Jan-2009 15:22:48] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[24-Jan-2009 15:22:48] PHP Notice: Undefined variable: list in C:\wamp\scripts\wampserver.lib.php on line 33
[24-Jan-2009 15:22:48] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\scripts\refresh.php on line 497
bunch of error msg in
090124 13:07:55 InnoDB: Started; log sequence number 0 0
090124 13:07:55 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090124 13:07:55 [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
090124 13:07:55 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090124 13:07:55 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
090124 14:03:34 [Note] wampmysqld: Normal shutdown
I use admin account to install wamp and install wamp. totally confused now what happened.