Hi,
I believe I noticed deviant behavior with the integer attribute. Indeed with the other attributes a control of the contents is carried out. And if an error is detected a small red icon is visible. But if a field is AttributeInteger, there is no high value check. This generates an SQL error on creation: Error: Failed to issue SQL Query: query = INSERT INTO Class
I use a 2.7.3-6624 version (not the lase one.. i know).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Erwan,
Could you be a bit more precise on how to reproduce your issue on a standard iTop (without any of your customization).
When I try to edit on the Console a Server "Rack Unit" I have tested on Firefox with an iTop 2.7.3 (so same as yours) but I am not seeing any issue : any invalid character is trapped and it displays a red icon before I can even save the form. So how do you process ?
Do you face that issue in a portal ? Are you using a particular browser? I am using Server as it is the only class having an IntegerAttribute in a standard iTop ;-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, got it: just enter a very very long integer and bing !!!
Error: Failed to issue SQL query: query = INSERT INTO datacenterdevice (id,rack_id,enclosure_id,nb_u,managementip,powera_id,powerB_id,redundancy,finalclass) VALUES (32, 0, 0, 100200300400, '', 0, 0, '1', 'Server'), mysql_errno = 1264, mysql_error = Out of range value for column 'nb_u' at row 1.
Good catch, thanks for the report. I will log it.
👍
1
Last edit: Vincent @ Combodo 2021-07-30
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i try to add 34654654564654646 (not a real value but only a big number).
And when i applied that say :
L'objet ne peut pas être sauvé : Failed to issue SQL query: query= UPDATE 'test' AS 'Test' SET 'Test'.'num_ticket'=34654654564654646 WHERE ('Test'.'id' = '6'), mysql_errno = 1264, mysql_error = Out of range value for column 'num_ticket' at row 1.
Firefox version is 86.0 (64bit).
It's not very important about me, but i think it s a standard type .. perhaps can be check in a next version.
Hi,
I believe I noticed deviant behavior with the integer attribute. Indeed with the other attributes a control of the contents is carried out. And if an error is detected a small red icon is visible. But if a field is AttributeInteger, there is no high value check. This generates an SQL error on creation: Error: Failed to issue SQL Query: query = INSERT INTO Class
I use a 2.7.3-6624 version (not the lase one.. i know).
Hello Erwan,
Could you be a bit more precise on how to reproduce your issue on a standard iTop (without any of your customization).
When I try to edit on the Console a Server "Rack Unit" I have tested on Firefox with an iTop 2.7.3 (so same as yours) but I am not seeing any issue : any invalid character is trapped and it displays a red icon before I can even save the form. So how do you process ?
Do you face that issue in a portal ? Are you using a particular browser?
I am using Server as it is the only class having an IntegerAttribute in a standard iTop ;-)
Sorry, got it: just enter a very very long integer and bing !!!
Error: Failed to issue SQL query: query = INSERT INTO
datacenterdevice(id,rack_id,enclosure_id,nb_u,managementip,powera_id,powerB_id,redundancy,finalclass) VALUES (32, 0, 0, 100200300400, '', 0, 0, '1', 'Server'), mysql_errno = 1264, mysql_error = Out of range value for column 'nb_u' at row 1.Good catch, thanks for the report. I will log it.
Last edit: Vincent @ Combodo 2021-07-30
It's inside an extension.
<field id="user-content-num_ticket" xsi:type="AttributeInteger" _delta="define">
<sql>num_ticket</sql>
<default_values>
<is_null_allowed>true</is_null_allowed>
</default_values></field>
i try to add 34654654564654646 (not a real value but only a big number).
And when i applied that say :
L'objet ne peut pas être sauvé : Failed to issue SQL query: query= UPDATE 'test' AS 'Test' SET 'Test'.'num_ticket'=34654654564654646 WHERE ('Test'.'id' = '6'), mysql_errno = 1264, mysql_error = Out of range value for column 'num_ticket' at row 1.
Firefox version is 86.0 (64bit).
It's not very important about me, but i think it s a standard type .. perhaps can be check in a next version.