Thread: [adminer-tracker] [ adminer-Bugs and Features-3598547 ] unable to type in fractional number with 6.
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2012-12-26 18:37:32
|
Bugs and Features item #3598547, was opened at 2012-12-26 10:37 Message generated for change (Tracker Item Submitted) made by dennisfa You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.6.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Dennis Fantoni (dennisfa) Assigned to: Jakub Vrána (jakubvrana) Summary: unable to type in fractional number with 6.2 (worked with61) Initial Comment: I am using adminer to administer a mysql database. Don't know if the behaviour is database type specific, but I doubt it. WHen I use 6.1 I can edit a record and type in 42.2 into a field that is double(15,5) and get it saved : click the edit link for a record. click a field that is double (15,5) type in "42.20" Hit TAB to exit the field, and then Click the save link. This works fine storing 42.20 into the database record with 6.2 i do this click edit link for a record click a field that is double(15,5) type in "42.20" as soon as i TAB out of the field, the number in there changes to 4220 if I try to type "42,20" I get to tab away from the field. however, when i click save, I get an error message "! Ugyldig værdi" which is Danish for "!Invalid value" thus -with adminer 3.6.2 (PC running a UK or US version of windows 7, set up to Danish locale, Adminer set up to write english,Chrome is english too) I have no real way of entering numbers with decimal values into records being edited. I would probably prefer the field to just take 42.20 as a good value and store that to the database. (instead of changing the value to 4220 and storing that) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 |
From: SourceForge.net <no...@so...> - 2012-12-28 16:55:28
|
Bugs and Features item #3598547, was opened at 2012-12-26 10:37 Message generated for change (Comment added) made by gregtyler You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.6.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Dennis Fantoni (dennisfa) Assigned to: Jakub Vrána (jakubvrana) Summary: unable to type in fractional number with 6.2 (worked with61) Initial Comment: I am using adminer to administer a mysql database. Don't know if the behaviour is database type specific, but I doubt it. WHen I use 6.1 I can edit a record and type in 42.2 into a field that is double(15,5) and get it saved : click the edit link for a record. click a field that is double (15,5) type in "42.20" Hit TAB to exit the field, and then Click the save link. This works fine storing 42.20 into the database record with 6.2 i do this click edit link for a record click a field that is double(15,5) type in "42.20" as soon as i TAB out of the field, the number in there changes to 4220 if I try to type "42,20" I get to tab away from the field. however, when i click save, I get an error message "! Ugyldig værdi" which is Danish for "!Invalid value" thus -with adminer 3.6.2 (PC running a UK or US version of windows 7, set up to Danish locale, Adminer set up to write english,Chrome is english too) I have no real way of entering numbers with decimal values into records being edited. I would probably prefer the field to just take 42.20 as a good value and store that to the database. (instead of changing the value to 4220 and storing that) ---------------------------------------------------------------------- Comment By: Greg Tyler (gregtyler) Date: 2012-12-28 08:55 Message: This is true for all non-integers in Adminer (decimal/double/float). A good fix would be to add a "step" attribute to the input element. The value should be representative of the size of decimal value. So double(15,5) would have step="0.00001" and decimal(3,2) would have step="0.01". This is a pretty big bug since Chrome won't let you save any record that has any non-integer value. Thanks! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 |
From: SourceForge.net <no...@so...> - 2013-01-10 02:32:11
|
Bugs and Features item #3598547, was opened at 2012-12-26 10:37 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.6.2 Status: Open >Resolution: Accepted Priority: 5 Private: No Submitted By: Dennis Fantoni (dennisfa) Assigned to: Jakub Vrána (jakubvrana) Summary: unable to type in fractional number with 6.2 (worked with61) Initial Comment: I am using adminer to administer a mysql database. Don't know if the behaviour is database type specific, but I doubt it. WHen I use 6.1 I can edit a record and type in 42.2 into a field that is double(15,5) and get it saved : click the edit link for a record. click a field that is double (15,5) type in "42.20" Hit TAB to exit the field, and then Click the save link. This works fine storing 42.20 into the database record with 6.2 i do this click edit link for a record click a field that is double(15,5) type in "42.20" as soon as i TAB out of the field, the number in there changes to 4220 if I try to type "42,20" I get to tab away from the field. however, when i click save, I get an error message "! Ugyldig værdi" which is Danish for "!Invalid value" thus -with adminer 3.6.2 (PC running a UK or US version of windows 7, set up to Danish locale, Adminer set up to write english,Chrome is english too) I have no real way of entering numbers with decimal values into records being edited. I would probably prefer the field to just take 42.20 as a good value and store that to the database. (instead of changing the value to 4220 and storing that) ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2013-01-09 18:32 Message: HTML5 type="number" is probably to blame. ---------------------------------------------------------------------- Comment By: Greg Tyler (gregtyler) Date: 2012-12-28 08:55 Message: This is true for all non-integers in Adminer (decimal/double/float). A good fix would be to add a "step" attribute to the input element. The value should be representative of the size of decimal value. So double(15,5) would have step="0.00001" and decimal(3,2) would have step="0.01". This is a pretty big bug since Chrome won't let you save any record that has any non-integer value. Thanks! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 |
From: SourceForge.net <no...@so...> - 2013-01-10 02:42:56
|
Bugs and Features item #3598547, was opened at 2012-12-26 10:37 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.6.2 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Dennis Fantoni (dennisfa) Assigned to: Jakub Vrána (jakubvrana) Summary: unable to type in fractional number with 6.2 (worked with61) Initial Comment: I am using adminer to administer a mysql database. Don't know if the behaviour is database type specific, but I doubt it. WHen I use 6.1 I can edit a record and type in 42.2 into a field that is double(15,5) and get it saved : click the edit link for a record. click a field that is double (15,5) type in "42.20" Hit TAB to exit the field, and then Click the save link. This works fine storing 42.20 into the database record with 6.2 i do this click edit link for a record click a field that is double(15,5) type in "42.20" as soon as i TAB out of the field, the number in there changes to 4220 if I try to type "42,20" I get to tab away from the field. however, when i click save, I get an error message "! Ugyldig værdi" which is Danish for "!Invalid value" thus -with adminer 3.6.2 (PC running a UK or US version of windows 7, set up to Danish locale, Adminer set up to write english,Chrome is english too) I have no real way of entering numbers with decimal values into records being edited. I would probably prefer the field to just take 42.20 as a good value and store that to the database. (instead of changing the value to 4220 and storing that) ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2013-01-09 18:42 Message: Thank you for the report, I've fixed it in Git. You can download the "Current development version" from http://www.adminer.org/#download ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2013-01-09 18:32 Message: HTML5 type="number" is probably to blame. ---------------------------------------------------------------------- Comment By: Greg Tyler (gregtyler) Date: 2012-12-28 08:55 Message: This is true for all non-integers in Adminer (decimal/double/float). A good fix would be to add a "step" attribute to the input element. The value should be representative of the size of decimal value. So double(15,5) would have step="0.00001" and decimal(3,2) would have step="0.01". This is a pretty big bug since Chrome won't let you save any record that has any non-integer value. Thanks! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3598547&group_id=264133 |