Problem/Motivation

When run drush command 'drush salesforce_mapping:purge-drupal'

There is an error,

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm.drupal_entity__target_id_int' in 'on clause': SELECT "m"."id" AS "id"
FROM
{salesforce_mapped_object} "m"
LEFT JOIN {node} "et" ON et.nid = m.drupal_entity__target_id_int
WHERE ("drupal_entity__target_type" = :db_condition_placeholder_0) AND ("et"."nid" IS NULL); Array
(
[:db_condition_placeholder_0] => node
)

Steps to reproduce

Run drush command drush salesforce_mapping:purge-drupal
And then chose one or all Salesforce mapping.

Proposed resolution

N/A

Remaining tasks

N/A

User interface changes

N/A

API changes

N/A

Data model changes

likely.

CommentFileSizeAuthor
#2 salesforce-purge_bug-3244516.patch896 bytesAaronBauman
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Mingsong created an issue. See original summary.

AaronBauman’s picture

Status: Active » Needs review
FileSize
896 bytes

This should fix it

Mingsong’s picture

Title: Unknown column 'm.drupal_entity__target_id_int' with drush command salesforce_mapping:purge-drupal d » Unknown column 'm.drupal_entity__target_id_int' with drush command salesforce_mapping:purge-drupal
Mingsong’s picture

Status: Needs review » Reviewed & tested by the community

The patch works for my site.

Thanks.

  • AaronBauman committed bae985a on 5.0.x
    Issue #3244516 by AaronBauman: Unknown column 'm....
Mingsong’s picture

Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.