1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

Lockrow in joined lists

Discussion in 'Community' started by Debi, Mar 27, 2019.

Thread Status:
Not open for further replies.
  1. Debi

    Debi Member

    Level: Community
    I have lockrow plugins in a joined list.
    It nearly works, but in a kind of back to front manner!

    The owner of an unlocked row receives the correct message when opening a form to edit ("This record is being locked for your use. Nobody else can edit this record till you submit it. The record will stay locked for 60 minutes. If you don't submit within that time, the record will become unlocked and editable others, and you will no longer be able to submit this form").

    The locked padlock icon shows in the list view, for other users.

    A second user also receives the correct message when opening the same "locked" form / row id. ("This record is locked by another user, you cannot edit it").

    But, if the second user ignores the warning message, and saves the edited form, the form is submitted successfully, with the success message.
    And when the original owner subsequently submits the open form, they receive the "Record locking is enabled on this data, but your submitted form does not have the correct lock token, so your form has not been submitted. Please contact the administrators. Sorry, but you are not authorised to edit this record" message.

    When returning to the list view, the second user now owns the form (and can unlock the form with the padlock icon). And the locked padlock is displayed in the list view of original owner.

    The plugin works as it is expected to in lists without joins.

    Is there anyway to correct this?

    Thank you
     
  2. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    I never tried it with joins. No idea what might be going on.

    Is your 'lockrow' element on the main table, or the joined table?

    -- hugh
     
  3. Debi

    Debi Member

    Level: Community
    Yes. The lockrow is in the main table.
     
  4. Debi

    Debi Member

    Level: Community
    Hi.
    As an update, it turned out I had a group in the main table set to read only.
    Setting it to shown has fixed this particular issue.
    There are other issues that I'm working through,
     
  5. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    OK, but I can stop worrying about the issue in this thread, right?

    -- hugh
     
  6. Debi

    Debi Member

    Level: Community
    Right!
    Thanks Hugh
     
  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    You can close solved threads by unchecking "open" in Thread Tools.
     
Thread Status:
Not open for further replies.

Share This Page