Title: fresh install errors Last modified: November 9, 2017 --- # fresh install errors * Resolved [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 5 months ago](https://wordpress.org/support/topic/fresh-install-errors/) * I have a fresh install of WordPress and Woocommerce. I switched this plugin on and got the following: * WordPress database error: [Table ‘site_wp.wooshop_object_sync_sf_field_map’ doesn’t exist] 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 wooshop_object_sync_sf_field_map * The plugin generated 1113 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin. Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * (@jonathanstegall) * [8 years, 5 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9667426) * [@wpelvis](https://wordpress.org/support/users/wpelvis/) it sounds like this plugin is unable to create the database tables it requires. It will not work if it is unable to do this. You might want to try deactivating it and activating it again; it will always try to create the tables upon activation. * But if your server does not allow database tables to be created, it won’t work. * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9717791) * I’ve tried switching off/on, reinstalling, complete new install in different directory, same error. It has successfully made the table wooshop_object_sync_sf_object_map and all the woo tables so not sure why this particular one has a problem. Can i make it manually? * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9718039) * I manually created the table as another user did, so this got rid of the error. However I do not have the tabs in the settings page. I then switched off and on again, and now get the error again. * I have latest WP, only WC and this plugin installed, using sample WC data. * WC version: 3.2.5 WP version: 4.9 Server info: Apache PHP version: 7.0.25 PHP post max size: 8 MB PHP time limit: 30 PHP max input vars: 1000 SUHOSIN installed:– MySQL version: 5.6.38 Max upload size: 2 MB * Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * (@jonathanstegall) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9721591) * [@wpelvis](https://wordpress.org/support/users/wpelvis/) if you deactivate the plugin, it will delete the tables. I believe your server may be able to delete tables but not create them. * If you create the database tables but do not have the tabs, it is because the plugin has not been authorized with Salesforce. * That is what it sounds like is happening, to me. - This reply was modified 8 years, 4 months ago by [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/). * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9736659) * Hi, thanks for reply. It is making the other table xx_object_sync_sf_object_map but not this one. * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9736802) * it is also making the tables for Woocommerce. * Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * (@jonathanstegall) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9737788) * [@wpelvis](https://wordpress.org/support/users/wpelvis/) you can certainly make both tables manually. I would do that. * In other words: * 1. Deactivate the Salesforce plugin (to make sure nothing is lingering) 2. Create the database tables manually. You can use this SQL to do that: * table one: * ``` CREATE TABLE wooshop_object_sync_sf_field_map ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, label varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', name varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', wordpress_object varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', salesforce_object varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', salesforce_record_types_allowed longblob, salesforce_record_type_default varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', fields text COLLATE utf8mb4_unicode_520_ci NOT NULL, pull_trigger_field varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'LastModifiedDate', sync_triggers text COLLATE utf8mb4_unicode_520_ci NOT NULL, push_async tinyint(1) NOT NULL DEFAULT '0', push_drafts tinyint(1) NOT NULL DEFAULT '0', weight tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (id), UNIQUE KEY name (name), KEY name_sf_type_wordpress_type (wordpress_object,salesforce_object) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; ``` * table two: * ``` CREATE TABLE wooshop_object_sync_sf_object_map ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, wordpress_id varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL, salesforce_id varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', wordpress_object varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', object_updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_sync datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_sync_action varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, last_sync_status tinyint(1) NOT NULL DEFAULT '0', last_sync_message varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY salesforce (salesforce_id), UNIQUE KEY salesforce_wordpress (wordpress_object,wordpress_id), KEY wordpress_object (wordpress_object,wordpress_id), KEY salesforce_object (salesforce_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; ``` * If wooshop_ is not your table prefix, of course update it to whatever it is. * 3. Activate the Salesforce plugin. You won’t see any tabs except for the Settings tab at this stage. 4. Fill in the settings. After the required settings are all there, you should see additional tabs. 5. In the Authorize tab, click the Connect to Salesforce button. * If you can do that, you should be able to work with the plugin. * If you are totally unable to create one or more database tables following this order, I would ask your web host for support. * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9748628) * i did a complete reinstall, new db and site. I am now able to install the plugin without errors, but am running into problems saving Fieldmaps. The error is coming up in server log: “WordPress database error Table ‘calmzone_wp1.jkl_object_sync_sf_field_map’ doesn’t exist for query …” * So like your other user, the database has the “object_sync_sf_object_map” table but not the field map one. * Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * (@jonathanstegall) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9748681) * [@wpelvis](https://wordpress.org/support/users/wpelvis/) * Hi. Again, if you are able to manually create the tables before activating this plugin, I believe it will work. If you are unable to do that step, as I described in the previous comment ([https://wordpress.org/support/topic/fresh-install-errors/#post-9737788](https://wordpress.org/support/topic/fresh-install-errors/#post-9737788)) I’m not able to be of further help. I would recommend contacting your server host. * Thanks. * Thread Starter [wpelvis](https://wordpress.org/support/users/wpelvis/) * (@wpelvis) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9749151) * I notice that when you give me the code to manually add the table it uses ENGINE =InnoDB * However, when the plugin does make the object-map table, it uses MyISAM (the same as the rest of my db). * If I manually make the field-map table using MyISAM, it gives me an error. (# 1071 – Specified key was too long; max key length is 1000 bytes) * if I add ENGINE=InnoDB to the plugin SQL, they are both created successfully. * Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * (@jonathanstegall) * [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9749223) * [@wpelvis](https://wordpress.org/support/users/wpelvis/) ah, I see. That’s an interesting point. I expect we can release a plugin update in the near future that fixes this for MyISAM users. Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘fresh install errors’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/object-sync-for-salesforce.svg) * [Object Sync for Salesforce](https://wordpress.org/plugins/object-sync-for-salesforce/) * [Frequently Asked Questions](https://wordpress.org/plugins/object-sync-for-salesforce/#faq) * [Support Threads](https://wordpress.org/support/plugin/object-sync-for-salesforce/) * [Active Topics](https://wordpress.org/support/plugin/object-sync-for-salesforce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/object-sync-for-salesforce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/object-sync-for-salesforce/reviews/) ## Tags * [db](https://wordpress.org/support/topic-tag/db/) * [tables](https://wordpress.org/support/topic-tag/tables/) * 11 replies * 2 participants * Last reply from: [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/) * Last activity: [8 years, 4 months ago](https://wordpress.org/support/topic/fresh-install-errors/#post-9749223) * Status: resolved