When an entity is saved, if it could be referenced by an indexed entity a lookup query is executed to find its parents. When the saved entity is referenced via an entity_revision_reference based field like the billing_profile field of the commerce_order entity (
Commerce Core →
), the request fails because the property path used as a condition is billing_profile.entity whereas the entity property is not available. Note that this only happens with an entity base field not with a field added via the field API.
The exception raised:
Drupal\Core\Entity\Query\QueryException while attempting to find indexed entities referencing changed Profile with ID "1" for index Orders: 'billing_profile' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 375 of /var/www/html/web/core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).
commerce_order moduleCurrent behaviour: an error is triggered
Expected behaviour: the order index item is updated.
For the lookup query, we could probably replace entity_field.entity with entity_field.target_id to support entity revision reference base fields while it would still support default entity reference fields.
Closed: duplicate
1.0
General code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Thanks for reporting this problem, and sorry for the immense delay before replying. In the meantime, I’m afraid I already replied to a duplicate of this ticket, so please see there: 🐛 QueryException while attempting to find indexed entities referencing changed Profile Needs review .