Entering a noteId in the AddPartyNote screen causes a foreign key error
-----------------------------------------------------------------------
Key: OFBIZ-1357
URL: https://issues.apache.org/jira/browse/OFBIZ-1357
Project: OFBiz
Issue Type: Bug
Components: party
Affects Versions: Release Branch 4.0
Environment: Windows/Linux
Reporter: Skip Dever
Priority: Minor
Fix For: SVN trunk
Log into webtools. Click on Party tab. Click on "Find..." at the bottom
with all the fields blank. Select "DemoCustCompany" [Details]
At the very bottom of the page, click "Create New" in the notes area.
In the next screen, enter a noteId and note and click save at the bottom.
You get this error:
...
[noteId,DemoNote1(java.lang.String)][partyId,DemoCustCompany(java.lang.Strin
g)] ... INSERT on table 'PARTY_NOTE' caused a violation of foreign key
constraint 'PARTY_NOTE_NOTE' for key (DemoNote1).
....
org.ofbiz.party.party.PartyServices.createPartyNote(PartyServices.java:631)
If you look at the code referenced, you will note that if the "Note Id"
field is left blank, the NoteData entry is created and everything works
fine.
It is my view that createPartyNote() should be modified to check to see if
the NoteData exists if a noteId is passed and if not, one should be created
or else the Note id field should be removed from (or passed as hidden) the
note creation screen.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
