Thread: [adminer-tracker] [ adminer-Bugs and Features-2991459 ] NULL values inserted
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2010-04-23 16:24:57
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Tracker Item Submitted) made by ondrejbrejla You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 16:38:23
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Settings changed) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 >Status: Pending Resolution: None Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 16:48:44
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Settings changed) made by ondrejbrejla You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 >Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- >Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 18:48 Message: Ouou...my fault...sorry...disabled JS after some testing... "But" maybe it will be better to have empty like default, not NULL(in non-js version?). It's strange getting NULL values after you fill inputs..."because you didn't changed little select box"...I supposed that I get my inserted values...not NULL :) Or it's only my feeling. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 16:57:40
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 >Status: Closed >Resolution: Wont Fix Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:57 Message: Default value should correspond with real default which is a NULL. Without JavaScript, it's impossible to know whether the NULL was selected earlier then filling the value or later. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 18:48 Message: Ouou...my fault...sorry...disabled JS after some testing... "But" maybe it will be better to have empty like default, not NULL(in non-js version?). It's strange getting NULL values after you fill inputs..."because you didn't changed little select box"...I supposed that I get my inserted values...not NULL :) Or it's only my feeling. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 17:21:54
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Comment added) made by ondrejbrejla You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 Status: Closed Resolution: Wont Fix Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 19:21 Message: Yes I understand...but on the server side you can make decision (suppose NULL option is by default - like now) - if a user inserted some values in the field, you shouldn't insert NULL value (even though NULL option is selected by default)...if he didn't fill any value into the field and NULL is selected, so you can insert NULL value. I can't imagine a situation where someone fills some values and expects that NULL will be inserted. But it's only food for thought :-) And maybe there's some misunderstanding of Adminer philosophy on my side ;-) Thx for your time. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:57 Message: Default value should correspond with real default which is a NULL. Without JavaScript, it's impossible to know whether the NULL was selected earlier then filling the value or later. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 18:48 Message: Ouou...my fault...sorry...disabled JS after some testing... "But" maybe it will be better to have empty like default, not NULL(in non-js version?). It's strange getting NULL values after you fill inputs..."because you didn't changed little select box"...I supposed that I get my inserted values...not NULL :) Or it's only my feeling. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 18:35:52
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 Status: Closed Resolution: Wont Fix Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 20:35 Message: The opposite scenario is also possible. Something is filled in and user decides to change it to NULL. He would have no glue the apart from selecting NULL he has also need to clear the value. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 19:21 Message: Yes I understand...but on the server side you can make decision (suppose NULL option is by default - like now) - if a user inserted some values in the field, you shouldn't insert NULL value (even though NULL option is selected by default)...if he didn't fill any value into the field and NULL is selected, so you can insert NULL value. I can't imagine a situation where someone fills some values and expects that NULL will be inserted. But it's only food for thought :-) And maybe there's some misunderstanding of Adminer philosophy on my side ;-) Thx for your time. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:57 Message: Default value should correspond with real default which is a NULL. Without JavaScript, it's impossible to know whether the NULL was selected earlier then filling the value or later. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 18:48 Message: Ouou...my fault...sorry...disabled JS after some testing... "But" maybe it will be better to have empty like default, not NULL(in non-js version?). It's strange getting NULL values after you fill inputs..."because you didn't changed little select box"...I supposed that I get my inserted values...not NULL :) Or it's only my feeling. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-04-23 19:10:25
|
Bugs and Features item #2991459, was opened at 2010-04-23 18:24 Message generated for change (Comment added) made by ondrejbrejla You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&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: Adminer Group: 2.3.2 Status: Closed Resolution: Wont Fix Priority: 5 Private: No Submitted By: Ondřej Brejla (ondrejbrejla) Assigned to: Jakub Vrána (jakubvrana) Summary: NULL values inserted Initial Comment: When I have some attributes in the table marked as NULL (that they can be) and I try to fill the table using Adminer, these attributes are always filled by NULL values. Even though I filled inputs with my values. What I have to do is to manually switch NULL option in the select box next to the input field. That's quite WTF behavior. I noticed that I have NULLs in my table after minutes of app debugging:) Maybe the solution could be to have an empty option as a default value, not NULL option. Thx. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 21:10 Message: That's true, but I think that the first case is more frequent so it can improve Adminer's usability. But I know, it can be the subject of discussions... ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 20:35 Message: The opposite scenario is also possible. Something is filled in and user decides to change it to NULL. He would have no glue the apart from selecting NULL he has also need to clear the value. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 19:21 Message: Yes I understand...but on the server side you can make decision (suppose NULL option is by default - like now) - if a user inserted some values in the field, you shouldn't insert NULL value (even though NULL option is selected by default)...if he didn't fill any value into the field and NULL is selected, so you can insert NULL value. I can't imagine a situation where someone fills some values and expects that NULL will be inserted. But it's only food for thought :-) And maybe there's some misunderstanding of Adminer philosophy on my side ;-) Thx for your time. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:57 Message: Default value should correspond with real default which is a NULL. Without JavaScript, it's impossible to know whether the NULL was selected earlier then filling the value or later. ---------------------------------------------------------------------- Comment By: Ondřej Brejla (ondrejbrejla) Date: 2010-04-23 18:48 Message: Ouou...my fault...sorry...disabled JS after some testing... "But" maybe it will be better to have empty like default, not NULL(in non-js version?). It's strange getting NULL values after you fill inputs..."because you didn't changed little select box"...I supposed that I get my inserted values...not NULL :) Or it's only my feeling. ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-04-23 18:38 Message: Please specify your browser. Adminer changes NULL to the filled value in onchange. If you have disabled JavaScript then NULL has to be changed by hand. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2991459&group_id=264133 |