Closed OceanWind closed 2 years ago
I forgot to add one screenshot. Here's the More Fields section from the Edit Presenter page when it fails to load :
Hi @OceanWind
You cannot use the display field like you are doing now.
Only one field is possible and these aren't magic tags. Example:
t.post_title
or location_name.meta_value
Cheers, Jory
Description
Custom-post-type pod with bi-directional field to another custom post type, where a taxonomy field value is displayed will not load for editing. In my scenario, there are two custom post types:
The Presenters pod has a field "Events" that has a bi-directional field to the Events custom post type. The label for the Events field is set to display
{@post_title}: {@location_name}
. When I open the Presenters pod for editing, the following message appears in the bi-directional Events field and the rest of the Pod-defined fields do not load, meaning that the page hangs and does not finish loading. This did not happen before the recent update. Here's the message:Database Error; SQL: SELECT DISTINCT
t.
ID,
t.
post_title,
post_title.
meta_valueAS
post_title,
t.
post_type,
t.
menu_order,
t.
post_dateFROM
wp_yd6njn_postsAS
tWHERE ( (
t.
post_statusIN ( 'publish' ) ) AND (
t.
post_type= 'event' ) ) ORDER BY
t.
menu_order,
t.
post_title,
t.
post_dateLIMIT 0, 30; Response: Unknown column 'post_title.meta_value' in 'field list'
Version
2.8.8.1
Testing Instructions
Given an existing site (pre-recent updates) with two custom post types (Events & Presenters) linked by a bidirectional field and the label to connect to the Event from the Presenter pod set to display the post title and a related custom taxonomy value:
The above error is displayed.
Screenshots / Screencast
Possible Workaround
If I remove the taxonomy link from the label, the message disappears. In other words, set the label to simply "{@post_title}"
This does not work for us, since the Location is key to identifying the Event.
Site Health Information
Pods Package