Hi,
I am trying to upload my forms data to a spreadsheet saved on google drive.
I have tried my best to follow the instructions but I keep getting this error after submitting the form:
CLASS 'GOOGLE_CLIENT' NOT FOUND
I am fairly sure that I have entered all the details correctly, but I am sure I am missing something.
If someone can point me in the right direction I would be very grateful.
Many thanks
James
I am wondering if I need some help with this action:
Second create you form and use Array Names for the inputs that you need to save.
Hi,
Is there anyone that can help me please?
Kind regards
James
Hi James,
I think you are using the GSheet Save [GH} action - is that correct?
The Google_Client class should be being loaded from the Google API library at /components/com_chronoforms5/extras/Google/ - do you have that installed on your site?
Bob
Hi Bob,
yes that is correct. I have download this file: ChronoForms v5 action gsheet_save_gh UNZIP.zip and uploaded the contents into the folder as directed. I have also uploaded the .p12 file into the same folder, it that what you are referring to?
Kind regards
James
Hi James,
Yes that's correct. It appears that PHP can't find some of the Google API files - can you copy the whole error message here that should show whether the error is originating in the CF file or the Google ones.
Bob
Hi Bob,
Thanks for helping with this one. Attached is a screenshot of the error displayed in browser.
Kind regards
James
Hi James,
Hmmm . . . I was expecting a PHP error message with more useful info. That doesn't help much at all.
I'll have a look at the action on my test site and check that all is still well with that.
Bob
Hi James,
On one site running Joomla 3.6.4 with PHP 5.6.29 it is working OK
On the other site running Joomla 3.7.2 with PHP 7.0.14 I get the same error. Here's the full PHP message: "Fatal error: Class 'Google_Service' not found in /home/greyhead/j34.domain_name.org/components/com_chronoforms5/extras/Google/Service/Drive.php on line 31"
That gives me somewhere to start debugging - in the Google API files, I'll try to track down the cause.
Bob
Hi James,
It's working OK now on the second site too, the error was because I had failed to upload all the Google API files from my PC to the live site :-(
Bob
Hi James,
When you unzip the file from DropBox there should be an installation instructions text document. Please check that you followed the instructions there about where to copy the files.
Bob
Hi James,
You copy the Google folder from the zip file into the Extras folder so your path ends up looking like the image below.
Bob
[attachment=270_20170711101731_2017-07-11-12-15-36-png.png][/attachment]
Hi Bob,
Yes I can confirm that is how I have it set up. As I am sure i have following the instructions correctly, but you never know.
I am wondering if there are any server side requirements not mentioned in the instructions?
Kind regards
James
Hi James,
By all means PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look.
Bob
Hi James,
Sorry to be so long getting back to you. Have you now solved this one way or another?
Bob
Hi Bob,
That's ok, no i was waiting for you to have a look and see if you could find anything.
Is that still ok?
If i know there is no issue on our side I can refocus my attention on the google side, even though I can't see where I have gone wrong. Followed the instructions line for line.
Kind regards
James
Hi James,
Sure, please check the login you posted - I get "Username and password do not match or you do not have an account yet."
Bob
Hi James,
I think that should be working now.
I took a backup of your form and restored it on my test site. After changing Google IDs checked that saved OK to a new Google Sheet.
I installed the Joomla ExTplorer component on your site so that I could look at the files and found that while the folder location was OK one file Client.php was missing. I created a new copy of that and the form seems to save OK (I can't see the GSheet to be certain).
I also added a Debugger action to your form On Submit event to see the output which looks good. Both that action and the ExTplorer component are currently disabled.
Bob
Hi Bob,
I have done some further testing and it does work perfectly, thank you so much.
I am curious though how that Client.php file was missing and from what folder. All i did was upload the route folder rather than each file.
Many thanks
James
Hi James,
I don't know why it was missing - maybe just one of those odd things that happen. I did check my zip files and it seems to be in those. If it goes missing again, then maybe some 'bad file' filter on the server has taken a dislike to it.
Bob