Issues with Pull and Push mapping after upgrading to Drupal 10

Created on 16 January 2024, 11 months ago
Updated 17 January 2024, 11 months ago

Problem/Motivation

Before upgrading to Drupal 10 it was working perfectly, after upgrading to drupal 10 where dynamic_entity_reference also needed to be updated it is giving me this error when I do pull and push.

I tried the 3 versions of dynamic_entity_rederence (3.0.0, 3.1.0 and 4.0.0-alpha3) but it still gives an error.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('dfa0e34cbbca4825973d313ec7213afe'@'%') does not exist: UPDATE "salesforce_mapped_object" SET "revision_id"=:db_update_placeholder_0, "drupal_entity__target_id"=:db_update_placeholder_1, "drupal_entity__target_type"=:db_update_placeholder_2, "salesforce_mapping"=:db_update_placeholder_3, "salesforce_id"=:db_update_placeholder_4, "created"=:db_update_placeholder_5, "changed"=:db_update_placeholder_6, "entity_updated"=:db_update_placeholder_7, "last_sync_status"=:db_update_placeholder_8, "last_sync_action"=:db_update_placeholder_9, "force_pull"=:db_update_placeholder_10 WHERE "id" = :db_condition_placeholder_0; Array ( [:db_update_placeholder_0] => 100613 [:db_update_placeholder_1] => 20778 [:db_update_placeholder_2] => user [:db_update_placeholder_3] => member [:db_update_placeholder_4] => 0030900000w4Np6AAE [:db_update_placeholder_5] => 1652796013 [:db_update_placeholder_6] => 1705444059 [:db_update_placeholder_7] => 1691543082 [:db_update_placeholder_8] => 1 [:db_update_placeholder_9] => pull [:db_update_placeholder_10] => 0 [:db_condition_placeholder_0] => 1 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->doSaveFieldItems() (line 914 of /app/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

It is similar to the error reported for another version of Salesforce https://www.drupal.org/project/salesforce/issues/3104110 πŸ› Excessive duplication of Drupal content if Mapped Object creation fails Closed: outdated

Also in status report, I get the error Salesforce Mapped Object The Mapped Entity field needs to be updated.
I tried with devel entity update but it doesn't allow me because there are values in the tables to modify

πŸ› Bug report
Status

Active

Version

5.0

Component

salesforce_mapping.module

Created by

πŸ‡ͺπŸ‡¨Ecuador cacrody

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024