WampServer 2 : mysql extension not loaded
Posted by: marc_tera (192.44.63.---)
Date: January 03, 2008 04:49PM

Hello,

Yesterday, I downloaded and installed WampServer 2 on a PC running Windows XP Pro SP 2.
Neiher Wamp nor EasyPhp had ever been installed on that PC.

I ran into several problems.
First I got the classic errors :

> 080102 14:50:40 [ERROR] Default storage engine (InnoDcool smiley is not available
> 080102 14:50:40 [ERROR] Aborting
> 080102 14:50:40 [Note] wampmysqld: Shutdown complete

which I "solved" by commenting the line "default-storage-engine=INNODB" in my.ini as advised by people on this forum...
(However, I think that it is not a clean solution, since wamp5 works fine with that line beeing active...)


Then, I got the following php error when running my php code :

> Fatal error: Call to undefined function mysql_connect() in ...

phpMyAdmin says explicitely that the extension is not loaded.

mysql and mysqli are checked in the settings menu for php.
However, if when tried to uncheck them, I got the following message in an error window:

Window title :
Aestan Tray Menu
Message :
Could not execute menu item (internal error)
[EAccessViloation] Access violation at address 004F1AE0 in module 'wampmanager.exe'. Read of address 00AB9390

So I checked my php.ini by hand, and found the right uncommented "extension=php_mysql.dll" in it.
And php_mysql.dll is present in C:\wamp\bin\php\php5.2.5\ext


Furthermore, the home page displays some errors :

> Notice: Undefined variable: aliasContents in C:\wamp\www\index.php on line 178
> Notice: Undefined variable: projectContents in C:\wamp\www\index.php on line 193
> Notice: Undefined variable: phpExtContents in C:\wamp\www\index.php on line 204

Those errors may be unrelated but could also be a hint for someone about what's happening.

Any Idea ?
Thank you in advance for any help,
Marc



Edited 1 time(s). Last edit at 01/03/2008 06:22PM by marc_tera.

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: student101 (---.saix.net)
Date: January 04, 2008 08:22AM

Find the php.ini file in all possible places like windows, apache and wamp directory.
Then remove the semi-colon from the line that has this
";extension=php_mysql.dll"
now it should read like this without the apostrophe stuff.
"extension=php_mysql.dll"


Cheers

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: marc_tera (192.44.63.---)
Date: January 04, 2008 10:18AM

Thanks student101,

However as I wrote in my original post, "I [already] checked my php.ini by hand, and found the right uncommented extension=php_mysql.dll in it."
This means that I did allready do what you suggest to do !
(I did not mention that I checked "extension=php_mysqli.dll", but I did, there is no semicolon at the beginning of the line, and the file does exist at the right place).

Anyway, semicolon or not, this does not explains the crash of the "Aestan Tray Menu". Nor does it explan the php errors in index.php.

Is the author of this software reading this forum ?

Marc



Edited 1 time(s). Last edit at 01/04/2008 10:19AM by marc_tera.

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: student101 (---.saix.net)
Date: January 04, 2008 10:29AM

I don't want to jump to ideas or conclusions but try to copy and paste the .dll files that you need to the "windows/system32/" directory.

That may help,
if all else fails then backup, remove and reload the wamp stuff from scratch?

Also make sure that there aren't any other versions of PHP, MySQL and so on installed.
I am also having sh1t with this wamp stuff - can't get my captcha to work anymore.



Edited 1 time(s). Last edit at 01/04/2008 10:32AM by student101.

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: marc_tera (---.credit-agricole.fr)
Date: January 04, 2008 05:11PM

Hi,

As I wrote in my first post, I installed WampServer "from scratch" : Neither Wamp nor EasyPhp, IIS, mysql or any web server had ever been installed on that PC before.

I am not ready to loose any more time doing something I already did...

By the way : Could someone tell if she could install WampServer from scratch without having any problem ?
If so, what was the configuration ?

Thank you again for any help,
Marc



Edited 1 time(s). Last edit at 01/04/2008 05:12PM by marc_tera.

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: student101 (---.saix.net)
Date: January 04, 2008 06:03PM

Simple...
Make a folder on your C drive call it "wamp_data"
copy and paste the two folders "www" and "mysql/data"

Now uninstall the wamp, mysql, php and any other stuff like that.
Now install wamp and that's it.

Nothing gets lost in this process except your time.

Cheers

Anything else just post it here.

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: yfastud (Moderator)
Date: January 04, 2008 06:32PM

I don't want to be rude or interrupt, but copy mysql folder only work for one type of db, not all of them, so if have more than 1 type of db, make sure to have proper db backup and restore or will lose db forever

Have fun,

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

Options: ReplyQuote
Re: WampServer 2 : mysql extension not loaded
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: January 04, 2008 10:51PM

hi. this seems like a common problem. i think the problem is your firewall is blocking mysql-nt. this is why in the logs it shows as a normal shudown. mysql-nt and wampmysqld need to be allowed to run.

i dunno why this is the case as onse its running the only service is wampmysqld for mysql. but iv installed it 4 times now and windows definitaly asks should it block or let run "mysql-nt"

is this a problem with bundling mysql into wampserver2?

iv never had this problem with any other install - wether its wamp or standalone apache and mysql +php.



Edited 1 time(s). Last edit at 01/04/2008 11:07PM by stevenmartin99.

Options: ReplyQuote


Sorry, only registered users may post in this forum.