// Add your reply above here
==================================================
Nick Legg updated this ticket at April 25th, 2011 @ 05:12 PM
Steps to reproduce:
1. Get a template that creates subelements. (The old image_resize_and_relate, for example.)
2. From the story profile, trigger a preview, which should create one or more subelements in the current story. Note that these subelements will not appear in the UI, because there's no mechanism for updating it if something happens during preview.
3. Attempt a save or a save and stay. You'll see the error:
Unable to execute SQL statement: DBD::Pg::st execute failed: ERROR: null value in column "displayed" violates not-null constraint [.for Statement "\n UPDATE story_element\n SET element_type__id = ?, object_instance_id = ?, parent_id = ?, place = ?, object_order = ?, displayed = ?, related_story__id = ?, related_media__id = ?, active = ?\n WHERE id = ?\n " with ParamValues: 1='1251', 2='161646', 3='1763407', 4='0', 5='0', 6=undef, 7=undef, 8='54763', 9='0', 10='1763420'] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN4> line 1070.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/255-sql-error-regarding-undefined-display-field
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/255-sql-error-regarding-undefined-display-field/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Nick Legg updated this ticket at April 25th, 2011 @ 05:12 PM
Steps to reproduce:
1. Get a template that creates subelements. (The old image_resize_and_relate, for example.)
2. From the story profile, trigger a preview, which should create one or more subelements in the current story. Note that these subelements will not appear in the UI, because there's no mechanism for updating it if something happens during preview.
3. Attempt a save or a save and stay. You'll see the error:
Unable to execute SQL statement: DBD::Pg::st execute failed: ERROR: null value in column "displayed" violates not-null constraint [.for Statement "\n UPDATE story_element\n SET element_type__id = ?, object_instance_id = ?, parent_id = ?, place = ?, object_order = ?, displayed = ?, related_story__id = ?, related_media__id = ?, active = ?\n WHERE id = ?\n " with ParamValues: 1='1251', 2='161646', 3='1763407', 4='0', 5='0', 6=undef, 7=undef, 8='54763', 9='0', 10='1763420'] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN4> line 1070.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/255-sql-error-regarding-undefined-display-field
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/255-sql-error-regarding-undefined-display-field/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com