View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
1477RackTablesdefaultpublic2015-06-01 16:162015-06-11 04:55
Reportercabbiebatman Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionduplicate 
PlatformLinuxOSCentOSOS Version7
Product Version0.20.10 
Summary1477: Pdo exception: PDOException when changing row name
DescriptionWhen changing row name
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'has_problems' cannot be null (23000)

at file /var/www/html/racktables/inc/database.php, line 4003

/var/www/html/racktables/inc/database.php:4003 execute(Array
(
    [0] => LHY Row E
    [1] =>
    [2] =>
    [3] =>
    [4] =>
    [5] => 13
)
)
/var/www/html/racktables/inc/database.php:1011 usePreparedUpdateBlade('Object', Array
(
    [name] => Row E
    [label] =>
    [has_problems] =>
    [asset_no] =>
    [comment] =>
)
, Array
(
    [id] => 13
)
)
/var/www/html/racktables/inc/ophandlers.php:2400 commitUpdateObject('13', 'Row E', NULL, NULL, NULL, NULL)
updateRow()
/var/www/html/racktables/index.php:230 call_user_func('updateRow')

Error info:

Array
(
    [0] => 23000
    [1] => 1048
    [2] => Column 'has_problems' cannot be null
)

Parameters:
GET
module redirect
page row
tab edit
op updateRow
POST
row_id 13
location_id 7
name Row E
num_attrs 0
submit_x 22
submit_y 20
Steps To ReproduceRename any row
TagsNo tags attached.

Relationships

duplicate of 1457 closedadoom42 PDOException on Rack Row Updates 

Activities

cabbiebatman

cabbiebatman

2015-06-01 16:23

reporter   ~0002841

Found the same issue in ID 0001457 and solved with the information in the notes
    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);

Issue History

Date Modified Username Field Change
2015-06-01 16:16 cabbiebatman New Issue
2015-06-01 16:23 cabbiebatman Note Added: 0002841
2015-06-11 04:54 adoom42 Relationship added duplicate of 1457
2015-06-11 04:55 adoom42 Status new => closed
2015-06-11 04:55 adoom42 Resolution open => duplicate