@ijhana I think the first thing to check is whether you have an updated version of the database tables. I think the post you mention is older, so it’s possible it doesn’t have the correct SQL structure.
Here’s a page in the documentation where I try to keep the SQL up to date for troubleshooting. Check that first and make sure both tables have the correct structure, and then see if you are able to create a fieldmap.
If that does work, I probably need to update the FAQ here to make it more clear when the database tables aren’t created.
AG
(@amandagarceau)
Just FYI – I ran into this same issue, and when manually trying to add the table – it threw this error:
> “Index column size too large. The maximum column size is 767 bytes.
@amandagarceau what version of MySQL are you running? We may need to put a version constraint on the plugin.
Thread Starter
ijhana
(@ijhana)
I ran into the same issue. My hosting provider will not allow enabling innodb_large_prefix to fix the issues.
Any ideas how to address?
@ijhana that is beyond my database skill, but maybe we can add a check into the plugin for whether this feature is enabled on the server before people get this far into the installation. I’d certainly review pull requests with fixes as well, but we’re not likely (at MinnPost) to put work into that kind of compatibility for less capable hosts.
Thread Starter
ijhana
(@ijhana)
Any hosts you can recommend, we love your plugin and definitely want to use it.
Thread Starter
ijhana
(@ijhana)
@jonathanstegall I was able to move to a different hosting company, get the table updated and build my first Fieldmap. The Fieldmap is simple and is only mapping two fields. I want Saleforce to update WP on update, creating, deletion. I have tried several different options but when I update a record in salesforce the mapped field in WP is never updated. Any ideas on how to get this to work?
The authorization is set and on the SalesForce side and the SalesForce app is set to:
Selected OAuth Scopes
Access and manage your data (api)
Provide access to your data via the Web (web)
Full access (full)
Perform requests on your behalf at any time (refresh_token, offline_access)
I can email you screen shots or send you a login.
Thanks in advance for your help. If all works out please let us know how to donate to the project.
@ijhana I think you’re asking for support beyond what we can offer, but I can give you some suggestions from the documentation (we do have a troubleshooting document in the plugin’s documentation). If it doesn’t work, you may want to hire a WordPress developer to do this for you (I’m not personally available for this kind of work at this time).
1. The plugin cannot update records that aren’t already mapped to each other. In other words, if you are mapping WordPress users and Salesforce Contacts (for example), and then you update a Salesforce contact, it won’t update the WordPress user if they weren’t already connected.
2. Make sure you have PHP error logs and see if they say anything.
3. Plugin configuration
– Remember to clear the plugin cache on the Fieldmaps screen.
– If you are not able to push data to Salesforce, try with asynchronous checked, and without. This will tell you if your issue is related to the plugin’s cron jobs.
– To inspect your cron jobs, one good choice is the WP Crontrol plugin. Make sure the Salesforce push and/or pull jobs are running as you expect them to, and make sure to check the Schedule screen to make sure the jobs are scheduled as they should be.
4. Plugin logs
– Make sure to use the Log Settings screen to configure logs. Once enabled, they are added to a custom post type called Logs in the WordPress menu.
– If the plugin tries to create or update data, but WordPress or Salesforce encounter errors, the plugin will try to create a log entry. If you see entries, review the title and content of each.
5. Plugin mapping errors
– If the plugin fails in the middle of creating a map between two objects, a row may be created on the Mapping Errors screen.
– If it is a pull error, it will tell you the Salesforce ID. You should not leave these entries.
