Buy Now
Sign in

Error 403 on Google Spreadsheet Save action

V!ncent , December 06 2017
V
V!ncent
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
GreyHead
Hi Vincent.

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

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
V
V!ncent
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
V
V!ncent
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
V
V!ncent
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
V
V!ncent
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
V
V!ncent
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