[Phpmyadmin-devel] Browsing an empty table
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior. After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this. Maybe, when browsing an empty table, we should avoid to go to Structure? -- Marc Delisle http://infomarc.info
On Wed, May 1, 2013 at 9:56 PM, Marc Delisle <marc@infomarc.info> wrote:
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior.
After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this.
Maybe, when browsing an empty table, we should avoid to go to Structure?
I think it makes more sense to send the user to the Browse page itself when the table is empty. This way the user has access to 'Query results operations' and 'Bookmark this SQL query' section. 'Query results operations' should only show 'Create view' link as others are not valid for empty results set. What do you all think? If you like the idea I'd like to prepare a pull request.
-- Regards Kasun Chathuranga
On Wed, May 1, 2013 at 12:26 PM, Marc Delisle <marc@infomarc.info> wrote:
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior.
After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this.
Maybe, when browsing an empty table, we should avoid to go to Structure?
Sorry, I think I'm a bit confused. If I go in to a table's Operations tab and click the Empty button, I get a popup warning if I want to truncate the table. After pressing OK, I'm left on the Operations tab with a popup notification giving the results. At no point am I redirected to any other page. The behavior I'm seeing is what I would expect -- is yours behaving differently or am I misunderstanding the steps to reproduce?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Wed, May 1, 2013 at 12:26 PM, Marc Delisle <marc@infomarc.info> wrote: Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior. After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this. Maybe, when browsing an empty table, we should avoid to go to Structure? Sorry, I think I'm a bit confused. If I go in to a table's Operations tab and click the Empty button, I get a popup warning if I want to truncate the table. After pressing OK, I'm left on the Operations tab with a popup notification giving the results. At no point am I redirected to any other page. The behavior I'm seeing is what I would expect -- is yours behaving differently or am I misunderstanding the steps to reproduce? After the table is empty, go to the database structure page (tables list). In the row of the empty table, click the "Browse" link. You see the structure with a green message that the table is empty. (You may also click the grey "Browse" in the table menu.) J.M.
Isaac Bennetch a écrit :
On Wed, May 1, 2013 at 12:26 PM, Marc Delisle <marc@infomarc.info> wrote:
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior.
After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this.
Maybe, when browsing an empty table, we should avoid to go to Structure?
Sorry, I think I'm a bit confused. If I go in to a table's Operations tab and click the Empty button, I get a popup warning if I want to truncate the table. After pressing OK, I'm left on the Operations tab with a popup notification giving the results. At no point am I redirected to any other page. The behavior I'm seeing is what I would expect -- is yours behaving differently or am I misunderstanding the steps to reproduce?
I saw this behavior this morning on 4.0.0-rc2, but I cannot reproduce it right now. I'll try to recreate the needed steps. I remember seeing the table Structure tab being active and the structure displayed; also the "SELECT * from tablename" was shown, with a message "empty result set". -- Marc Delisle http://infomarc.info
Marc Delisle a écrit :
Isaac Bennetch a écrit :
On Wed, May 1, 2013 at 12:26 PM, Marc Delisle <marc@infomarc.info> wrote:
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior.
After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this.
Maybe, when browsing an empty table, we should avoid to go to Structure?
Sorry, I think I'm a bit confused. If I go in to a table's Operations tab and click the Empty button, I get a popup warning if I want to truncate the table. After pressing OK, I'm left on the Operations tab with a popup notification giving the results. At no point am I redirected to any other page. The behavior I'm seeing is what I would expect -- is yours behaving differently or am I misunderstanding the steps to reproduce?
I saw this behavior this morning on 4.0.0-rc2, but I cannot reproduce it right now. I'll try to recreate the needed steps.
I remember seeing the table Structure tab being active and the structure displayed; also the "SELECT * from tablename" was shown, with a message "empty result set".
Forgetting the Operations aspect of it, you can see what I mean by clicking on Browse for an empty table. -- Marc Delisle http://infomarc.info
On Wed, May 1, 2013 at 1:10 PM, Marc Delisle <marc@infomarc.info> wrote:
Marc Delisle a écrit :
Isaac Bennetch a écrit :
On Wed, May 1, 2013 at 12:26 PM, Marc Delisle <marc@infomarc.info> wrote:
Hi, I was training someone new to phpMyAdmin this morning and she was surprised by the interface's behavior.
After Operations > Empty the table, the interface tries to browse the table, then goes to the Structure page. She did not expect this.
Maybe, when browsing an empty table, we should avoid to go to Structure?
Sorry, I think I'm a bit confused. If I go in to a table's Operations tab and click the Empty button, I get a popup warning if I want to truncate the table. After pressing OK, I'm left on the Operations tab with a popup notification giving the results. At no point am I redirected to any other page. The behavior I'm seeing is what I would expect -- is yours behaving differently or am I misunderstanding the steps to reproduce?
I saw this behavior this morning on 4.0.0-rc2, but I cannot reproduce it right now. I'll try to recreate the needed steps.
I remember seeing the table Structure tab being active and the structure displayed; also the "SELECT * from tablename" was shown, with a message "empty result set".
Forgetting the Operations aspect of it, you can see what I mean by clicking on Browse for an empty table.
In that case, I see that "Browse" and "Search" are grey text instead of black, with a red X cursor when mousing over. As a result, I automatically assume that those aren't actual links. That being said, I think I recall that we made them links some time ago because someone was populating data by some external means and wanted to be able to browse the new data without having to navigate away and back in phpMyAdmin. I think it's not intuitive, but then again, it's probably not meant to be. All that aside, I agree with your statement; Browse should go to the browse page regardless and not to Structure.
Hi Dne Wed, 1 May 2013 13:18:58 -0400 Isaac Bennetch <bennetch@gmail.com> napsal(a):
In that case, I see that "Browse" and "Search" are grey text instead of black, with a red X cursor when mousing over. As a result, I automatically assume that those aren't actual links. That being said, I think I recall that we made them links some time ago because someone was populating data by some external means and wanted to be able to browse the new data without having to navigate away and back in phpMyAdmin. I think it's not intuitive, but then again, it's probably not meant to be.
All that aside, I agree with your statement; Browse should go to the browse page regardless and not to Structure.
Yes, this sounds as best approach. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Michal Čihař a écrit :
Hi
Dne Wed, 1 May 2013 13:18:58 -0400 Isaac Bennetch <bennetch@gmail.com> napsal(a):
In that case, I see that "Browse" and "Search" are grey text instead of black, with a red X cursor when mousing over. As a result, I automatically assume that those aren't actual links. That being said, I think I recall that we made them links some time ago because someone was populating data by some external means and wanted to be able to browse the new data without having to navigate away and back in phpMyAdmin. I think it's not intuitive, but then again, it's probably not meant to be.
All that aside, I agree with your statement; Browse should go to the browse page regardless and not to Structure.
Yes, this sounds as best approach.
I created https://sourceforge.net/p/phpmyadmin/bugs/3904/. -- Marc Delisle http://infomarc.info
participants (5)
-
Isaac Bennetch -
J. M. -
Kasun Chathuranga -
Marc Delisle -
Michal Čihař