Title: Warning and errors: class.jetpack-json-api-sync-endpoint.php and an error Last modified: July 28, 2020 --- # Warning and errors: class.jetpack-json-api-sync-endpoint.php and an error * Resolved [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/) * This will show in my php error log thousands of times a day, every day! * ``` [28-Jul-2020 00:09:00 America/Los_Angeles] PHP Warning: substr() 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 363 [28-Jul-2020 00:09:00 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 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 ``` * Using and updating frequently as they are published: * Jetpack Bleeding Edge | 8.8-alpha-1004-g1d61a4fe8 Wordpress 5.5-beta4-48649 PHP 7.4.8 MySQL Version: 8.0.21 * Warnings and errors seem to be related to these activities by Jetpack which occur THOUSANDS of times a day! * This issue was reported as a bug a month ago and all I got was this: * ``` From: Jetpack Support Sent: Wednesday, July 8, 2020 10:01 AM To: Horacio Subject: [Jetpack] [Jetpack] BETA! I am getting thousands of error lines in my error log about Jetpack_IXR_Client ##- Please type your reply above this line -## Jen H. (Automattic) Jul 8, 2020, 5:01 PM UTC Hey Horacio, Apologies for the delay in following up with you on this. We're working through a bit of a backlog. I am getting thousands of error lines in my error log Can you please update to the most recent version of the Jetpack bleeding edge? This was an issue that should have been sorted in 8.7. Let us know if that sorts it for you. Best, Jen H. Happiness Engineer: Automattic, Inc. This is part of request 3112894. This email is a service from Automattic. ``` * and this * ``` From: Jetpack Support Sent: Monday, July 20, 2020 11:41 AM To: Horacio Subject: [Jetpack] [Jetpack] BETA! I am getting thousands of error lines in my error log about Jetpack_IXR_Client ##- Please type your reply above this line -## Tracy (Automattic) Jul 20, 2020, 6:41 PM UTC Hi Horacio, Thanks for keeping us in the loop here. Have you tried to simply delete the Bleeding Edge plugin and reinstall? We're not seeing any of those errors here, which makes me wonder if it's something on your site or with the update for you that just got borked somewhere. Let us know how that goes :) Best, Tracy — Happiness Engineer @ Automattic, Inc. Want to learn more about Jetpack? Check out learn.jetpack.com This is part of request 3112894. This email is a service from Automattic. ``` * Did I miss the part saying that the Jetpack plugin is updated Many times a day? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwarning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 1 through 15 (of 15 total) * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13182074) * 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 ``` * Plugin Support [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * (@lizkarkoski) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13182830) * 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](https://jetpack.com/contact-support/?rel=support) * [jamethyst](https://wordpress.org/support/users/jamethyst/) * (@jamethyst) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13184365) * 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. * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13197297) * [@lizkarkoski](https://wordpress.org/support/users/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 ( $ids_placeholders )"; ``` * **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: substr() 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( $item, 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! * Plugin Support [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * (@lizkarkoski) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13205436) * HFigarella – What is the URL of your site? I don’t see it in that last message. * Plugin Support [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * (@lizkarkoski) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13205439) * jamethyst – Please open a new thread so we can help you there. * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210637) * ``` 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! * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210638) * 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” * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210656) * 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? * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210667) * [@lizkarkoski](https://wordpress.org/support/users/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](https://jetpack.com/contact-support/?rel=support) * Plugin Support [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * (@lizkarkoski) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210684) * 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. * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13210701) * [@lizkarkoski](https://wordpress.org/support/users/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. * Plugin Support [fresatomica](https://wordpress.org/support/users/fresatomica/) * (@fresatomica) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13211483) * Hi [@hfigarella](https://wordpress.org/support/users/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. * Thread Starter [Plugin user](https://wordpress.org/support/users/hfigarella/) * (@hfigarella) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13214468) * [@fresatomica](https://wordpress.org/support/users/fresatomica/) * yes, actually [@lizkarkoski](https://wordpress.org/support/users/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 * Plugin Support [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * (@lizkarkoski) * [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13214529) * Thanks for the update, [@hfigarella](https://wordpress.org/support/users/hfigarella/). Be safe and stay well. Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Warning and errors: class.jetpack-json-api-sync-endpoint.php and an error’ is closed to new replies. * ![](https://ps.w.org/jetpack/assets/icon.svg?rev=2819237) * [Jetpack - WP Security, Backup, Speed, & Growth](https://wordpress.org/plugins/jetpack/) * [Frequently Asked Questions](https://wordpress.org/plugins/jetpack/#faq) * [Support Threads](https://wordpress.org/support/plugin/jetpack/) * [Active Topics](https://wordpress.org/support/plugin/jetpack/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/jetpack/unresolved/) * [Reviews](https://wordpress.org/support/plugin/jetpack/reviews/) ## Tags * [log](https://wordpress.org/support/topic-tag/log/) * 15 replies * 4 participants * Last reply from: [lizkarkoski](https://wordpress.org/support/users/lizkarkoski/) * Last activity: [5 years, 10 months ago](https://wordpress.org/support/topic/warning-and-errors-class-jetpack-json-api-sync-endpoint-php-and-an-error/#post-13214529) * Status: resolved