Warning and errors: class.jetpack-json-api-sync-endpoint.php and an error

Warnings and errors seem to be related to these activities by Jetpack which occur THOUSANDS of times a day!

Recent Activity
Time:	2 mins ago -- Tue, 28 Jul 20 10:34:06 -0700 -- 1595957646.960247 in Unixtime
Secs since last hit:	4628.3857
URL:	 ... /xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1595957641&nonce=bH3VajEQK4&body-hash=6g%2BIiSLpGLbV23uM5u5M1kdXuyY%3D&signature=EsDPmx4py4bqxiBENtyj%2BdUr%2Bs0%3D
Type:	Normal request
Referrer:	 ... /xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1595957641&nonce=bH3VajEQK4&body-hash=6g%2BIiSLpGLbV23uM5u5M1kdXuyY%3D&signature=EsDPmx4py4bqxiBENtyj%2BdUr%2Bs0%3D
Full Browser ID:	Jetpack by WordPress.com
Location:	 Los Angeles, California, United States
Time:	1 hour 19 mins ago -- Tue, 28 Jul 20 09:16:58 -0700 -- 1595953018.574561 in Unixtime
Secs since last hit:	750.9447
URL:	 ... /xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1595953012&nonce=VfvHjSDaG1&body-hash=6g%2BIiSLpGLbV23uM5u5M1kdXuyY%3D&signature=tqShM03tI0FwlMH89SLgwVcxEJA%3D
Type:	Normal request
Referrer:	 ... /xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1595953012&nonce=VfvHjSDaG1&body-hash=6g%2BIiSLpGLbV23uM5u5M1kdXuyY%3D&signature=tqShM03tI0FwlMH89SLgwVcxEJA%3D
Full Browser ID:	Jetpack by WordPress.com
Location:	 Los Angeles, California, United States

Hey there – What is the site URL? If you’d like to share that privately you can do it over https://jetpack.com/contact-support/?rel=support

On our site every time we activate Jetpack it causes fatal errors:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/vhosts/thegreydoor.co.uk/httpdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php on line 433
There has been a critical error on your website.

@lizkarkoski

When my site gets this request:

Recent Activity

Time: 7 mins ago — Fri, 31 Jul 20 19:02:39 -0700 — 1596247359.047956 in Unixtime
Secs since last hit: 14.9256

URL:
https://example.com/xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1596247353&nonce=cS59ifyZln&body-hash=H8wQPGCbAm9vkA6odu807KxTW7Y%3D&signature=k4bt62XhRTJr0QX%2F1WnCpKZhWvU%3D

Type: Normal request
Referrer:
https://example.com/xmlrpc.php?for=jetpack&token=%26qSrUC%25%26%2ALz2fZn%25LsVUsqhhs%40S1T%5E3Y%3A1%3A1×tamp=1596247353&nonce=cS59ifyZln&body-hash=H8wQPGCbAm9vkA6odu807KxTW7Y%3D&signature=k4bt62XhRTJr0QX%2F1WnCpKZhWvU%3D

Full Browser ID: Jetpack by WordPress.com
Location: Richardson, Texas, United States

_________________________________________________

The following is posted on my server’s PHP error log:

[31-Jul-2020 19:02:25 America/Los_Angeles] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 for query SELECT option_name AS id, option_value AS value
FROM fig_options
WHERE option_name IN (  ) 

_________________________________________________

That happens in line 653 of … \wp-content\plugins\jetpack\vendor\automattic\jetpack-sync\src\class-queue.php

$query_with_placeholders = "SELECT option_name AS id, option_value AS value
FROM $wpdb->options
WHERE option_name IN ( <strong>$ids_placeholders</strong> )";

Reason of the error: $ids_placeholders is null

2020-07-31 19:02:25 (Line 653) jetpack $ids_placeholders =

________________________________________________

The following is also posted on my server’s PHP error log:

[31-Jul-2020 19:02:40 America/Los_Angeles] PHP Warning:  <strong>substr</strong>() expects parameter 1 to be string, array given in ... \wp-content\plugins\jetpack\json-endpoints\jetpack\class.jetpack-json-api-sync-endpoint.php on line 364

if ( substr( <strong>$item</strong>, 0, 5 ) !== 'jpsq_' ) {
return null;
}

Reason of the error: item is an array, instead of an expected string

2020-07-31 19:02:40 (Line 363) $item = Array
(
    [concurrent_request_error] => Array
        (
            [0] => There is another request running for the same blog ID
        )

)

_______________________________________________

These lines occur hundreds of time a day filling my error log file, every time Jetpack servers make a xmlrpc.php?for=jetpack&token= request

I hope this information is forwarded to the right person to fix this bug!

HFigarella – What is the URL of your site? I don’t see it in that last message.

jamethyst – Please open a new thread so we can help you there.

Kristin S. (Automattic)

Aug 3, 2020, 4:50 PM UTC

Thanks for letting us know. Have you tried deleting and reinstalling Jetpack? It looks like there is an error in the SQL database that might be cleared up by a fresh reinstall, which would remove any old database entries if there's a corrupt file somewhere.

We have a step-by-step guide with screenshots here:

https://jetpack.com/support/reconnecting-reinstalling-jetpack/#reinstalling-jetpack

You’ve also reached support for customers of our premium products. We recently restructured support so that we now only provide direct email support for those with paid upgrades. We now provide support for the free plugin in the Jetpack Support Forums Jetpack is open source software and this allows the community to benefit from the answers to everyone's questions.

With that, I’m going to close this ticket. If you need more help after this, please make a post on the community forums. Many of our team members help out there as well.

Thank you for using Jetpack and WordPress and being part of the open source community.

Best,

Kristin S. - Happiness Engineer
WordPress.com | Jetpack | Akismet | VaultPress | Gravatar | WooCommerce

Yes, the plugin used to have a button to report bugs. I used it, but I never got a solution.

Now, after being kicked out for not being a “paid upgrades” customer, let us continue looking for a solution of this annoying bug.

I followed the instructions to delete jetpack from my server, and reinstalled it.

That made NO difference!

My PHP error log fills with hundreds of lines repeating the same thing:

ERROR 1

substr() expects parameter 1 to be string, array given in ... \jetpack\json-endpoints\jetpack\class.jetpack-json-api-sync-endpoint.php on line 363

And the reason for that is because in line 363

if ( substr( $item, 0, 5 ) !== 'jpsq_' ) {
return null;
}

the value of $item is not a string, but an array with this value:

$item = Array
(
    [concurrent_request_error] => Array
        (
            [0] => There is another request running for the same blog ID
        )

)

That line repeats over and over in my PHP error log all day, everyday.

I am hoping the issue is forwarded to a developer of this plugin who would understand the issue and provide a solution where:

$item is NOT an array with value “There is another request running for the same blog ID”

My PHP error log fills with hundreds of lines repeating the same thing:

ERROR 2

You have an error in your SQL syntax; near ')' at line 3 for query 
SELECT option_name AS id, option_value AS value
FROM xxx_options
WHERE option_name IN (  ) 
				
made by wp_xmlrpc_server->serve_request, IXR_Server->IXR_Server, IXR_Server->__construct, IXR_Server->serve, IXR_Server->call, IXR_Server->multiCall, IXR_Server->call, Jetpack_XMLRPC_Server->json_api, WPCOM_JSON_API->serve, WPCOM_JSON_API->process_request, Jetpack_JSON_API_Endpoint->callback, Jetpack_JSON_API_Sync_Close_Endpoint->result, Automattic\Jetpack\Sync\Queue->peek_by_id, Automattic\Jetpack\Sync\Queue->fetch_items_by_id

That happens in line 653 of … \wp-content\plugins\jetpack\vendor\automattic\jetpack-sync\src\class-queue.php

$query_with_placeholders = "SELECT option_name AS id, option_value AS value
FROM $wpdb->options
WHERE option_name IN ( $ids_placeholders )";

Reason of this error: $ids_placeholders is null

$ids_placeholders =

That line also repeats over and over in my PHP error log all day, everyday.

I am hoping the issue is forwarded to a developer of this plugin who would understand the issue and provide a solution where:

$ids_placeholders is NOT null, or the line is not executed IF it is, or find the reason it has no value.

I am supposed to use this plugin, and report bugs, not debug it!

It has been a month since I first reported these 2 bugs and no solution.

Is Jetpack too busy with those with paid upgrades? Or is Jetpack support this bad over all?

@lizkarkoski

Please let me know how I can share with you privately.

I do not see it in https://jetpack.com/contact-support/?rel=support

Bugs are filed on Github, and I am happy to assist with that. In order to proceed further and take an in depth look at the site’s connection we need to know the URL of the affected site. I’ve re read this thread a few times and I don’t see it listed. I’m sorry if I overlooked it, please share the affected site URL with us here.

@lizkarkoski

I am not writing my URL here. Should I try support on Github?

I would love to share my private information with you, but not with every bot scanning this page.

Hi @hfigarella,

It seems that you have already opened a GitHub issue and our developers are working on a fix. You will be notified of any updates directly in the GH thread.

@fresatomica

yes, actually @lizkarkoski pointed me to the right direction.

After 1 month here with nothing, filing the bug myself in GitHub, produced a commitment in less than 6 hours!

Now I now where not to go, and where to go for bugs.

This ticket can now be closed. Thanks for your time

Thanks for the update, @hfigarella. Be safe and stay well.