• Resolved happyferret

    (@happyferret)


    I set the plugin up and everything seemed to be working, but then I noticed that some of the entries were missing from the drive file.

    I didn’t see any errors in plugins log file, so I added some of my own logging lines to the plugin. It seems that google sheet service throws quota exceeded error sometimes, I guess because the connected API service account is used on all plugin instances.

    (
    [ERROR_MSG] => {
    "error": {
    "code": 429,
    "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
    "errors": [
    {
    "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
    "domain": "global",
    "reason": "rateLimitExceeded"
    }
    ],
    "status": "RESOURCE_EXHAUSTED",
    "details": [
    {
    "@type": "type.googleapis.com/google.rpc.ErrorInfo",
    "reason": "RATE_LIMIT_EXCEEDED",
    "domain": "googleapis.com",
    "metadata": {
    "service": "sheets.googleapis.com",
    "quota_limit": "ReadRequestsPerMinutePerProject",
    "consumer": "projects/1075324102277",
    "quota_metric": "sheets.googleapis.com/read_requests",
    "quota_limit_value": "300",
    "quota_location": "global"
    }
    },
    {
    "@type": "type.googleapis.com/google.rpc.Help",
    "links": [
    {
    "description": "Request a higher quota limit.",
    "url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
    }
    ]
    }
    ]
    }
    }

    [TRACE_STK] => #0 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Http/REST.php(107): Google\Http\REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
    #1 [internal function]: Google\Http\REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
    #2 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Task/Runner.php(187): call_user_func_array(Array, Array)
    #3 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Http/REST.php(66): Google\Task\Runner->run()
    #4 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Client.php(915): Google\Http\REST::execute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...', Array, NULL)
    #5 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/src/Service/Resource.php(238): Google\Client->execute(Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
    #6 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/vendor/google/apiclient-services/src/Sheets/Resource/SpreadsheetsValues.php(240): Google\Service\Resource->call('get', Array, 'Google\\Service\\...')
    #7 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/lib/google-sheets.php(186): Google\Service\Sheets\Resource\SpreadsheetsValues->get('17YMGJOOEympn50...', 'Lehe Hindamine ...')
    #8 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/class-gf-gsheetgravityforms.php(880): Gfgsc_googlesheet->add_row(Array)
    #9 htdocs/wp-content/plugins/gsheetconnector-gravity-forms/class-gf-gsheetgravityforms.php(815): Gforms_Gsheet_Connector->send_entry('17YMGJOOEympn50...', 'Hindamise p\xC3\xA4ri...', '688186784', 'Lehe Hindamine', Array, Array)
    #10 htdocs/wp-includes/class-wp-hook.php(310): Gforms_Gsheet_Connector->after_submission(Array, Array)
    #11 htdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array)
    #12 htdocs/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #13 htdocs/wp-content/plugins/gravityforms/gravityforms.php(6606): do_action('gform_after_sub...', Array, Array, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
    #14 htdocs/wp-content/plugins/gravityforms/form_display.php(169): gf_do_action('gform_after_sub...', Array, Array)
    #15 htdocs/wp-content/plugins/gravityforms/gravityforms.php(760): GFFormDisplay::process_form(3)
    #16 htdocs/wp-includes/class-wp-hook.php(308): GFForms::maybe_process_form(Object(WP))
    #17 htdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
    #18 htdocs/wp-includes/plugin.php(565): WP_Hook->do_action(Array)
    #19 htdocs/wp-includes/class-wp.php(797): do_action_ref_array('wp', Array)
    #20 htdocs/wp-includes/functions.php(1332): WP->main('')
    #21 htdocs/wp-blog-header.php(16): wp()
    #22 htdocs/index.php(17): require('/data02/virt128...')
    #23 {main}
    )

    Is this a excepted way it is supposed to work on the free plugin?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Some form quries are not sent to google sheet file’ is closed to new replies.