Dear all,
Trying add a piece of media. When I click on New Media, the resulting form has no drop-down for the
Media Type attribute (see screenshot attached). This attribute is marked as compulsory. If I try to
submit the form anyway, I get the error below.
This selection box is missing whether there are 0, 1 or more active Media Types listed under Publishing.
Can anyone help, please?
Ian
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" [for Statement "
SELECT a.id, a.name, a.key_name, a.description, a.top_level, a.paginated, a.fixed_uri,
a.related_story, a.related_media, a.media, a.displayed, a.biz_class__id, a.type__id, a.active, m.grp__id
FROM element_type a, member m, element_type_member etm
WHERE a.id = etm.object_id AND etm.member__id = m.id AND m.active = '1' AND a.id = ?
ORDER BY a.name, a.id
" with ParamValues: 1=''] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN3> line 74.
Error Details (hide)
Fault Class
Bric::Util::Fault::Exception::DA
Description
Data Access Exception
Timestamp
2011-05-27 11:00:57.000000
Package
Bric::Util::DBI
Filename
/usr/local/bricolage/lib/Bric/Util/DBI.pm
Line
1139
Stack:
Trace begun at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1139
Bric::Util::DBI::execute('DBI::st=HASH(0xbc372b70)', '') called at
/usr/local/bricolage/lib/Bric/Biz/ElementType.pm line 2264
Bric::Biz::ElementType::_do_list('Bric::Biz::ElementType', 'HASH(0xba5af170)') called at
/usr/local/bricolage/lib/Bric/Biz/ElementType.pm line 418
Bric::Biz::ElementType::lookup('Bric::Biz::ElementType', 'HASH(0xba5af170)') called at
/usr/local/bricolage/lib/Bric/App/Callback/Profile/Media.pm line 523
Bric::App::Callback::Profile::Media::create('Bric::App::Callback::Profile::Media=HASH(0xbc1bedc8)')
called at /usr/share/perl5/Params/CallbackRequest.pm line 296
eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
Params::CallbackRequest::request('Params::CallbackRequest=HASH(0xb9c5cc08)', 'HASH(0xba062ba0)',
'requester', 'MasonX::Interp::WithCallbacks=HASH(0xba5a99b0)', 'apache_req',
'Apache2::Request=SCALAR(0xba8a2990)') called at /usr/share/perl5/MasonX/Interp/WithCallbacks.pm
line 119
MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0xba5a99b0)',
'comp', '/workflow/profile/media/new/1058', 'args', 'ARRAY(0xbc1bf158)', 'ah',
'HTML::Mason::ApacheHandler=HASH(0xba5a41f0)', 'apache_req', 'Apache2::Request=SCALAR(0xba8a2990)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 874
eval {...} at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 873
HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0xba5a41f0)',
'Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm
line 828
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xba5a41f0)',
'Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at /usr/local/bricolage/lib/Bric/App/Handler.pm
line 308
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 297
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at -e line 0
eval {...} at -e line 0
Trying add a piece of media. When I click on New Media, the resulting form has no drop-down for the
Media Type attribute (see screenshot attached). This attribute is marked as compulsory. If I try to
submit the form anyway, I get the error below.
This selection box is missing whether there are 0, 1 or more active Media Types listed under Publishing.
Can anyone help, please?
Ian
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" [for Statement "
SELECT a.id, a.name, a.key_name, a.description, a.top_level, a.paginated, a.fixed_uri,
a.related_story, a.related_media, a.media, a.displayed, a.biz_class__id, a.type__id, a.active, m.grp__id
FROM element_type a, member m, element_type_member etm
WHERE a.id = etm.object_id AND etm.member__id = m.id AND m.active = '1' AND a.id = ?
ORDER BY a.name, a.id
" with ParamValues: 1=''] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN3> line 74.
Error Details (hide)
Fault Class
Bric::Util::Fault::Exception::DA
Description
Data Access Exception
Timestamp
2011-05-27 11:00:57.000000
Package
Bric::Util::DBI
Filename
/usr/local/bricolage/lib/Bric/Util/DBI.pm
Line
1139
Stack:
Trace begun at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1139
Bric::Util::DBI::execute('DBI::st=HASH(0xbc372b70)', '') called at
/usr/local/bricolage/lib/Bric/Biz/ElementType.pm line 2264
Bric::Biz::ElementType::_do_list('Bric::Biz::ElementType', 'HASH(0xba5af170)') called at
/usr/local/bricolage/lib/Bric/Biz/ElementType.pm line 418
Bric::Biz::ElementType::lookup('Bric::Biz::ElementType', 'HASH(0xba5af170)') called at
/usr/local/bricolage/lib/Bric/App/Callback/Profile/Media.pm line 523
Bric::App::Callback::Profile::Media::create('Bric::App::Callback::Profile::Media=HASH(0xbc1bedc8)')
called at /usr/share/perl5/Params/CallbackRequest.pm line 296
eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
Params::CallbackRequest::request('Params::CallbackRequest=HASH(0xb9c5cc08)', 'HASH(0xba062ba0)',
'requester', 'MasonX::Interp::WithCallbacks=HASH(0xba5a99b0)', 'apache_req',
'Apache2::Request=SCALAR(0xba8a2990)') called at /usr/share/perl5/MasonX/Interp/WithCallbacks.pm
line 119
MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0xba5a99b0)',
'comp', '/workflow/profile/media/new/1058', 'args', 'ARRAY(0xbc1bf158)', 'ah',
'HTML::Mason::ApacheHandler=HASH(0xba5a41f0)', 'apache_req', 'Apache2::Request=SCALAR(0xba8a2990)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 874
eval {...} at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 873
HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0xba5a41f0)',
'Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm
line 828
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xba5a41f0)',
'Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at /usr/local/bricolage/lib/Bric/App/Handler.pm
line 308
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 297
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0xbc3ba4f0)') called at -e line 0
eval {...} at -e line 0