admin at designo
Nov 24, 2009, 4:10 AM
Post #1 of 5
(1160 views)
Permalink
|
|
Unable to execute SQL statement | group_concat(integer) does not exist
|
|
Hi,
i've upgraded Bricolage from 1.10.2 > 1.10.7 > 1.11.2 (Pg/Apache2 on Debian Lenny)
Logged in it shows me this error:
---------------------------------------------
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: function group_concat(integer) does not exist
LINE 2: ...ver_date, i.note, i.checked_out, e.biz_class__id, group_conc...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. [for Statement "
SELECT mt.id, mt.uuid, mt.element_type__id, mt.priority, mt.source__id, mt.current_version, mt.published_version, mt.usr__id, mt.first_publish_date, mt.publish_date, mt.expire_date, mt.workflow__id, mt.desk__id, mt.publish_status, mt.active, mt.site__id, mt.alias_id, i.id,i.name, i.description, i.media__id, i.usr__id, i.version, i.media_type__id, i.primary_oc__id, i.category__id, i.file_size, i.file_name, i.location, i.uri, i.cover_date, i.note, i.checked_out, e.biz_class__id, group_concat( DISTINCT m.grp__id ), group_concat( DISTINCT c.asset_grp_id ), group_concat( DISTINCT w.asset_grp_id )
FROM media_instance i, media_member mm, member m, element_type e, category c, workflow w,media mt
WHERE mt.id = i.media__id AND mm.object_id = mt.id AND m.id = mm.member__id AND m.active = '1' AND c.id = i.category__id AND e.id = mt.element_type__id AND mt.workflow__id = w.id AND mt.current_version = i.version AND mt.active = ? AND i.checked_out = ? AND i.usr__id = ?
GROUP BY mt.id, mt.uuid, mt.element_type__id, mt.priority, mt.source__id, mt.current_version, mt.published_version, mt.usr__id, mt.first_publish_date, mt.publish_date, mt.expire_date, mt.workflow__id, mt.desk__id, mt.publish_status, mt.active, mt.site__id, mt.alias_id, i.id,i.name, i.description, i.media__id, i.usr__id, i.version, i.media_type__id, i.primary_oc__id, i.category__id, i.file_size, i.file_name, i.location, i.uri, i.cover_date, i.note, i.checked_out, e.biz_class__id
ORDER BY i.cover_date, mt.id
" with ParamValues: 1='1', 2='1', 3='0'] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138.
Stack:
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1138]
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:758]
[/usr/local/bricolage/lib/Bric/Biz/Asset.pm:308]
[/usr/local/bricolage/comp/widgets/desk/desk.mc:51]
[/usr/local/bricolage/comp/workflow/profile/workspace/dhandler:10]
[/usr/local/bricolage/comp/autohandler:7]
Error Details (hide)
Fault Class
Bric::Util::Fault::Exception::DA
Description
Data Access Exception
Timestamp
2009-11-24 12:47:40.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(0x336f8e0)', 1, 1, 0) called at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 758
Bric::Util::DBI::fetch_objects('Bric::Biz::Asset::Business::Media', 'SCALAR(0x3363c58)', 'ARRAY(0x4ea9fe0)', 3, 'ARRAY(0x3365590)') called at /usr/local/bricolage/lib/Bric/Biz/Asset.pm line 308
Bric::Biz::Asset::list('Bric::Biz::Asset::Business::Media', 'HASH(0x4ea98c0)') called at /usr/local/bricolage/comp/widgets/desk/desk.mc line 51
HTML::Mason::Commands::__ANON__('story', undef, 0, 'HASH(0x336e218)', 'name') called at /usr/local/bricolage/comp/widgets/desk/desk.mc line 230
HTML::Mason::Commands::__ANON__('user_id', 0, 'class', 'story', 'sort_by', undef, 'offset', 0, 'show_all', undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x336be18)', 'user_id', 0, 'class', 'story', 'sort_by', undef, 'offset', 0, 'show_all', undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1284
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, 'user_id', 0, 'class', 'story', 'sort_by', undef, 'offset', 0, 'show_all', undef) called at /usr/local/bricolage/comp/workflow/profile/workspace/dhandler line 10
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4ae79f8)') called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1284
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 943
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x4e84a20)') called at /usr/local/bricolage/comp/autohandler line 7
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4a0b4c0)') called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1279
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 473
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 473
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x4e84a20)') called at /usr/local/share/perl/5.10.0/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x4e84a20)') called at /usr/local/share/perl/5.10.0/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x444d808)', 'Apache2::RequestRec=SCALAR(0x4ece338)') called at /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x4ece338)') called at -e line 0
eval {...} at -e line 0
---------------------------------------------
Errors appear throughout the areas Stories, Media, Templates.
System, Publishing and Distribution seem to work.
Thanks in advance for your ideas
Regards
Guido
|
