Salesforce API Names & Field Maps

PHP ERROR LOGS

[01-May-2021 12:35:20 UTC] WordPress database error Table 'pantheon.wp_object_sync_sf_field_map' doesn't exist for query SELECTid,label,wordpress_object,salesforce_object,salesforce_record_types_allowed,salesforce_record_type_default,fields,pull_trigger_field,sync_triggers,push_async,push_drafts,pull_to_drafts,weight,version`
FROM wp_object_sync_sf_field_map made by require_once(‘wp-admin/admin.php’), do_action(‘settings_page_object-sync-salesforce-admin’), WP_Hook->do_action, WP_Hook->apply_filters, Object_Sync_Sf_Admin->show_admin_page, Object_Sync_Sf_Mapping->get_fieldmaps`

As a note, I’ve added the field ‘push_drafts’ to the table but it still is throwing errors.

[01-May-2021 15:07:05 UTC] WordPress database error Unknown column <strong>'pull_to_drafts'</strong> in 'field list' for query SELECTid,label,wordpress_object,salesforce_object,salesforce_record_types_allowed,salesforce_record_type_default,fields,pull_trigger_field,sync_triggers,push_async,push_drafts,pull_to_drafts,weight,versionFROM wp_object_sync_sf_field_map made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Object_Sync_Sf_Salesforce_Push->add_actions, Object_Sync_Sf_Mapping->get_fieldmaps

However, the field ‘pull_to_drafts’ does exist in the table wp_object_sync_sf_field_map

Okay, did some more testing. I turned off the ‘Process asynchronously’ setting for the field mapping, made an update in Salesforce, and voila! Record syncd as expected. I’ve had this issue occur on another project as well.

@fortafy am I reading correctly that you see error logs about the missing pull_to_drafts field, which does exist in your table, until you turn off the asynchronous setting and then everything works fine? This is very odd, so I want to make sure I’m understanding it correctly.

I’ve only done basic testing with this plugin on Pantheon, in one of their test environments, so I’m not very familiar with how they do things but my understanding is that folks have used this plugin there.

@jonathanstegall Thanks for responding. We finally worked through all the issues and I believe we’re up and running. Effectively, here are the things that occurred:
1. Upon install the wp_object_sync_sf_field_map table was not created
2. We manually created the wp_object_sync_sf_field_map table from your documentation but pull_to_drafts was a missing field from the mysql statement
3. We manually created the pull_to_drafts field
4. We deselected ‘Process asynchronously’ and finally it started working

Thanks again for responding. We use your plugin quite a bit. Time to donate!

@fortafy I’m still kind of curious about what might be happening.

1. It’s odd that this still happens on Pantheon, at least in some cases.
2. The code you mentioned in your first post – at https://github.com/MinnPost/object-sync-for-salesforce/blob/master/docs/troubleshooting-unable-to-create-database-tables.md – does have the pull_to_drafts field, but you mention here that you didn’t get that field in your table when you created it. Is there other documentation that needs to be updated?
3. Fair
4. This also makes me nervous. If it doesn’t work asynchronously, are you able to pull data from Salesforce into WordPress or are you only able to push data from WordPress to Salesforce? If there’s a problem with scheduling, have you tried installing the WP CronTrol plugin? We have a little bit of documentation on this here: https://github.com/MinnPost/object-sync-for-salesforce/blob/master/docs/troubleshooting.md#a-successfully-created-fieldmap-does-not-pass-data

MinnPost of course always appreciates donations!

@fortafy just realizing that one of the things you mentioned in your original post was a bug, and that it should be fixed as of today. The issue “6. when trying to create fieldmaps it doesn’t appear to show me the salesforce api names — but it will display the Field Labels.” should be working correctly now, whether you use API names or Field labels.

This doesn’t answer the remaining questions, but I wanted to note that that part is different.

I’d be fine with reopening this if it turns out there’s more info that reveals an issue in Pantheon, or a broader issue, but I’m going to mark this as resolved for now.