Issue¶

When you try to run "drush entup" to update the Saleforce mapped objects with the Dynamic Entity Reference module, you get this error:

General error: 1419: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable): DROP IF EXISTS salesforcemapped_object_der_update

Affected Applications/Limitations¶

Dynamic Entity Reference (DER) module, version 8.x-2.x uses MySQL triggers to update the entities but Acquia Cloud Platform has disabled the use of stored procedures, triggers, and MySQL functions in all environments.

This version doesn't work on the Platform if you have numeric IDs for the entities. It works fine with string IDs (ex: 'A123') as the triggers are not used for the update.

Resolution¶

Switch to Dynamic Entity Reference module, 8.x-1.x or newer.