Hello Meta Box Team,
I'm encountering a problem related to the relationships feature of the Meta Box plugin on my site. Despite configuring the relationships correctly, they're not displaying as expected on both the admin side and the front end.
The relationships fields have content, but they aren't visible in the Admin Column or on the website's frontend. The relationships are set up correctly and have been for a long time. This issue just happend with one of the recent updates but cannot pinpoint which one.
I even tried to reinstall a full backup and the issue persists.
Error Details (from Query Monitor):
Error Message: Unknown column 'mbr_reviews-services_to' in 'group statement'
Error Code: 1054
WordPress Version: 6.3.1
Active Theme: Bricks Builder
PHP Version: 8.0.30
Any help or guidance on resolving this issue would be highly appreciated.
Hello Meta Box Team,
I have the same environment as the above post and I'm experiencing the same issue.
Bricks Builder support is saying that it may have to do with Object Cache, but I disabled it and Relationships are still not displaying.
Appreciate any help you can provide here!
If the relationship is saved properly, please try to deactivate all plugins except Meta Box, MB extension plugins, switch to a standard theme of WordPress and recheck the connection in the admin column and frontend.
There's a conflict with Object Cache Pro. I disabled it and now relationships are being displayed. Is this a known conflict?
Maybe it's a conflicting issue. This is a premium plugin and we have not tested it before. You can also contact Object Cache Pro support and ask for more information. Just one note: the relationship data is saved in a custom table wp_mb_relationships.
I can also confirm a conflict with Object Cache Pro.
Disabling it fixed issues.
Error message, if helpful:
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 = 'course-products-to-instructors-woo' AND ((mbr.from = wp_dgs8sn_posts.ID AND mbr.to IN (2807)) OR (mbr.to = wp_dgs8sn_posts.ID AND mbr.from IN (2807)))) WHERE 1=1 AND ((wp_dgs8sn_posts.post_type = 'product' 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
I've tried editing the WP_REDIS_CONFIG to add the MB Relationships groups to the non-persistent groups, and also to the non-prefetchable groups. Neither made a difference.
I'm not well-versed with editing Object Cache Pro config, so used the Query Monitor plug into verify these changes were loading properly.
I used the groups found in /wp-admin > Settings > Object Cache > Tools > Groups
-- It's possible I haven't targeted the correct group, I suppose, although I targeted all groups that are seemingly related to the issue.
I am also having this exact issue. I am running a multisite thru Cloudways, and we don't have access to the OCP settings at all since it's a drop-in. They disabled it and my MB Relationship data was on the front end, but not having OCP is not really a solution. Is there anyone who has a fix for this? Is this something that will be patched in a subsequent update from Metabox? Bricks? OCP? I'm not even sure who to submit this to, so I intend to post on the Bricks forum as well, at least