PacketFence - BTS - PacketFence | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0001624 | PacketFence | upgrade | public | 2013-01-17 14:05 | 2013-01-21 14:56 |
| Reporter | ae3 | ||||
| Assigned To | dwuelfrath | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | OS | OS Version | |||
| Product Version | 3.6.1 | ||||
| Target Version | +0 | Fixed in Version | 3.6.1 | ||
| fixed in git revision | 11acb8b4d1728b8e09546a01ac234ecff18e0c9c | ||||
| fixed in mtn revision | |||||
| Summary | 0001624: db/upgrade-3.5.0-3.6.1.sql has primary key error | ||||
| Description | When I run the database schema update on ZEN 3.6.0 to upgrade to 3.6.1, MySQL terminates with error 1062 as shown under additional information below. I had previously added custom categories through the admin web GUI, and the first one was automatically assigned node_category 3. Hence, the primary key conflict for me, and anyone else who defined custom categories. I do not know if there is a dependency on node_category=3 for gaming devices elsewhere in the code, but I created the entry via the admin web GUI and it assigned it 0000008. If there is no dependency on that entry being 0000003, you could just drop the "category_id" and "3" from the insert command since the table was created with category_id defined as auto_increment so it will always use the next number on insert. | ||||
| Steps To Reproduce | |||||
| Additional Information | [root@pf-zen-esx pf]# mysql -u pf -p pf -v < db/upgrade-3.5.0-3.6.1.sql Enter password: -------------- INSERT INTO `node_category` (category_id,name,notes) VALUES ("3","gaming","Gaming devices") -------------- ERROR 1062 (23000) at line 5: Duplicate entry '3' for key 'PRIMARY' [root@pf-zen-esx pf]# | ||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-01-17 14:05 | ae3 | New Issue | |||
| 2013-01-18 14:48 | dwuelfrath | Status | new => assigned | ||
| 2013-01-18 14:48 | dwuelfrath | Assigned To | => dwuelfrath | ||
| 2013-01-18 14:51 | dwuelfrath | Note Added: 0003292 | |||
| 2013-01-18 14:51 | dwuelfrath | Build | => stable | ||
| 2013-01-18 14:51 | dwuelfrath | Target Version | => +1 | ||
| 2013-01-21 14:23 | dwuelfrath | fixed in git revision | => 11acb8b4d1728b8e09546a01ac234ecff18e0c9c | ||
| 2013-01-21 14:23 | dwuelfrath | Note Added: 0003293 | |||
| 2013-01-21 14:23 | dwuelfrath | Status | assigned => resolved | ||
| 2013-01-21 14:23 | dwuelfrath | Resolution | open => fixed | ||
| 2013-01-21 14:23 | dwuelfrath | Fixed in Version | => 3.6.1 | ||
| 2013-01-21 14:56 | dwuelfrath | Target Version | +1 => +0 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||