Support › MB Relationships › Issue with Meta Box Relationships
- This topic has 7 replies, 5 voices, and was last updated 1 week, 6 days ago by
Michael Kramer.
-
AuthorPosts
-
September 10, 2023 at 3:36 AM #43195
[email protected]
ParticipantHello 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.
Issue:
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):
Plugin: meta-box-aio
Error Message: Unknown column 'mbr_reviews-services_to' in 'group statement'
Error Code: 1054Environment Details:
WordPress Version: 6.3.1
Active Theme: Bricks Builder
PHP Version: 8.0.30Any help or guidance on resolving this issue would be highly appreciated.
Thank you,
September 11, 2023 at 7:08 PM #43202Robert Bolker
ParticipantHello 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!
September 12, 2023 at 9:05 PM #43219Peter
ModeratorHello,
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.
September 12, 2023 at 9:48 PM #43221ParticipantThere's a conflict with Object Cache Pro. I disabled it and now relationships are being displayed. Is this a known conflict?
September 13, 2023 at 8:32 PM #43239ModeratorHello,
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.
September 13, 2023 at 9:39 PM #43245Kara
ParticipantI 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 BYmbr_orderASC, mbr_id DESCSeptember 13, 2023 at 11:32 PM #43246ParticipantNotes:
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.
https://objectcache.pro/docs/configuration-options/#non-persistent-groups
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.September 15, 2023 at 1:40 AM #43251Michael Kramer
ParticipantI 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
-
AuthorPosts
- You must be logged in to reply to this topic.