phpmyadmin not working, not loading mysql extension
Posted by: FaithFreaks (---.dsl.wotnoh.ameritech.net)
Date: March 29, 2007 04:09AM

I just downloaded WAMP 1.7.0. I can view php files on the server, and I can edit databases using the MySQL console, but when I try to open php files that access a MySQL database, they do not work. I tried to look at phpmyadmin, and I got the following error:

"Cannot load mysql extension. Please check your PHP configuration."

If I try to open SQLite manager, I get the following error:

"The SQLite extension can't be loaded."

I looked at the php.ini file, and the extension file is not commented out., so I don't understand why it can't be loaded. I am using Windows XP Home Edition.

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: CyberSpatium (71.237.217.---)
Date: March 29, 2007 06:08AM

make sure there is a triangle next to php_mysql and php_sqlite located here:

left click wamp tray icon -> php settings -> php extensions -> php_mysql
left click wamp tray icon -> php settings -> php extensions -> php_sqlite

if there is no triangle next to one or both of them, then click on them to enable them. wamp will automatically restart apache for the new setting to take effect.


CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Please visit my latest website Clarify Loans:
ClarifyLoans.com

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: FaithFreaks (---.dsl.wotnoh.ameritech.net)
Date: March 29, 2007 02:12PM

Thanks for the quick reply. There is a triangle next to both php_mysql and php_sqlite extensions, but still they are not loaded when I try to access phpmyadmin. Anything else that could be wrong???

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: fumanchu (12.154.112.---)
Date: March 29, 2007 05:06PM

I had this same problem myself.

Windows needs to check the php folder by way of the system PATH.

Check your System Environment Variables to ensure the php directory is included in your PATH.

Right Click on "My Computer" - Properties - Advanced - Environment Variables - Double click on Path in the "System Variables" window - add C:\wamp\php\ (Or wherever your php directory is listed)

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: FaithFreaks (---.dsl.wotnoh.ameritech.net)
Date: March 29, 2007 07:19PM

Thanks! I did that and in the process I discovered that I had another copy of php on the computer, so I deleted it. The two things together solved my problem! Thanks so much!

Now can anyone tell me why on my page my php tags within html tags do not work right? I have html tags such as:

<a class='bold_black' href="view_profile.php?member_id=<?=$new_set["member_id"]?>" id="coolNewPersonURLa1">
<?=$image?>
<br>
<a href="view_profile.php?member_id=<?=$new_set["member_id"]?>">
<?=$name?>

Instead of looking up those variables it just prints out the text ...

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: yfastud (72.236.169.---)
Date: March 29, 2007 07:31PM

By default, short_open_tag in php.ini is off. Restart your server after any change.

Have fun,

[www.jlbn.com] (testing WAMPS on Vista)
[test.jlbn.com] (testing codes on Vista)

Win Vista Business
Apache 2.2.4
MySQL 5.2.3 F-A
PHP 5.2.1
SSL 0.9.8D

phpMyAdmin 2.10.0.2

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: CyberSpatium (71.237.217.---)
Date: March 30, 2007 01:25PM

FaithFreaks, you need to use full php tags (<?php), not short ones (<?).

need more help, read about short php tag issues in my wamp manual (link is in my sig).


CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Please visit my latest website Clarify Loans:
ClarifyLoans.com

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: FaithFreaks (---.dsl.wotnoh.ameritech.net)
Date: March 30, 2007 01:58PM

Thanks so much! Now I got it! Works great!

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: arydenbck (---.hsd1.ga.comcast.net)
Date: April 02, 2007 12:32PM

Author: FaithFreaks (---.dsl.wotnoh.ameritech.net)
Date: 03-29-07 04:09

I just downloaded WAMP 1.7.0. I can view php files on the server, and I can edit databases using the MySQL console, but when I try to open php files that access a MySQL database, they do not work. I tried to look at phpmyadmin, and I got the following error:

"Cannot load mysql extension. Please check your PHP configuration."

If I try to open SQLite manager, I get the following error:

"The SQLite extension can't be loaded."

I looked at the php.ini file, and the extension file is not commented out., so I don't understand why it can't be loaded. I am using Windows XP Home Edition.


i get the very same errors, i have tried every fix i could find, edited all config files manually and tried these fixes listed here, still getting the exact same errors even though wamp is saying that MySql is running. i tried installig Joomla and it is reporting that MySql is absent. help please.

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: CyberSpatium (71.237.217.---)
Date: April 02, 2007 03:37PM

any time you edit your httpd.conf or php.ini file you will need to restart apache for the new settings to take effect.




CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Please visit my latest website Clarify Loans:
ClarifyLoans.com

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: LTetzner (71.239.102.---)
Date: April 04, 2007 06:12AM

I'VE INSTALLED WAMP Server 5 AND i'M SEEING similar problems (i.e. THE FOLLOWING 2 issues)...
#1) "Cannot load mysql extension. Please check your PHP configuration. - Documentation" AND
#2) "The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results."

- I've checked the c:\Program FIles\PHP\php.ini file (path shown by phpinfo() and the mysql extension is NOT commented out.
- Verifid that both php_mysql & php_sqlite have "triangles next to them"
- Verified that php.ini file is in the system path environment variable ...
- Have stopped and restarted "All Services"

NOT SURE WHAT ELSE TO TRY.
I see the following in the apache.log file..
"PHP Warning: PHP Startup: mysql: Unable to initialize module\nModule compiled with module API=20050922, debug=0, thread-safety=1\nPHP compiled with module API=20060613, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0"

(Im running Windows XP Home Edition on a Compaq Presario laptop, long term goal is to run Gallery program on server)

Apache/2.2.4 (Win32), PHP Ver 5.2.1, MySQL Ver 5.0.27, PHPmyadmin 2.9.2,SQLitemanager 1.2.0

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: CyberSpatium (71.237.217.---)
Date: April 04, 2007 01:39PM

do you have multiple copys of php installed. you need to just have wamp php installed.

CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Please visit my latest website Clarify Loans:
ClarifyLoans.com

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: LTetzner (71.239.102.---)
Date: April 05, 2007 06:34AM

What method do I use to determine if there are multiple copies installed. If that is the case, how then do I resolve that problem?

Is this in response to issue # 1 "Cannot load mysql extension" or to #2 "mbstring PHP extension was not found" ?

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: CyberSpatium (71.237.217.---)
Date: April 05, 2007 11:00AM

well, if you have two copies of php installed you might be trying to change the php.ini file for a different php install on your system.

if you have wamp installed you dont need to edit the php.ini file to enable extensions. use wamp tray icon menu to do that

for mysql:
wamp tray icon menu -> php settings -> php extensions -> php_mysql

for mbscring:
wamp tray icon menu -> php settings -> php extensions -> php_mbscring

make sure there is a triangle next to both php_mysql and php_mbstring. if not click on it to enable it.



CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Please visit my latest website Clarify Loans:
ClarifyLoans.com

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: marko2m (87.116.128.---)
Date: April 19, 2007 12:18AM

Hello everybody,

Imagine that I have THE SAME PROBLEM, and I tried to do everything you suggested up there.
BUT unfortunatley, although I did the same you wrote, it's still not working?

I am desperate! sad smiley

Please help me



Marko Ivanovic

Options: ReplyQuote
Re: phpmyadmin not working, not loading mysql extension
Posted by: wspeeckaert (---.154-203-24.mc.videotron.ca)
Date: April 19, 2007 04:12PM

I have the identical problem and have tried all the above suggestions.

I'm using XPRO on the server.

MySQL works OK and I can access it and the databases from other machines,
Apache works fine and serves web pages correctly,
PHP works fine.

the WampInfo page shows entries for Apache, PHP but shows no entry for MySQL

PhpMyAdmin does not work and I get the same error as everyone else here.

I have no other versions of PHP or MySQL installed. I updated the path in the variables page and installed wamp in the default directory.

Options: ReplyQuote


Sorry, only registered users may post in this forum.