// Add your reply above here
==================================================
Michael Herring updated this ticket at February 27th, 2012 @ 09:28 PM
Step to reproduce:
1. perform a story->list on a particular story id when the story is already checked out
Here is the query that is generated during the call:
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 )
FROM story_instance i, site, story_member sm, member m, story__category sc, category c, workflow w, story s
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 s.site__id = site.id AND LOWER(site.name) LIKE LOWER($1) AND s.active = $2 AND s.id = $3 AND i.checked_out = $4
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
ORDER BY i.cover_date, s.id
parameters: $1 = 'Course Catalog', $2 = 't', $3 = '20719', $4 = 'f'
The problem seems to stem from the fact the query is looking at the story instance table to determine the checked out state instead of the story table. Remember that in the instance table there are two rows when a story is checked out.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/285-story-list-with-checked_out-parameter-f-returns-checked-out-stories
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/watching/5fb784134907752d1f1b8638ad7e3dede27538d1
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Michael Herring updated this ticket at February 27th, 2012 @ 09:28 PM
Step to reproduce:
1. perform a story->list on a particular story id when the story is already checked out
Here is the query that is generated during the call:
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 )
FROM story_instance i, site, story_member sm, member m, story__category sc, category c, workflow w, story s
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 s.site__id = site.id AND LOWER(site.name) LIKE LOWER($1) AND s.active = $2 AND s.id = $3 AND i.checked_out = $4
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
ORDER BY i.cover_date, s.id
parameters: $1 = 'Course Catalog', $2 = 't', $3 = '20719', $4 = 'f'
The problem seems to stem from the fact the query is looking at the story instance table to determine the checked out state instead of the story table. Remember that in the instance table there are two rows when a story is checked out.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/285-story-list-with-checked_out-parameter-f-returns-checked-out-stories
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/watching/5fb784134907752d1f1b8638ad7e3dede27538d1
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com