Forums › Forums › Search & Filter Pro › How can I get titles from ACF post object field? (instead of IDs)

Tagged: 

Viewing 10 posts - 31 through 40 (of 47 total)
1 2 3 4 5
  • Ross Moderator
    (Private)  June 24, 2020 at 11:40 am #249895
    This reply has been marked as private.
    Anonymous
    (Private)  June 24, 2020 at 5:56 pm #249978
    This reply has been marked as private.
    Anonymous
    (Private)  June 24, 2020 at 5:57 pm #249980
    This reply has been marked as private.
    Anonymous
    (Private)  June 24, 2020 at 5:58 pm #249982
    This reply has been marked as private.
    Ross Moderator
    (Private)  June 25, 2020 at 8:54 am #250012
    This reply has been marked as private.
    Anonymous
    (Private)  June 25, 2020 at 7:25 pm #250136
    This reply has been marked as private.
    Ross Moderator
    (Private)  June 30, 2020 at 11:49 am #250623
    This reply has been marked as private.
    Anonymous
    (Private)  July 14, 2020 at 1:56 am #252718

    Hi Ross,

    I checked database for serialized data that is showing up in S&F instructor dropdown: found in
    search_filter_terms_results table
    search_filter_cache table

    also searched post_meta, filtering by meta_key: instructor. Most records are serialized – though some are blank, and a few are just the post id.

    I edited the serialized records in both S&F tables to just leave the post ID,
    results: no weird entries in the drop down, but not names either.

    Then rebuilt cache to see if they re-appear in either S&F table. Results are: they are back – rewritten into the database!

    From this I assume since most records in post_meta are serialized, when I rebuild the cache it uses those and rewrites it into the data.

    —

    Do I need to rewrite all the serialized entries in post_meta for this to work?
    There are over 2400 records that match that, and some have 2 or more IDs associated, like this:
    a:4:{i:0;s:4:”1193″;i:1;s:5:”82240″;i:2;s:4:”1204″;i:3;s:4:”1221″;}

    The other problem with that method is, this data is updated daily from an external source via cron job. So it will likely be overwritten.

    Further thoughts on how to resolve this?

    Thanks in advance.
    Marc

    Ross Moderator
    (Private)  July 14, 2020 at 9:02 am #252742

    Ah shame, I really thought this was what was causing the issue….

    Ok I think the next step is for me to setup your site locally so I can do some proper debugging – you’ve provided sftp details before – am I ok to pull your website files and setup a copy of your site locally?

    Thanks

    Anonymous
    (Private)  July 14, 2020 at 4:24 pm #252785

    Yes, please proceed.

  • Author
    Posts
Viewing 10 posts - 31 through 40 (of 47 total)
1 2 3 4 5