Error 403 on Google Spreadsheet Save action

V!

V!ncent 06 Dec, 2017

Hello,
After configuration as described in "How do I use the Google Spreadsheet Save action?", When testing the form, I have a 403 error.
Does anyone have an idea of what's going on?

V!ncent

Gr

GreyHead 07 Dec, 2017

Hi Vincent.

I can't tell much from the info here - what is the URL that shows the 403 error?

Bob

V!

V!ncent 07 Dec, 2017

Hello Bob,

It's when I test my form.
Here is the URL (which I get simply by clicking on "Test form" of Chronoform), you can try it, it's in test phase:

https://www.lymphotoulouse.org/congres/index.php?option=com_chronoforms5&chronoform=TestInscriptionAuto

The following page is in error 403.
I do not have this if I change the action of the form by a record in the DB for example.

V!ncent

Gr

GreyHead 07 Dec, 2017

Hi V!ncent,

I have no clear idea what the problem is - I suspect a server security setting.

Do you get the same response with all forms or just with this one?

Bob

V!

V!ncent 07 Dec, 2017

Hi Bob,

I only have this problem with this form there, ... and only when I try a Google Spreadsheet Save action.
his same form does not pose any problem if I want to save for example in the database.

V!ncent

Gr

GreyHead 07 Dec, 2017

Hi V!ncent,

Are you using the standard GSheet Save action or my [GH] version - I'm not sure that the standard one works any longer as Google made some changes. Please see this FAQ which has a linkt o download the [GH] version.

Bob

V!

V!ncent 07 Dec, 2017

Hi Bob,

Yes, I used your [GH] version, and I helped myself with this FAQ that you quote.
I created the folder / components / com_chronoforms5 / extras / Google / where I transferred the Google files, including the .p12
I created the folder / components / com_chronoforms5 / chronoforms / actions / gsheet_save_gh / where I put your files
I proceeded to the registration on Google API as indicated in the FAQ and set up Chronoform with Google codes.

??
V!ncent

Gr

GreyHead 07 Dec, 2017

Hi V!ncent ,

Thanks, that wasn't clear.

By all means PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look.

Bob

Gr

GreyHead 08 Dec, 2017

Hi V!ncent,

Everything looks OK with the form and the action configuration. My next suspicion would be a server setting that is preventing access to the Google library or to the p2 file. If you check the server logs or temporarily set site debugging to Maximum you may get more or a useful message.

Bob

V!

V!ncent 08 Dec, 2017

Hi Bob,

I'm thinking of one thing, in my website, Google folders are not in
/ components / com_chronoforms5 / extras / Google /
but in
/congres / components / com_chronoforms5 / extras / Google /
This may be the cause.

In which Chronoform file is the path to the Google folder?

V!ncent

Gr

GreyHead 09 Dec, 2017

Hi V!ncent,

On line 82 of /administrator/components/com_chronoforms5/chronoforms/actions/gsheet_save_gh/gsheet_save_gh.php

    // set the path 
    $path = JPATH_SITE.'/components/com_chronoforms5/extras/Google/';
    require_once ($path.'autoload.php');

Bob

V!

V!ncent 09 Dec, 2017

Hi Bob,

Wrong way.
The problem is not there, because if I add "/ congres" in the path, it appears twice. He took it into account.

Warning: require_once(/htdocs/congres/congres/components/com_chronoforms5/extras/Google/autoload.php): failed to open stream: No such file or directory in /htdocs/congres/administrator/components/com_chronoforms5/chronoforms/actions/gsheet_save_gh/gsheet_save_gh.php on line 83

Fatal error: require_once(): Failed opening required '/htdocs/congres/congres/components/com_chronoforms5/extras/Google/autoload.php' (include_path='.:/usr/share/php') in /htdocs/congres/administrator/components/com_chronoforms5/chronoforms/actions/gsheet_save_gh/gsheet_save_gh.php on line 83

I keep searching.

V!ncent

Forums

Error 403 on Google Spreadsheet Save action