rolfm at denison
Jun 27, 2009, 4:19 PM
Post #2 of 12
(3486 views)
Permalink
|
Any thoughts on this?
Thanks,
Matt
On Jun 18, 2009, at 10:06 AM, Matt Rolf wrote:
> So I've been upgrading. System now runs, I have access to groups,
> elements permissions, etc. However, any time I try to get to a
> screen with stories, I get an error like this:
>
> [Thu Jun 18 14:00:40 2009] [error] [client 140.141.15.6] Unable to
> execute SQL statement: DBD::Pg::st execute failed: ERROR: function
> group_concat(integer) does not exist\nLINE 2: ..._id, i.slug,
> i.cover_date, i.note, i.checked_out, group_conc...
> \n ^
> \nHINT: No function matches the given name and argument types. You
> might need to add explicit type casts. [for Statement "\n
> SELECT s.id, s.uuid, s.priority, s.source__id, s.usr__id,
> s.element_type__id, s.first_publish_date, s.publish_date,
> s.expire_date, s.current_version, s.published_version,
> s.workflow__id, s.publish_status, s.primary_uri, s.active,
> s.desk__id, s.site__id, s.alias_id, i.id, i.name, i.description,
> i.story__id, i.version, i.usr__id, i.primary_oc__id, i.slug,
> i.cover_date, i.note, i.checked_out, group_concat( DISTINCT
> m.grp__id ), group_concat( DISTINCT c.asset_grp_id ),
> group_concat( DISTINCT w.asset_grp_id )\n FROM story_instance
> i, story_member sm, member m, story__category sc, category c,
> workflow w, story s , member m2, story_member sm2\n WHERE s.id
> = i.story__id AND sm.object_id = s.id AND m.id = sm.member__id AND
> m.active = '1' AND sc.story_instance__id = i.id AND c.id =
> sc.category__id AND s.workflow__id = w.id AND s.current_version =
> i.version AND i.checked_out = ( SELECT checked_out FROM
> story_instance WHERE version = i.version AND story__id = i.story__id
> ORDER BY checked_out DESC LIMIT 1 ) AND s.active = ? AND m2.grp__id
> = ? AND m2.active = '1' AND sm2.member__id = m2.id AND s.id =
> sm2.object_id\n GROUP BY s.id, s.uuid, s.priority,
> s.source__id, s.usr__id, s.element_type__id, s.first_publish_date,
> s.publish_date, s.expire_date, s.current_version,
> s.published_version, s.workflow__id, s.publish_status,
> s.primary_uri, s.active, s.desk__id, s.site__id, s.alias_id, i.id,
> i.name, i.description, i.story__id, i.version, i.usr__id,
> i.primary_oc__id, i.slug, i.cover_date, i.note, i.checked_out\n
> ORDER BY i.cover_date, s.id\n" with ParamValues: 1='1', 2='4054']
> at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1134.\n\nStack:\n
> [/usr/local/bricolage/lib/Bric/Util/DBI.pm:1134]\n [/usr/local/
> bricolage/lib/Bric/Util/DBI.pm:758]\n [/usr/local/bricolage/lib/
> Bric/Biz/Asset.pm:308]\n [/usr/local/bricolage/lib/Bric/Util/Grp.pm:
> 1356]\n [/usr/local/bricolage/lib/Bric/Biz/Workflow/Parts/Desk.pm:
> 935]\n [/usr/local/bricolage/lib/Bric/Biz/Workflow/Parts/Desk.pm:
> 957]\n [/usr/local/bricolage/comp/widgets/desk/desk.mc:44]\n [/usr/
> local/bricolage/comp/workflow/profile/desk/dhandler:12]\n [/usr/
> local/bricolage/comp/autohandler:7]\n, referer: http://wsbric1.cache.denison.edu/admin/profile/user/1029
>
>
> does this mean I need to run some scripts by hand like Scott did
> back here?
>
> http://www.gossamer-threads.com/lists/bricolage/devel/36191
>
> If so, maybe this is something that needs to be addressed in the
> upgrade scripts.
>
>
> Matt
|
