leggn at denison
Apr 21, 2011, 1:21 PM
Views: 1446
Permalink
|
|
SQL error: invalid input syntax for type boolean
|
|
Bricoleurs,
Has anyone seen an error like the one below? The element_type__id =
1251 is our "Thumbnail" element which is essentially just a container
for a Related Media. I'm guessing, if I read this error correctly, the
problem is because some code somewhere is attempting to set "displayed"
to "" (empty string) where it should be a boolean. Any ideas?
Thanks,
Nick
[Thu Apr 21 18:47:45 2011] [error] [client 140.141.9.37] Unable to
execute SQL statement: DBD::Pg::st execute failed: ERROR: invalid input
syntax for type boolean: "" [.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='162196', 3='1773753',
4='0', 5='1', 6='', 7=undef, 8='54977', 9='1', 10='1773754'] at
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN128> line
19983.\n, referer:
https://freestyle.denison.edu/workflow/profile/story/24387
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1139]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2182]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1803]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2212]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1809]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2212]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1809]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2212]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1809]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2212]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1809]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:2212]
[/usr/local/bricolage/lib/Bric/Biz/Element/Container.pm:1809]
[/usr/local/bricolage/lib/Bric/Biz/Asset/Business.pm:2283]
[/usr/local/bricolage/lib/Bric/Biz/Asset/Business/Story.pm:1917]
[/usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm:196]
[/usr/local/share/perl5/Params/CallbackRequest.pm:296]
[/usr/local/share/perl5/MasonX/Interp/WithCallbacks.pm:119]
[/usr/local/share/perl5/HTML/Mason/ApacheHandler.pm:868]
[/usr/local/share/perl5/HTML/Mason/ApacheHandler.pm:822]
[/usr/local/bricolage/lib/Bric/App/Handler.pm:308]
[-e:0]
|
SQL error: invalid input syntax for type boolean
