Integrity constraint raised on local signup

[loictalbot]

hi,
I get this issue when the app is deployed locally and running the startup screen properly. Then I have clicked on "join", filled up the fields and submitted.

here is the stacktrace on submit:

---

HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into MemberAction (actionType, performTime, latitude, longitude, member) values (?, ?, ?, ?, ?)]; Referential integrity constraint violation: "CONSTRAINT_8A0: PUBLIC.MEMBERACTION FOREIGN KEY(MEMBER) REFERENCES PUBLIC.MEMBER(ID)"; SQL statement:

---

It seems a foreign key is misplaced on MemberAction table

thanks for any help

edited: 2/7/2013

i've removed all foreign keys, bad practise, but just to make it run, signup etc properly

[KanuGT]

Got The Solution, entry done in Member Table is +1 to the result of identity() function, Added +1 everywhere call identity() is written. Started Pull Request fro Same.