Solved

phpMyAdmin Errors/Warnings

Posted on 2010-08-30
10
1,095 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
 

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now