0000917: node add fails on key constraint and they are not validated beforehand - PacketFence - BTS

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0000917

PacketFence

error-handling

public

2010-02-24 12:49

2015-02-13 15:26

Reporter

obilodeau

Assigned To

obilodeau

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

open

Platform

OS

OS Version

Product Version

Target Version

Fixed in Version

Summary

0000917: node add fails on key constraint and they are not validated beforehand

Description

DBI error string
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)

We should avoid that: either auto-create the person or bail appropriately.

Currently both Web UI and pfcmd call fails silently.

Tags

fixed in git revision

fixed in mtn revision

Relationships

duplicate of	0000840	closed	obilodeau	pfcmd node edit (web node edit) fails silently
related to	0001311	closed		person and identifier are confusing concepts

Notes
(0001862) hawk (reporter) 2011-02-15 08:04	Think I have also hit this bug! If I "add" a "node" via the Web UI, but forget to add a "identifier" or uses an non-existing identifier, then the node will not get added, BUT the Web UI reports "Added Record", which is false! It was also not intuitive, to me, that the "identifier" refers to a "person" identifier. New users playing with the admin interface is going to be really confused. I think fixing this bug, should have a higher priority.

(0001863) obilodeau (reporter) 2011-02-15 09:47	Rescheduled to 2.0.2. Thanks for the identifier remark.

(0002361) obilodeau (reporter) 2011-10-17 10:15	in node add, changed Identifier to Person Identifier as was mentioned

(0003724) 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
2010-02-24 12:49	obilodeau	New Issue
2010-02-24 12:49	obilodeau	Status	new => assigned
2010-02-24 12:49	obilodeau	Assigned To	=> obilodeau
2010-05-05 13:46	obilodeau	Category	1.8.7 => error-handling
2010-05-05 13:46	obilodeau	Target Version	=> 1.9.1
2010-09-15 13:20	obilodeau	Tag Attached: usability
2010-09-15 13:20	obilodeau	Target Version	1.9.1 => 1.9.2
2010-09-22 16:02	obilodeau	Target Version	1.9.2 => 1.9.3
2011-02-15 08:04	hawk	Note Added: 0001862
2011-02-15 09:47	obilodeau	Note Added: 0001863
2011-02-15 09:47	obilodeau	Target Version	1.9.3 => 2.0.2
2011-03-03 15:19	obilodeau	Target Version	2.0.2 => +1
2011-10-17 10:01	obilodeau	Relationship added	duplicate of 0000840
2011-10-17 10:15	obilodeau	Note Added: 0002361
2011-10-17 10:19	obilodeau	Relationship added	related to 0001311
2015-02-13 15:26	lmunro	Note Added: 0003724
2015-02-13 15:26	lmunro	Status	assigned => closed

Copyright © 2000 - 2012 MantisBT Group