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
Hi Vincent.
I can't tell much from the info here - what is the URL that shows the 403 error?
Bob
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
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
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
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
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
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
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
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
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
