When you say you’ve enabled logging, are you saying it doesn’t create any log entries for you at all?
When you go to the Add New fieldmap screen, are you saying the screen is blank? Like there is no list of fields for you to fill out?
I’d like to know how far you are able to get in the process, basically.
Thanks.
Definitely not seeing a blank screen. As I said, I fill out the entire field map form and submit it. It just shows me a blank error. Here’s a screenshot that might help – http://oi64.tinypic.com/34htc3s.jpg – It shows what I filled out and the empty error message at the top.
I’m not sure where the plugin stores it’s log files… but I just found the error below in the main server error log which is definitely at least part of the problem. It looks like the database table the plugin is trying to use isn’t there. I’m assuming that should’ve been created during plugin activation? I tried deactivating and reactivating the plugin but that didn’t help.
[17-Oct-2017 16:49:21 UTC] WordPress database error Table ‘wpsandbo_wordpress.wp_object_sync_sf_field_map’ doesn’t exist for query SELECT id, label, wordpress_object, salesforce_object, salesforce_record_types_allowed, salesforce_record_type_default, fields, pull_trigger_field, sync_triggers, push_async, push_drafts, weight FROM wp_object_sync_sf_field_map made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/object-sync-for-salesforce/object-sync-for-salesforce.php’), Object_Sync_Salesforce::get_instance, Object_Sync_Salesforce->__construct, Object_Sync_Salesforce->push, Object_Sync_Sf_Salesforce_Push->__construct, Object_Sync_Sf_Salesforce_Push->add_actions, Object_Sync_Sf_Mapping->get_fieldmaps
Thanks, that is helpful. You are correct, the plugin should create two tables when it is activated. It does this on all the server environments where we’ve tested it, at least. That certainly is the issue you’re encountering.
Do you have other plugins installed that are able to successfully create their own tables? If so, which ones?
Yes… This is just a sandbox site so I have a bunch of other plugins that are creating their own tables (Gravity Forms, Redirection, Yoast SEO, etc.)
I looked in the database with phpMyAdmin and I do see that the wp_object_sync_sf_object_map table was created, just not the wp_object_sync_sf_field_map table. Very strange that one would be created but not the other. I have no idea why.
I found the DB code in activate.php and used it to create the table manually. Appears to work now. I just successfully added a fieldmap so I’ll continue to play around with the plugin now that I got past that issue. Thanks for your help.
Okay, great. I’ll consider this one resolved for now, then. If we encounter the issue again we’ll investigate further.
this is the same problem as mine.
can we give you some server details to help work out why?
