Link to home
Start Free TrialLog in
Avatar of russellexadmin
russellexadmin

asked on

phpMyAdmin Errors/Warnings

Can someone please help with this issue I'm having with phpMyAdmin.  After finally getting phpmyadmin installed correctly, I opened it for the first time and immediately noticed some errors/wornings at the bottom of the page.  The errors/warning are as follows, and a screnshot of these are attached:

1. The additional features for working with linked tables have been deactivated. To find out why click here.

2. Cannot load mcrypt extension. Please check your PHP configuration.

3. Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.49. This may cause unpredictable behavior.

If this helps, the following is my setup:

Windows Server 2008 R2
IIS 7.5

Also, I'm wanting to use phpmyadin to be able to conect to MySQL for use with Moodle.  We are attempting to move Moodle from a Mac Server to a Windows Server 2008 R2 server.

Any help with this would breatly be appreciated.  Thanks in advace!

phpmyadmin-errors.doc
Avatar of ozi_lion
ozi_lion
Flag of Türkiye image

#1 refer to phpmyadmin config file for linked table names. i had them i'll look for them if i can find i will attach here.

#2 mcrypt  extension is one of extras of PHP extensions you can reconfigure your  php.ini to use it but first download it from www.php.net if you don't already have

#3 i couldn't find a solution dor this warning too
for #1 please look at this site. http://thedesignspace.net/MT2archives/000043.html  it explains how to enable link tables
Avatar of SYSKING
SYSKING

Having IIS 7.5.. you would rather configure PHP & MYSQL in IIS, its quit easy ans works great...
Avatar of russellexadmin

ASKER

@SYSKING--So you don't recommend the Web Platform installation of Moodle, PHP, and MySQL.  The installation was a breeze.  I did install a lot of features that Moodle need through IIS 7.5 though.
@ozi lion--I am new to Moodle, so is there any easy to follow instructions for installing the mcrypt extenson.  It would help a lot.
Update:  I was able to get rid of the first error/warning that relates to linked tables.  However, I'm still getting error/warning #2 relating to mcrypt.
I followed the instructions on how to install mcrypt, but I see no difference.  Here's what I did: I downloaded a .zip for mcrypt 2.6.7-win32, extracted the file and ran the application file(after clicking run, nothing happened, but I assumed it ran it).  I also added the line extension=php_mcrypt.dll to the php.ini file, and downloaded and saved libmcrypt.dll to the ext folder under PHP.  Additionally I restarted the server.
Can anyone tell me if I missed something or did somethig wrong?  Thanks in advance.
what version of PHP you have?

for PHP 5>= you have to add line at the end of php.ini file like below. Also you need to use at least the same version of mcrypt as your PHP version, to do this just go to download page at ww.php.net



[PHP_MCRYPT]
extension=php_mcrypt.dll

Open in new window

I have PHP version 5.2.14.  I tried finding the mcrypt version to match PHP and was not successful. The one that I did find was for Linux Red Hat.   And I did add the line at the end of the php.ini file as you suggested.
ASKER CERTIFIED SOLUTION
Avatar of ozi_lion
ozi_lion
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I tried it and I'm still getting the error.  Does it matter that the name doesn't have an underscore like the other .dll files in the ext folder?  Its the only one with a dash.  Just a thoght.