I have reported the case on the user list yesterday.
Environment: IE7.
The scenario is like this.
I want to create a new security group. I enter Security Group ID as
"TestSubmit" and Descirption as "TestSubmit" then press Update button. The
result is I create a "TestSubmit" Security Group ID and a error message:
The Following Errors Occurred:
ERROR: Could not complete the Create an SecurityGroup
[file:/D:/work/save/tools/svn-win32-1.4.0/bin/GlobalTrend/applications/securityext/script/org/ofbiz/securityext/securitygroup/SecurityGroupServices.xml#createSecurityGroup]
process [problem creating the newEntity value: Exception while inserting the
following entity: [GenericEntity:SecurityGroup][createdStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][createdTxStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][description,TestSubmit4(java.lang.String)][groupId,TestSubmit4(java.lang.String)][lastUpdatedStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][lastUpdatedTxStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)] (while inserting:
[GenericEntity:SecurityGroup][createdStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][createdTxStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][description,TestSubmit4(java.lang.String)][groupId,TestSubmit4(java.lang.String)][lastUpdatedStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)][lastUpdatedTxStamp,2007-05-11
12:14:10.937(java.sql.Timestamp)] (SQL Exception while executing the
following:INSERT INTO SECURITY_GROUP (GROUP_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation
message from server: "Duplicate entry 'TestSubmit4' for key 1")))]
The problem is in IE7 only. I only got IE7 and Firefox. After I do some
research, I found the problem is IE7 will do submit twice, one from submit
buttom and another one from function submitFormDisableButton(button).
In the research I comment out line 205: button.form.submit() in
selectall.js. And do the submit in IE7 again, in theory I should not create
any security group, however the system do create a security group for me.
Therefore I think we should add a browser checking before the line 205.
Should I write the patch myself and submit to the mailing list? Or somebody
else write it?
Thanks.