| Anonymous | Login | 2024-11-22 23:21 EST |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||
| 0001285 | PacketFence | core | public | 2011-09-27 15:47 | 2012-02-29 10:45 | |||
| Reporter | dwuelfrath | |||||||
| Assigned To | dwuelfrath | |||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |||
| Status | closed | Resolution | fixed | |||||
| Platform | OS | OS Version | ||||||
| Product Version | ||||||||
| Target Version | 3.0.2 | Fixed in Version | 3.0.2 | |||||
| Summary | 0001285: add trigger or cascade to delete node_useragent when deleting a node | |||||||
| Description | when we delete a node, we should also delete the mac-useragent binding. | |||||||
| Tags | No tags attached. | |||||||
| fixed in git revision | ||||||||
| fixed in mtn revision | 403f38fb5859a3572f58f372cc01826ed35a8bf9 | |||||||
| Attached Files | ||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0002314) dwuelfrath (administrator) 2011-10-05 14:10 |
Could look like this -- -- Trigger to delete the node_useragent associated with a mac when deleting this mac from the node table -- DROP TRIGGER IF EXISTS node_useragent_delete_trigger; DELIMITER / CREATE TRIGGER node_useragent_delete_trigger AFTER DELETE ON node FOR EACH ROW BEGIN DELETE FROM node_useragent WHERE mac = OLD.mac; END / DELIMITER ; |
|
(0002321) obilodeau (reporter) 2011-10-06 10:15 |
yes, go for it |
|
(0002334) dwuelfrath (administrator) 2011-10-11 16:29 |
modified in revision 8aa7974a4ae1c1d0bbcbd5d163e1efa5afbbf6f1 |
|
(0002351) obilodeau (reporter) 2011-10-14 09:29 |
Was the upgrade script tested, new db install tested and node deletion with cascade tested? |
|
(0002355) dwuelfrath (administrator) 2011-10-14 10:19 |
Yes |
|
(0002394) obilodeau (reporter) 2011-10-24 20:27 |
fix released in 3.0.2 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-09-27 15:47 | dwuelfrath | New Issue | |
| 2011-10-05 14:10 | dwuelfrath | Note Added: 0002314 | |
| 2011-10-06 10:15 | obilodeau | Note Added: 0002321 | |
| 2011-10-07 10:03 | dwuelfrath | mtn revision | => 403f38fb5859a3572f58f372cc01826ed35a8bf9 |
| 2011-10-07 10:03 | dwuelfrath | Status | new => resolved |
| 2011-10-07 10:03 | dwuelfrath | Resolution | open => fixed |
| 2011-10-07 10:03 | dwuelfrath | Fixed in Version | => 3.0.1 |
| 2011-10-07 10:04 | dwuelfrath | Status | resolved => assigned |
| 2011-10-07 10:04 | dwuelfrath | Assigned To | => dwuelfrath |
| 2011-10-07 10:04 | dwuelfrath | Status | assigned => resolved |
| 2011-10-11 16:29 | dwuelfrath | Note Added: 0002334 | |
| 2011-10-14 09:29 | obilodeau | Note Added: 0002351 | |
| 2011-10-14 10:19 | dwuelfrath | Note Added: 0002355 | |
| 2011-10-24 20:27 | obilodeau | Fixed in Version | 3.0.1 => 3.0.2 |
| 2011-10-24 20:27 | obilodeau | Note Added: 0002394 | |
| 2011-10-24 20:28 | obilodeau | Status | resolved => closed |
| 2011-10-24 20:28 | obilodeau | Target Version | +1 => 3.0.2 |
| 2012-02-29 10:45 | obilodeau | Category | feature => core |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |