Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Bricolage: bugs

[Bricolage #285] story->list with checked_out parameter = 'f' returns checked out stories

 

 

Bricolage bugs RSS feed   Index | Next | Previous | View Threaded


no-reply at lighthouseapp

Feb 27, 2012, 1:27 PM

Post #1 of 3 (1271 views)
Permalink
[Bricolage #285] story->list with checked_out parameter = 'f' returns checked out stories

// 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 [at] lighthouseapp or http://help.lighthouseapp.com


no-reply at lighthouseapp

Feb 27, 2012, 1:28 PM

Post #2 of 3 (1201 views)
Permalink
[Bricolage #285] story->list with checked_out parameter = 'f' returns checked out stories [In reply to]

// Add your reply above here
==================================================
Michael Herring updated this ticket at February 27th, 2012 @ 09:29 PM
* Tag changed from "<span class="tag">2.0.1</span>" to "<span class="tag">search results</span>, <span class="tag">2.0.1</span>"

--------------------------------------------------------------------------------

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 [at] lighthouseapp or http://help.lighthouseapp.com


no-reply at lighthouseapp

Feb 27, 2012, 3:16 PM

Post #3 of 3 (1224 views)
Permalink
[Bricolage #285] story->list with checked_out parameter = 'f' returns checked out stories [In reply to]

// Add your reply above here
==================================================
theory updated this ticket at February 27th, 2012 @ 11:17 PM
* State changed from "new" to "invalid"
This is not a bug. "f" and "t" are not valid booleans. Pass 1 or 0.
--------------------------------------------------------------------------------

Assigned: Bugs (at bricolage)
State: invalid
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 [at] lighthouseapp or http://help.lighthouseapp.com

Bricolage bugs RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.