Support » Plugin: Jetpack - WP Security, Backup, Speed, & Growth » Warning and errors: class.jetpack-json-api-sync-endpoint.php and an error

  • Resolved Plugin user

    (@hfigarella)


    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 <support@jetpack.com>
    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 <support@jetpack.com>
    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 to see the link]

Viewing 15 replies - 1 through 15 (of 15 total)
  • Thread Starter Plugin user

    (@hfigarella)

    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

    (@lizkarkoski)

    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.

    Thread Starter Plugin user

    (@hfigarella)

    @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!

    Plugin Support lizkarkoski

    (@lizkarkoski)

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

    Plugin Support lizkarkoski

    (@lizkarkoski)

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

    Thread Starter Plugin user

    (@hfigarella)

    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

    (@hfigarella)

    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

    (@hfigarella)

    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

    (@hfigarella)

    @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

    Plugin Support lizkarkoski

    (@lizkarkoski)

    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

    (@hfigarella)

    @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

    (@fresatomica)

    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.

    Thread Starter Plugin user

    (@hfigarella)

    @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

    Plugin Support lizkarkoski

    (@lizkarkoski)

    Thanks for the update, @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.