- π¨π¦Canada iStryker
Marking all 7.x as out of dated. If problem persist, then only a new issue.
Recently I have noticed captions I pull in through Views 7.x.3.15 are empty. When putting the query in PHPMyAdmin, the value for the captions are NULL.
Here is an example query below:
SELECT field_image_field_image_field_caption.caption AS field_image_field_image_field_caption_caption, node.created AS node_created
FROM
{node} node
LEFT JOIN {field_data_field_image} field_data_field_image ON node.nid = field_data_field_image.entity_id AND (field_data_field_image.entity_type = 'node' AND field_data_field_image.deleted = '0')
LEFT JOIN {field_image_field_caption} field_image_field_image_field_caption ON field_data_field_image.entity_id = field_image_field_image_field_caption.entity_id AND field_data_field_image.delta = field_image_field_image_field_caption.delta AND (field_image_field_image_field_caption.entity_type = 'node' AND field_image_field_image_field_caption.field_name = '0')
WHERE (( (node.status = '1') AND (node.type IN ('story')) ))
ORDER BY node_created DESC
LIMIT 5 OFFSET 0
In the example above, I bolded the left join condition that I think is problematic. With the condition checking for the value '0' instead of the field machine name, it returns NULL values for captions. If I replace '0' with 'field_image' (the field machine name), it works.
Any ideas why this is happening?
I am on core 7.54
Thanks!
Closed: outdated
2.1
Miscellaneous
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Marking all 7.x as out of dated. If problem persist, then only a new issue.