#1171 Cannot browse tables and no sql results

[James Butler]

I cannot browse any table in any of my databases. Also, the sql window will not return any results from a table. All I get in either case is a blank screen and no errors.
No errors in web server logs either.
Here is my configuration:
RHEL 5
Apache 2.2.17
PHP 5.3.6
MySQL 5.5.13
phpMyAdmin 3.4.3.1
using MySqli extension.
I have session, json, and mbstring enabled in PHP and the session is writing to a directory that is writeable by the webserver group.
I have two identicle machines and this is happening on both.

Here is my config.inc.php file:
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.4.3.1 setup script
* Date: Wed, 13 Jul 2011 10:40:21 -0500
*/

/* Servers configuration */
$i = 0;

/* Server: TTP Development Server [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'TTP Development Server';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = true;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['only_db'] = array('faqs', 'pmpro');
$cfg['Servers'][$i]['CountTables'] = true;
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = '********';
$cfg['Servers'][$i]['controlpass'] = '********';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/* End of servers configuration */

$cfg['blowfish_secret'] = '****************************************';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['ForceSSL'] = true;
$cfg['QueryHistoryDB'] = true;
$cfg['LoginCookieRecall'] = false;
$cfg['OBGzip'] = false;
?>

[Marc Delisle]

Can you do other actions in your tables, like seeing their structure or inserting?

Are you using mysqlnd (this can be seen on your main phpMyAdmin page) ?

[James Butler]

Screenshot of main phpmyadmin page

[James Butler]

Yes, I can insert and do all of the other operations except browse tables and query tables.

What do you mean by mysqlnd? don't know that one. I have attached a screenshot of my main phpmyadmin page that shows all of the PHP, Apache, and MySQL information.

[James Butler]

Also discovered that when I click on the Status tab I get a blank screen there as well.

[Marc Delisle]

By mysqlnd I meant this: http://ca.php.net/mysqlnd but you are not using it.

Usually, blank screens mean that your web server's process dies; it should be generating an error in its error log but maybe something else is blocking the error output. Or the errors files are not where you think they are.

Did you try with a real simple table with one column and one row?

[James Butler]

I created a table called simple_table, with one column "Name" length 100 and inserted one row into the table. Could not browse the table. I did find that if I edit the root user privileges, not changing anything, and then go and browse a table, it works on some of them just for a few minutes then quits working. Really strange behavior.

[Marc Delisle]

Sorry, I cannot reproduce these problems. You must understand that if this bug existed in 3.4.3.1, we would get reports from others. So it's probably specific to your environment.

[James Butler]

I was afraid of that since I couldn't find anything on the net about this issue.
Do you have any idea of where I should start looking?
I have looked at the websever error log, the mysql error log, and the system logs and can't find anything related to this. I also do not get any feedback in the web browser. My system meets all of the requirements listed on the phpMyAdmin home page and I have a working phpmyadmin 3.1.1 that does not have this issue.
Any suggestions?

[Marc Delisle]

Your version 3.1.1 not having this issue, is running on the same server? Did you try it with the same config.inc.php as the version having the issue?

Apart from this, I have only one suggestion: if you are familiar with git, there is a way to find the exact point between those two versions, where the problem starts to happen.

[James Butler]

No, my 3.1.1 version works without this issue.
I tried using the config.inc.php file from the 3.1.1. version in the 3.4.3.1 version with the added storage config tables and control user but the issue is still there with that config. Also tried the config from the one having the issue with the older version and could not reproduce the issue. The 3.1.1. still worked with the other ones config.
I am a little familiar with the git source control program by Linus Torvalds. I would need some help with finding what version this started with.
Thanks for all the help so far.

[James Butler]

Correction on that first sentence in the last comment. I meant to say Yes, the 3.1.1. version is running on the same server as the 3.4.3.1 version.

[Rouslan Placella]

To find in what version this issue was introduced, you need to:
* clone our source code repository [1]
* execute a 'git bisect' to conduct a binary search inside the repository [2]

[1]: http://wiki.phpmyadmin.net/pma/Git#Obtaining_code
[2]: http://wiki.phpmyadmin.net/pma/Git#Finding_problematic_commit

[James Butler]

Thanks roccivic, I'll try that tonight when I get home from work.