PacketFence
Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000840PacketFenceerror-handlingpublic2009-11-06 15:522015-02-13 15:26
Reporterobilodeau 
Assigned Toobilodeau 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0000840: pfcmd node edit (web node edit) fails silently
Descriptionreproduced in the lab with:
bin/pfcmd node edit 00:12:f0:13:32:ba pid=guest,status="reg"

doesn't work, no error message
Tagsusability
fixed in git revision
fixed in mtn revision
Attached Files

- Relationships
has duplicate 0000917closedobilodeau node add fails on key constraint and they are not validated beforehand 
has duplicate 0001310resolvedfgaudreault adding a node before adding a person causes key constraint failed without proper error message in the UI 

-  Notes
(0001388)
obilodeau (reporter)
2009-11-06 15:56

here's the low-level problem:

mysql> update node set pid='guest', status='reg' where mac='00:12:f0:13:32:ba';
ERROR 1452 (23000): 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)

we need to atleast deal with this error in the code, right now everything silently fails
(0001389)
obilodeau (reporter)
2009-11-06 15:57

heck even a dropdown box for pid should be offered in the node edit screen instead of a text input if this is a real constraint
(0003725)
lmunro (administrator)
2015-02-13 15:26

Old issues.
Most are not relevant to PF 4 and up.

Let's reopen the ones that matter when we move to github.

- Issue History
Date Modified Username Field Change
2009-11-06 15:52 obilodeau New Issue
2009-11-06 15:52 obilodeau Status new => assigned
2009-11-06 15:52 obilodeau Assigned To => obilodeau
2009-11-06 15:56 obilodeau Note Added: 0001388
2009-11-06 15:57 obilodeau Note Added: 0001389
2010-03-01 13:28 obilodeau Category 1.8.5 => error-handling
2010-07-23 13:02 obilodeau Tag Attached: usability
2011-01-18 11:53 obilodeau Target Version => 2.0.1
2011-01-26 15:30 obilodeau Target Version 2.0.1 => 2.0.2
2011-03-03 15:19 obilodeau Target Version 2.0.2 => +1
2011-10-17 10:01 obilodeau Relationship added has duplicate 0000917
2011-10-17 10:01 obilodeau Relationship added has duplicate 0001310
2015-02-13 15:26 lmunro Note Added: 0003725
2015-02-13 15:26 lmunro Status assigned => closed


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker