View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010329 | mantisbt | upgrade | public | 2009-04-15 00:43 | 2009-06-23 15:28 |
| Reporter | durk | Assigned To | grangeway | ||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.2.0a3 | ||||
| Fixed in Version | 1.2.0rc1 | ||||
| Summary | 0010329: Receive duplicate key on upgrade from 1.1.6 to 1.2.0a3 if existing categories exist with a leading or tailing space | ||||
| Description | Receive duplicate key on upgrade from 1.1.6 to 1.2.0a3 if existing categories exist with a leading or tailing space | ||||
| Steps To Reproduce | Add multiple bugs in a 1.1.6 install with a category "fubar" and then " fubar" or "fubar ". When you run the upgrade script it will crash with duplicate key when it tries to insert the value twice. | ||||
| Additional Information | Fixed this for my installation by wrapping the column name 'category' in a trim function in the install_functions.php - eg: | ||||
| Tags | No tags attached. | ||||