Solved

phpMyAdmin Errors/Warnings

Posted on 2010-08-30
10
1,096 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:russellexadmin
10 Comments
 
LVL 2

Expert Comment

by:ozi_lion
ID: 33561376
#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
0
 
LVL 2

Expert Comment

by:ozi_lion
ID: 33561444
for #1 please look at this site. http://thedesignspace.net/MT2archives/000043.html  it explains how to enable link tables
0
 
LVL 9

Expert Comment

by:shalabhsharma
ID: 33561497
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Expert Comment

by:SYSKING
ID: 33561661
Having IIS 7.5.. you would rather configure PHP & MYSQL in IIS, its quit easy ans works great...
0
 

Author Comment

by:russellexadmin
ID: 33567311
@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.
0
 

Author Comment

by:russellexadmin
ID: 33569349
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.
0
 
LVL 2

Expert Comment

by:ozi_lion
ID: 33569914
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

0
 

Author Comment

by:russellexadmin
ID: 33577267
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.
0
 
LVL 2

Accepted Solution

by:
ozi_lion earned 500 total points
ID: 33578620
here what you need is at attachment.

php-mcrypt.dll
0
 

Author Comment

by:russellexadmin
ID: 33578960
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question