Bi-directional field ignores meta added manually via MySQL

  • Resolved thiagolamosa

    (@thiagolamosa)


    2 years, 8 months ago

    I have two CPTs:
    – Laws (2970 posts)
    – Authors (29 posts)

    In the begning I created a relational field only in Laws CPT and forgot to create a bi-directional field also in Authors.

    After creating a bi-directional field in Authors CPT I realized they were all empty in the Authors edit page (wodpress dashboard). To fix the empty newly created bi-directional field in Authors I tried to insert the data via MySQL but they are not showing up in the Authors edit page.

    I inserted the data in wp_postmeta with two meta_keys: {customfieldname} and _pods_{customfieldname}.

    Am I doing something wrong?

    • This topic was modified 2 years, 8 months ago by thiagolamosa.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter thiagolamosa

    (@thiagolamosa)

    MySQL insert example:
    INSERT INTO wp_postmeta (post_id,meta_key, meta_value) VALUES (‘3375′,’law’,’36331′);
    INSERT INTO wp_postmeta (post_id,meta_key, meta_value) VALUES (‘3375′,’law’,’36313′);
    INSERT INTO wp_postmeta (post_id,meta_key, meta_value) VALUES (‘3375′,’_pods_law’,’a:2:{i:0;s:5:”36331″;i:1;s:5:”36313″;}’);

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @thiagolamosa

    Pods uses the podsrel table for relationships primarily for performance.
    If you update through SQL you’ll also need to update this table.

    Cheers, Jory

    Thread Starter thiagolamosa

    (@thiagolamosa)

    THANKS A LOT!!!

    Plugin Author Jory Hogeveen

    (@keraweb)

    No problem!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Bi-directional field ignores meta added manually via MySQL’ is closed to new replies.