Forum OpenACS Development: Re: CR pkg: cr_items.live_revision X cr.items.publish_status

Hi Gustaf,

Indeed! Strictly by the book!

For the record, references are:

Still, it doesn't change the fact that if the cr_items.live_revision is assigned to a revision_id, then cr_items.publish_status must be equals to 'live'. (i.e. that's my assumption)

Otherwise, cr_items.live_revision would be null and cr_items.publish_status equals to any other status, but 'live'.

For instance let's say, portrait-user has revision_id equals to 1706, but its status is ready. That's inconsistent.

Whether cr.publish_status should be 'live' or cr.live_revision should be null.

1704 | 1700 | portrait-of-user-1700 | | 1706 | 1706 | ready | image | file | CR_FILES

Again, based on the assumption that if live_revision is not null then this item must be live. If it's not live then live_revision must be null

arrggg! Almost a deadlock kind of thing!!! rsrsrs :)

Please, correct me if my logic is wrong.

Best wishes,

Your assumption is wrong. There is no coupling between the publish_status of the item and the actual revision.