Hi Gustaf,
Indeed! Strictly by the book!
For the record, references are:
1. https://openacs.org/doc/acs-content-repository/
2. https://openacs.org/doc/acs-content-repository/guide/revisions
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
<joke> arrggg! Almost a deadlock kind of thing!!! rsrsrs :) </joke>
Please, correct me if my logic is wrong.
Best wishes,
