VPMS Web Application

Foreign Constraint errors when editing any classifications

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.3
  • Fix Version/s: 1.3
  • Component/s: None
  • Labels:
    None

Description

When editing entity_classifications or contact_classifications you get a the following error on save:

Cannot delete or update a parent row: a foreign key constraint fails (`openvpms/entity_classifications`, CONSTRAINT `FK76B55CF1CEABD10B` FOREIGN KEY (`lookup_id`) REFERENCES `lookups` (`lookup_id`))

To reproduce do the following:
1. Edit a customer that has an existing Account Type.
2. On the Account Type tab remove the existing account type selection and replace with a new one.
3. Click OK and get error.

Activity

Hide
Tim Anderson added a comment -

Fixed in frameworks, revision 3153

Show
Tim Anderson added a comment - Fixed in frameworks, revision 3153

People

Vote (0)
Watch (0)

Dates

  • Due:
    Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
3h
Original Estimate - 3h
Remaining:
0.5h
Time Spent - 2.5h Remaining Estimate - 0.5h
Logged:
2.5h
Time Spent - 2.5h Remaining Estimate - 0.5h