Google Drive Errors

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 Bob,

Sorry for the delaying in getting back to you. I downloaded all the files that were in the dropbox folder and have uploaded them as described in the post: https://www.chronoengine.com/faqs/70-cfv5/5233-how-do-i-use-the-google-spreadsheet-save-action.html

So i am not sure we are having the same issue are we?

James

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 Bob,

+ the Google API library which should be unzipped and the Gooogle folder copied into the /components/com_chronoforms5/extras/ folder - you may need to create the folder.

So which this the correct path:

/components/com_chronoforms5/extras/
or
/components/com_chronoforms5/extras/Google/

I have the files and the MyProject file in the /Google folder.

Kind regards

James

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 Bob,

Many thanks I do appreciate your time on this.

This is private content

Kind regards

James

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

Sorry Bob, working now!!

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