Relationships suddenly stopped working

Support MB Relationships Relationships suddenly stopped working

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #43225
    KaraKara
    Participant

    I've had relationships set up in several places on this site for over a year.
    No edits have been made.

    They stopped working after the last MetaBox Update.

    Before (taken from a staging site from a backup):
    https://www.awesomescreenshot.com/image/42863203?key=513286e2f3e32af891c0e67018cb85c9

    Now, it returns this error on the front-end:

    WordPress database error: [Unknown column 'mbr_order' in 'order clause']
    SELECT wp_dgs8sn_posts.ID FROM wp_dgs8sn_posts INNER JOIN wp_dgs8sn_mb_relationships AS mbr ON (mbr.type = 'instructors-to-units' AND ((mbr.from = wp_dgs8sn_posts.ID AND mbr.to IN (5512)) OR (mbr.to = wp_dgs8sn_posts.ID AND mbr.from IN (5512)))) WHERE 1=1 AND ((wp_dgs8sn_posts.post_type = 'course_unit' AND (wp_dgs8sn_posts.post_status = 'publish' OR wp_dgs8sn_posts.post_status = 'private'))) GROUP BY mbr_from, mbr_to, wp_dgs8sn_posts.ID ORDER BY mbr_order ASC, mbr_id DESC

    WordPress database error: [Unknown column 'mbr_order' in 'order clause']
    SELECT wp_dgs8sn_posts.ID FROM wp_dgs8sn_posts INNER JOIN wp_dgs8sn_mb_relationships AS mbr ON (mbr.type = 'instructors-to-units' AND ((mbr.from = wp_dgs8sn_posts.ID AND mbr.to IN (5512)) OR (mbr.to = wp_dgs8sn_posts.ID AND mbr.from IN (5512)))) WHERE 1=1 AND ((wp_dgs8sn_posts.post_type = 'instructors' AND (wp_dgs8sn_posts.post_status = 'publish' OR wp_dgs8sn_posts.post_status = 'private'))) GROUP BY mbr_from, mbr_to, wp_dgs8sn_posts.ID ORDER BY mbr_order ASC, mbr_id DESC

    This is true of all relationships across the site.
    Things on the backend appear fine.

    Thank you.

    #43226
    KaraKara
    Participant

    Note: Using Meta Box AIO version 1.23.0 (throwing errors)

    The previous working version was 1.22.0

    #43241
    PeterPeter
    Moderator

    Hello,

    Maybe your issue is related to the Object Cache Pro plugin. Read more in this topic https://support.metabox.io/topic/issue-with-meta-box-relationships/

    #43244
    KaraKara
    Participant

    Ah yes - I am using Object Cache Pro.
    There were no issues up to now, as far as I know.

    We can close this and I'll follow along on the other thread.

    Thank you.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.