wpelvis

i’ve worked round it by using a string replace of the output in a
‘display_posts_shortcode_wrapper_open’ filter.

thanks for very useful plugin!

about 18,000 products.

Thanks.
As some were a bit complex (including doing a query on the SF to get IDs) I have created some meta fields on the order items, and put the relevant values in on post creation.
These then link directly to the SF fields.

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.

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.

it is also making the tables for Woocommerce.

Hi, thanks for reply.
It is making the other table xx_object_sync_sf_object_map but not this one.

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

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

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?

i contacted my host to up all the limits and now it works.
I don’t think modifying it in wp-config works on my server.
thanks for reply.

just found the php inherited was 5, so updated to 7.1

not get the memory time out error in
/wp-includes/pomo/mo.php on line 272

This is still a problem for me.

Here is last bit of the log

[May 26 13:06:26] Requesting max memory
[May 26 13:06:26] Setting up error handling environment
[May 26 13:06:26] Setting up scanRunning and starting scan
[May 26 13:06:26] Got a true deserialized value back from ‘wfsd_engine’ with type: object
[May 26 13:06:26] Scanning contents: wp-content/uploads/2014/07/wolf6-1024×683.jpg (Size:64349B Mem:153.2M)
[May 26 13:06:26] Resuming malware scan at rule G2160/rules#1.
[May 26 13:06:26] Scanned contents of 17949 additional files at 1.87 per second
[May 26 13:06:26] Scanning contents: wp-content/uploads/2016/01/Disappointman_Hero-768×384.jpg (Size:45388B Mem:154.5M)
[May 26 13:06:26] Scanning contents: wp-content/uploads/2013/11/sergei-yolkin-internet-addiction-2011-300×164.jpeg (Size:8133B Mem:154.5M)
[May 26 13:06:26] Scanning contents: wp-content/uploads/2013/04/Attachment-spring13-300×201.jpg (Size:5402B Mem:154.5M)
[May 26 13:06:26] Scanning contents: wp-content/uploads/2015/04/sgp-logo-on-white-150×150.jpg (Size:10377B Mem:154.5M)
[May 26 13:06:26] Scanning contents: wp-content/themes/CALMV2/assets/fonts/Quicksand_Light_Oblique-webfont.svg (Size:73674B Mem:154.5M)
[May 26 13:06:27] ——————-
[May 26 13:06:27] Scan interrupted. Scanned 47420 files, 41 plugins, 2 themes, 1524 pages, 1431 comments and 1477240 records in 3 hours 1 second.
[May 26 13:06:33] Calling Wordfence API v2.23:https://noc1.wordfence.com/v2.23/?v=4.7.5&s=https%3A%2F%2Fwww.thecalmzone.net&k=f42e17151eea786deacca9521e41c33e35969f18fcc7e4e323daa1c083527a01689d95a2789fbff26e09883c09572254d239488eb282e3fcf695a9c08fec480a21263cf5dc07ef60d63fe04e2ef7a1d7&openssl=268443839&phpv=5.3.29&betaFeed=0&cacheType=disabled&action=record_scan_metrics
[May 26 13:06:34] Wordfence used 120.19MB of memory for scan. Server peak memory usage was: 254.83MB
[May 26 13:06:34] Scan terminated with error: The scan time limit of 3 hours has been exceeded and the scan will be terminated. This limit can be customized on the options page. Get More Information
[May 26 13:06:34] ob_end_flush() [ref.outcontrol]: failed to delete buffer zlib output compression (8) File: /home/savethemale/public_html/wp-includes/functions.php Line: 3720
[May 26 13:06:34] Scan process ended after forking.
[May 26 13:06:34] ob_end_flush() [ref.outcontrol]: failed to delete buffer zlib output compression (8) File: /home/savethemale/public_html/wp-includes/functions.php Line: 3720
[May 26 13:06:34] Scan process ended after forking.
[May 26 13:06:34] ob_end_flush() [ref.outcontrol]: failed to delete buffer zlib output compression (8) File: /home/savethemale/public_html/wp-includes/functions.php Line: 3720

and yes upgrading the PHP was on my ‘todo’ list already but it is a large site and the theme is customised so I need to check it first.

I turned off all scans one by one and i couldn’t get it to work.

Also as soon as it was turned on, without scanning, it affected my Posts Edit page (blank screen) and Sucuri.