#2890 (ok 3.2.1) Right frame is blank
Hi there!
I host my own website on my computer (Mac mini Mac OS X 10.5.7)
I am running Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7l DAV/2 PHP/5.2.9 - MySQL 5.1.35 - phpMyAdmin 3.2.0
I recently made MySQL and phpMyAdmin upgrades.
Before the upgrades, when performing a name search in the main table of my DB, if the query returned no result, the right frame displayed the warning "Your SQL query returned no result" and the usual content of the Search Tab ready for performing a new search.
Now, the right frame displays a blank page with only the mention: ServerName - DatabaseName - TableName
(please see attached file)
This occurs in Safari 3 and 4 (Mac) and Firefox for Mac (3.0.11)
Is this a bug or a new (bad) feature in phpMyAdmin 3.2.0?
If it's a bug, how do I fix it?
Many thanks in advance for investigating!
Best regards,
Gerard
Discussion
displayed result of a search returning no result (screen capture)
While we wait until the demo server comes back... Did you check in your web server's logs for error messages?
Hi Marc!
Here is the whole content of my Apache2 error_log file:
-----------------------------------------------------------
[Sun May 17 06:24:25 2009] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Sun May 17 06:24:25 2009] [notice] LDAP: SSL support unavailable
[Sun May 17 06:24:25 2009] [notice] Digest: generating secret for digest authentication ...
[Sun May 17 06:24:25 2009] [notice] Digest: done
[Sun May 17 06:24:25 2009] [emerg] (14)Bad address: Couldn't set permissions on cross-process lock; check User and Group directives
-----------------------------------------------------------
As you can see, there is no error on my WebServer since May 17.
As today Monday June 29, 09:00PM I still get a 500 Internal Server Error on your Demo Site...
Impossible to reproduce the error described in my post.
BTW, did your try to reproduce it on your own version of PMA (hope you use 3.2.0)?
Hello,
demo server is now working. In my own 3.2.0 version I don't see a blank page in the right frame, and we did not get report of such a problem even after thousands of downloads of the release candidates and final 3.2.0 version.
We'll need more details to work on this problem (if you can replicate it on the demo server), such as a small export of the table on which this happens.
Hi Marc!
I've been unable to reproduce the bug on the Demo Server which is now running fine.
As a matter of fact, there's no bug.
Mea culpa. I'm the culprit!
Problem is in my config.inc.php file.
I inserted wrong parameters.
Would you please help me in setting phpMyAdmin right?
This is what I want to obtain:
(these settings were those I used to have when using previous versions)
A - Left frame:
- icon = opens the table in Structure Tab
- table name = opens the table in Search Tab
B - Right frame:
- after performing a search resulting in an empty set display Search Tab (instead of Structure Tab)
I apologize for posting a non-existing bug.
Maybe we can continue the discussion on the forum where I started the thing?
Best regards,
Gerard
Please post another thread in the forum; me or others should have time to help.
Now that I have seen which setting you tried:
$cfg['DefaultTabTable'] = 'tbl_select.php';
I confirm that this is a bug and I see the blank frame when search results in a empty set.
May I suggest some UI improvement?
Even if I already know that it will be a lot of work and that it will take time to do it, I think you should create on the opening frame a Preferences options where the user could choose the display configuration instead of modifying the config.inc.php file.
I have some ideas about designing the content...
Results will be secure and setting configuration a lot easier for the lambda user (like me... he he he).
What do you think?
Best regards,
Gerard
PS: I'm living in Pierrefonds, QC. If you like, we could exchange in French on this matter using my personal email address...
Hi,
there is a Google Summer of Code 2009 project to implement user preferences, which would go in the pmadb (to avoid using cookies for this). You can share your ideas on the phpmyadmin-devel mailing list but as you see we have many requests, many ideas but few persons who actually have the time to code for the project.
Of course I speak French but phpMyAdmin is an international project so it's better to keep discussions public and in English.
OK.
Just for info:
How long do you think it will take to fix the bug?
Sorry, no.
Should be fixed now, please confirm.
Patch for 3.2.0: http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_3_2/phpMyAdmin/tbl_select.php?r1=12438&r2=12627&view=patch
Congratulations Marc!
It works as expected and could be included in the next revision.
I modified tbl_select.php as instructed.
Re-established $cfg['DefaultTabTable'] = 'tbl_select.php'; setting in my config.inc.php.
Logged out from phpMyAdmin then logged in.
My main table opened right with the Search Tab.
Performed a search which I am sure the result should be empty.
Returned:
1 - The right warning ("MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0350 sec )");
2 - Report the executed query;
3 - The right frame stay opened in Search Tab ready to perform a new search.
Very good job!
Merci mon cher, très beau travail !