Can’t create Fieldmap

  • Resolved jaybuys

    (@jaybuys)


    7 years, 1 month ago

    Just testing out this plugin as I think several of my clients could benefit from it. I got things setup and authorized in Salesforce but when I try to create a fieldmap, it doesn’t work. The page refreshes and I the notice-error bar but the message inside is blank… so it’s throwing an error and not letting me proceed but it won’t show me what the error is.

    I’ve tried different WP and Salesforce objects and fields but it always does the same thing. I’ve enabled debugging and logging but that didn’t seem to do anything either. Any idea what I’m doing wrong here?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Jonathan Stegall

    (@jonathanstegall)

    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.

    Thread Starter jaybuys

    (@jaybuys)

    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 – https://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

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    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?

    Thread Starter jaybuys

    (@jaybuys)

    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.

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    Okay, great. I’ll consider this one resolved for now, then. If we encounter the issue again we’ll investigate further.

    wpelvis

    (@wpelvis)

    this is the same problem as mine.
    can we give you some server details to help work out why?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Can’t create Fieldmap’ is closed to new replies.