phpMyAdmin / Bugs / #4673 (ok 4.3.4) Delimiter causing page lock

#4673 (ok 4.3.4) Delimiter causing page lock

Milestone: 4.3.3

Status: fixed

Owner: Hugues Peccatte

Labels: None

Priority: 1

Updated: 2014-12-30

Created: 2014-12-24

Creator: Martijn Kools

Private: No

This is related to: http://sourceforge.net/p/phpmyadmin/bugs/4600/

Whenever I insert data into a column there is a delimiter field above the console with default value ';'. Now if I browse to another table or column my web browser says:

'You have unsaved changes are you sure you want to leave this page?'

I think it's the delimiter because when I click GO on that that (and insert the same value for the second time by doing that) the message is gone.

This is very annoying especially if you have to insert a lot of data.

I added a screenshot as well.

Thanks.

1 Attachments

Discussion

Marc Delisle - 2014-12-26

Cannot reproduce with version 4.3.3 under Firefox. Are you inserting by typing a query or via the Insert panel?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Martijn Kools - 2014-12-27
  
  Sorry for the late response, it's by using the insert panel yes.
  
  Thanks.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Marc Delisle - 2014-12-27
    
    Martijn,
    which browser please? and did you try this browser without any special extension installed?
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Martijn Kools - 2014-12-27
      
      Just tested with all extensions disabled, same issue in both Chrome (latest stable version 39) and Firefox 34 (which has no extensions installed at all).
      
      IE 11 seems fine though, no issues there.
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-26

I reproduced the issue on Chrome 40 béta with the following steps:
- connect
- select a DB
- select a table
- click on "Insert" tab
- fill and submit the form
- click on "Browse" tab

Last edit: Hugues Peccatte 2014-12-26

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2014-12-27

Hugues,
I tried your scenario on Chrome 40 beta (Linux 64bit for Debian) and could not reproduce this problem on phpMyAdmin 4.3.3.

Do you have the problem only on a beta version of Chrome?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Martijn Kools - 2014-12-27
  
  Tested the same thing on Firefox 34.0 and Chrome 39 (stable) and both browsers show the same issue after doing the steps Hugues provided.
  
  It could be my phpmyadmin installation perhaps? I will try a reinstall, starting with a clean DB.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Marc Delisle - 2014-12-27
    
    Martijn,
    on which OS is your browser running?
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Martijn Kools - 2014-12-27
      
      Windows 7 SP1 x64
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-27

Marc,
Here is a short video that shows the way to get the error. Sorry, it's a wmv, I hope you can read it.
The first step before the video is the log in.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Martijn Kools - 2014-12-27
  
  Yes that's exactly when it happens to me as well!
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-27

Another try to send it again.

wayToConfirm.wmv

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-27

Marc,
I don't have the issue when I submit the insert form with the button.
I have the issue when I submit the insert form with "enter".

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Marc Delisle - 2014-12-28
  
  Hugues,
  You found the reason for this bug.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Isaac Bennetch - 2014-12-28
  
  Great work, Hugues
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-27

I sent a PR for this issue: https://github.com/phpmyadmin/phpmyadmin/pull/1439
Can someone check it please?
Thanks.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-27

assigned_to: Hugues Peccatte
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2014-12-28

summary: Delimiter causing page lock --> (ok 4.3.4) Delimiter causing page lock

status: open --> resolved

Priority: 3 --> 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Hugues Peccatte - 2014-12-29

Thanks a lot for your feedback! :)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2014-12-29

Status: resolved --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link: