[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


phpMyAdmin - cannot browse tables (windows version)

Posted on 2006-06-10
Medium Priority
Last Modified: 2013-12-12
I have been pulling my hair out over this one and have decided it is time to ask an expert.

I am trying to set up a 2nd machine identical to my laptop running PHP, MySQL, and phpMyAdmin.  Everything is working fine with the exception of when I try to browse a table in phpMyAdmin, the page display only so far and then stops.  I get all of the left pane, the top row that has server -> local host, database -> mysql, table -> user  and then the next row (the row of tabs) starts with browse showing fine, but the next one (structure) starts displaying as text.  Sometimes it gets a little farther than other times, but never much.  For example, sometimes it will show

[browse] <a class="

and end there.  Other times it will show

[browse] <a class="tab" href="tbl_properties_structure.php?lang=en-iso-8859-1&server=1&collation_connection=utf8_unicode_ci&db=mysql&table=user&goto=tbl_properties.php&back=tbl_propertie

The [browse] above represents the browse tab with icon that displays correctly.

Everytime, though, it ends abruptly.  If I view source on the page it ends just as suddenly there as well.

I know the data is there, as I can go into export tab, export the data from any table, and it shows up just fine.  All other phpMyAdmin pages work just fine as well.  Only the browse page is not displaying.

I have done everything I can think of to get it as close to the laptop version as possible, but still cannot get it to work.

phpMyAdmin 2.7.0-pl2
mySQL 4.0.18
PHP 5.0.4

I started with the most current version of phpMyAdmin (2.8.1) which gave the same error so decided to downgrade to the version which is working on my laptop, but had the same problem.

Thanks for your time.
Question by:CIC Admin
  • 4
  • 3

Author Comment

by:CIC Admin
ID: 16877963
After a bit more testing, I noticed that the SQL tab lets me type in a SELECT statement, but instead of returning the results, it gives the same error as above.  Which is guess is doing basically the same thing the browse tab does.
LVL 29

Expert Comment

ID: 16881529
Since you have a new setup, some points need to checked in that order:
1 - Link PHP/ MySQL: You are using php5. Did you enable the mysql extension? this was standard with php <5, but now needs some additional action. Use PHPINFO to check what is happening
2 - MySQL: check in a dos-box in "command line mode" what is the current content of your base. Maybe phpmyadmin goes amok because of some strange content here, including MySQL not running...
3 - Build a simple sample php program using mysql eg, to display some SELET you have handy or any other simple thing: you just want to check if it is working. If your base is empty, create a simple table with one or 2 fields from the command line interface of previous step. Input data manually before launching your php script
4 - If this work, and phpmyadmin does not: Take a note of which MySQL setup parameters you need for phpmyadmin. Delete the complete directory, reinstall it.

Tell us the results

Author Comment

by:CIC Admin
ID: 16893652
Ok, let's see . . .

1 - I do have the line in my php.ini file enabling the mysql extension.  I have :

    . . .
    . . .

    php_mysql.dll is located in the c:\php\ext directory.

   What should I look for in PHPInfo to help you?

2 - I can use mysql.exe from the command line, log in, and do SELECTs on all the tables.  All the data is there.

3 - Since this is a second installation, I already have a lot of databases and PHP pages created.  I copied the data over and these PHP pages are working just fine.

4 - I have deleted phpMyAdmin completely on a couple different occasions.  Tried starting fresh with a new config.inc.php file too.  Even tried different versions.  All with the same result.

Seems like it must be a phpMyAdmin thing since everything else is working fine, but I don't want to jump to conclusions.

One other thing I don't think I added above was the fact that PHP is running on IIS.  This is the case on my laptop too.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 29

Accepted Solution

fibo earned 2000 total points
ID: 16893934
1 - [when displaying the phpinfo page, look for mysql extensions: are they visible and active?]
Not needed 'cause of your answer 3

2 - Coherent with your answer 3

3 - So mysql is working, php is working, and they succeed in cooperating fine.
phpMyAdmin, since it is a "normal" php script should do too.
If it does not, then that should be related to config.inc.php (but where...)

4 - As far as I remember, you have 2 ways to make php run on IIS, cgi and dll. And I think I remember that one of these has a non-standard way of handling sessions and cookies... There are several ways to run phpMyadmin, you might be using one of the modes that is handled differently...
a - compare the 2 php info from your machines
b - which access mode do you currently use for phmpmyadmin? the 3 possible values (config.inc.php circa lines 80-90) are config, http or "cookie based". Are you using the same on both machnes? which one(s)?

Author Comment

by:CIC Admin
ID: 16894820
I have always used "config" in the past.  Never tried "http" or "cookie" on any install.

Good point about the CGI and DLL on the IIS machine, though.  I will take a deeper look into this when I get home tonight.  In troubleshooting this, I have completely uninstalled and reinstalled both phpMyAdmin and mySQL.  Maybe it is time to try doing that to PHP.

I will also go over my PHPINFO screen line by line and report any differences.

Thanks for your continued help!

Another note : Since I needed access to those tables and could not get phpMyAdmin to work, I started searching for alternatives to phpMyAdmin.  I downloaded a copy of NaviCat.  It is an application you install and is basically the MS SQL Enterprise Manager equivalent for mySQL.  It is a 30 free trial, and worked like a charm.  And by the way, it displayed all the tables without a problem.  I still very much want to get phpMyAdmin working, so I guess we have 29 days left to solve this problem.  :-)
LVL 29

Expert Comment

ID: 16895561
Also have a look at DBTools Manager.
Another test to do: put a password to your user, both in config.inc and (of course!) in mysql uer tables. It seems that in some occasions with IIS this might create a problem (I don't understand why, but then there are so many things I don't understand!)

Author Comment

by:CIC Admin
ID: 16900167

After comparing the phpInfo screens, I noticed that the Client API Version line in the mySQL section did not match.  One was 4.0.18 and the other was 4.1.7.  Doing a little searching, I found the Client Version was determined by the libmysql.dll file.  I had suspected this file early on, and checked the versions on numerous occasions.  This new info caused me to look closer and I discovered that although I had matching libmysql.dll files in the same correct locations on both machines, there was a different (correct) version in an old c:\phpold2 directory on the working machine.  This DLL must have been registered and active even though it was in an old unused directory.  Once I copied that new good file to the second computer, I refreshed phpinfo and the new 4.1.7 version showed up.  Feeling confident, I did another table browse and it worked like a charm!

Thanks so much for the help, Fibo, and enjoy the points!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

834 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