mygrove

Yes, I thought it would be ‘Lightspeed Cache’ which I have deactivated, but it has not resolved the problem. So I then deactivated them all and re-activated them one by one to find the culprit.

Turns out it is “All in one SEO”, so I’ll find an alternative to that as it does not appear to have any settings to accommodate OSM.

Thanks.

Thank you, this goes a little way but I still cannot see a setting that allows you to hide specific fields in the [pdb-single]. I want the fields, I just don’t want the front end to display them.

A little more investigation suggests the latest update of the plugin to 1.2.22 has caused the problem.

Thank you. Is there an example somewhere of this sort of nested templates?

Yes, I’ve seen the video(s).

I can show one author with books beneath, but cannot create a working page that lists all authors with books sorted by publication_date. This was where I started.

What I am trying to achieve is a page that lists the bookauthors and then under each author the books sorted by publication_date.

So I assume I need a page with some code / shortcut that refers to the templates we have created?

OK, how do you display the output? Presumably you need to set up a page?

OK, I have set this up. What do you put in your page format to get the output?

I have changed @id to @ID and removed orderby=”publication_date ASC”

Neither has made any difference.

Could I ask you to post what you have for the template(s), Pods and fields, the output page configuration and your data so I can check it line by line with one that works?

Thanks.

• This reply was modified 3 years, 12 months ago by mygrove.

The relationship field in bookauthor is related_book.

In my page I now have:

<ul>
[pods name=”bookauthor” where=”related_book.ID = '{@id}'” orderby=”publication_date ASC” template=”book_li”]
[/pods]
<ul>

Still blank.

Is that what you intended? I realised we don’t have [each] ... [/each] in there at all now?

Yes, it’s bi-directional.

I have tried both

[pods name=”bookauthor” where=”related_book.ID = '{@id}'” orderby=”publication_date ASC” template=”book_li”]

and

[pods name=”bookauthor” where=”related_book.ID = '{@id}'” orderby=”publication_date.meta_value ASC” template=”book_li”]

I have even simplified the template “book_li” to just contain:

{@post_title}

but the page remains resolutely blank!

Both options still give a blank page.

SELECT DISTINCT t.*
FROM wp_posts AS t
LEFT JOIN wp_podsrel AS rel_related_book
ON rel_related_book.field_id = 202
AND rel_related_book.item_id = t.ID
LEFT JOIN wp_posts AS related_book
ON related_book.ID = rel_related_book.related_item_id
LEFT JOIN wp_postmeta AS related_book_meta_value
ON related_book_meta_value.meta_key = ‘meta_value’
AND related_book_meta_value.post_id = related_book.ID
WHERE ( ( related_book.meta_value = ‘{@id}’ )
AND ( t.post_type = “bookauthor” )
AND ( t.post_status IN ( “publish” ) ) )
ORDER BY publication_date ASC, t.menu_order, t.post_title, t.post_date
LIMIT 0, 15

There is an error message:

Unknown column ‘related_book.meta_value’ in ‘where clause’

@keraweb

I had already added define('PODS_SHORTCODE_ALLOW_EVALUATE_TAGS',true);
to wp_config.php from your earlier comment, so there must still be something else wrong.

• This reply was modified 3 years, 12 months ago by mygrove.

Hi @keraweb

I have a template now called

book_li

that contains just

{@post_title}, {@publication_date}

I have also set up a page called “Authors book list” that contains:

[pods name=”bookauthor” where=”related_book.meta_value = ‘{@id}'” orderby=”publication_date ASC” template=”book_li”]

I just get a blank page, not even an error!

How do you list through the books by author without some sort of “each” instruction? If it is required, where does it need to go?

Perhaps you could advise what needs to be in the templates and a sample page format?