View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1457 | RackTables | default | public | 2015-04-10 13:56 | 2015-08-09 22:06 |
| Reporter | racktabler | Assigned To | adoom42 | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.20.10 | ||||
| Target Version | 0.20.11 | Fixed in Version | 0.20.11 | ||
| Summary | 1457: PDOException on Rack Row Updates | ||||
| Description | Try to change Location of Rack Row ( Rackspace -> Manage Rows) gives me Pdo exception: PDOException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'has_problems' cannot be null (23000) at file racktables/wwwroot/inc/database.php, line 4003 racktables/wwwroot/inc/database.php:4003 execute(Array ( [0] => RoWB [1] => [2] => [3] => [4] => [5] => 5 ) ) racktables/wwwroot/inc/database.php:1011 usePreparedUpdateBlade('Object', Array ( [name] => RoWB [label] => [has_problems] => [asset_no] => [comment] => ) , Array ( [id] => 5 ) ) racktables/wwwroot/inc/ophandlers.php:2384 commitUpdateObject('5', 'RoWB', NULL, NULL, NULL, NULL) updateRow() racktables/wwwroot/index.php:230 call_user_func('updateRow') Error info: Array ( [0] => 23000 [1] => 1048 [2] => Column 'has_problems' cannot be null ) Parameters: GETmodule redirect page rackspace tab editrows op updateRow | ||||
| Steps To Reproduce | Change Location of Rack Row ( Rackspace -> Manage Rows) | ||||
| Additional Information | Could not reproduce on Live Demo. But on two newly installed systems. Fixed by changing the following in ophandlers.php in function updateRow() commitUpdateObject ($_REQUEST['row_id'], $_REQUEST['name'], NULL, NULL, NULL, NULL); to commitUpdateObject ($_REQUEST['row_id'], $_REQUEST['name'], NULL, 'no', NULL, NULL); | ||||
| Tags | No tags attached. | ||||
| has duplicate | 1477 | closed | Pdo exception: PDOException when changing row name |
 |
Look at this please: https://bugs.racktables.org/view.php?id=1417 Could this be the same problem? (strict SQL mode) |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-04-10 13:56 | racktabler | New Issue | |
| 2015-04-29 13:57 | tomium | Note Added: 0002815 | |
| 2015-06-11 04:54 | adoom42 | Relationship added | has duplicate 1477 |
| 2015-06-11 04:56 | adoom42 | Assigned To | => adoom42 |
| 2015-06-11 04:56 | adoom42 | Status | new => assigned |
| 2015-08-09 22:06 | adoom42 | Status | assigned => closed |
| 2015-08-09 22:06 | adoom42 | Resolution | open => fixed |
| 2015-08-09 22:06 | adoom42 | Fixed in Version | => 0.20.11 |
| 2015-08-09 22:06 | adoom42 | Target Version | => 0.20.11 |
