Support Forum
Support › MB Relationships › Relationships suddenly stopped working
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 BYmbr_order
ASC, mbr_id DESCWordPress 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 BYmbr_order
ASC, mbr_id DESC
This is true of all relationships across the site.
Things on the backend appear fine.
Thank you.
Note: Using Meta Box AIO version 1.23.0 (throwing errors)
The previous working version was 1.22.0
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/
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.