Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001310PacketFencecorepublic2011-10-15 02:102012-10-19 13:34
Assigned Tofgaudreault 
StatusresolvedResolutionno change required 
PlatformOSOS Version
Product Version3.0.1 
Target VersionFixed in Version 
Summary0001310: adding a node before adding a person causes key constraint failed without proper error message in the UI
Descriptionit's correct that adding a node before a person should cause an error. However, the error should be displayed in the WebUI which is not the case. Instead, the WebUI displays 'Added Record' (without dispaying the mac address) which suggests everything's OK. In packetfence.log the below 'key constraint failed' is logged leaving the user guessing what might be wrong.

Despite of what the pf pdf documentation might or might not mention I believe this could be handled much more user friendly.
Additional InformationOct 15 07:51:56 pfcmd(4340) WARN: database query failed with: Cannot add or update a child row: a foreign key constraint fails (`pf`.`node`, CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again (pf::db::db_query_execute)
TagsNo tags attached.
fixed in git revision
fixed in mtn revision
Attached Files

- Relationships
duplicate of 0000840closedobilodeau pfcmd node edit (web node edit) fails silently 

-  Notes
obilodeau (reporter)
2011-10-17 10:05

Duplicate, please subscribe to 0000840 to follow status.

This problem is deep in pf's db layer architecture. Proper fix would mean radical changes.
fgaudreault (viewer)
2012-10-19 13:34

Dupe. See the ticket for info.

- Issue History
Date Modified Username Field Change
2011-10-15 02:10 psnizek New Issue
2011-10-17 10:01 obilodeau Relationship added duplicate of 0000840
2011-10-17 10:05 obilodeau Note Added: 0002360
2012-10-19 13:34 fgaudreault Note Added: 0003168
2012-10-19 13:34 fgaudreault Status new => resolved
2012-10-19 13:34 fgaudreault Resolution open => no change required
2012-10-19 13:34 fgaudreault Assigned To => fgaudreault

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker