WampServer

after install I got this error when going to a local joomla site:
Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.

and when going to PHP myAdmin:
can't load mysqli-extension. check PHP configuration.
(I translated this from dutch so don't take it literally)

so far I did:
- google for hours
- checked configscreen > system > path was set properly (it was)
- checked if the actual dll is on the system (it is)
- phpinfo() shows, so php is loaded fine
- in php.ini the extension mysqli.dll is called for
- mysql.log does not show any errors (as far as I can see)

I'm so totally stuck, please help.

windows XP

I installed:
WampServer 2.0c [05/05/2008]
- Apache 2.2.8
- MySQL 5.0.51b
- PHP 5.2.6

mysql.log:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080821 19:27:29 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080821 19:27:30 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080821 19:27:30 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 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
080821 19:27:31 InnoDB: Started; log sequence number 0 0
080821 19:27:34 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080821 19:32:03 [Note] wampmysqld: Normal shutdown

080821 19:32:03 InnoDB: Starting shutdown...
080821 19:32:05 InnoDB: Shutdown completed; log sequence number 0 43655
080821 19:32:05 [Note] wampmysqld: Shutdown complete

080821 19:32:06 InnoDB: Started; log sequence number 0 43655
080821 19:32:07 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080821 19:38:37 [Note] wampmysqld: Normal shutdown

080821 19:38:37 InnoDB: Starting shutdown...
080821 19:38:38 InnoDB: Shutdown completed; log sequence number 0 43655
080821 19:38:38 [Note] wampmysqld: Shutdown complete

080822 8:39:21 InnoDB: Started; log sequence number 0 43655
080822 8:39:28 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080822 9:22:44 [Note] wampmysqld: Normal shutdown

080822 9:22:44 InnoDB: Starting shutdown...
080822 9:22:45 InnoDB: Shutdown completed; log sequence number 0 43655
080822 9:22:45 [Note] wampmysqld: Shutdown complete

080822 9:22:47 InnoDB: Started; log sequence number 0 43655
080822 9:22:47 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080822 9:46:05 [Note] wampmysqld: Normal shutdown

080822 9:46:05 InnoDB: Starting shutdown...
080822 9:46:07 InnoDB: Shutdown completed; log sequence number 0 43655
080822 9:46:07 [Note] wampmysqld: Shutdown complete

080822 9:49:08 InnoDB: Started; log sequence number 0 43655
080822 9:49:12 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

Try this

Left click on wamp tray icon, then MySQL, then my.ini

Find:
default-storage-engine=InnoDB

Change to:
default-storage-engine=MyISAM

Have fun,

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

tried that, restarted server, nothing.

does php_mysqli have a check in front when you go to wamp system tray, php, php extensions?

Have fun,

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

yes, and also php_mysqli.

phpinfo() works fine.
here is a screenshot of phpinfo's settings for mysql and mysqli:
[www.engelweb.nl]
does that look normal?

I installed the old version only to find it has the same problems. I uninstalled the old version using the un-installer and renamed the c:/wamp directory. then I installed wamp2 again. I checked config >stystem > (tab) advanced > systemvariables >path, and neither wamp of php is in there. Is that right?

SOlved! but not realy.

I had a flirt with Xampp. Ouch, that interface, got it partly working thou.

Then I did a windows system restore to a restore point last week (when all was still working). Of course wamp was not working. I uninstalled whatever was left of it and reinstalled wamp2 and it worked!

now I got another problem with the databases missing loads of tables, which I will make a new tread of.

Thank you all for helping.