Alex Agranov

What libcurl version did you have installed before? GuzzleHttp is the dependency that Google PHP SDK is using and according to their forums the problem was in specific CURL versions – e.g. 7.69.1 – but it disappeared in 7.71.0.

If it’s the server that you manage on your own – use native OS tools like yum or apt to do it. If it’s managed hosting – ask your hosting provider to do it for you.

Looks like a compatibility issue between GuzzleHttp library, that is part of my plugin, and libcurl version installed on your host. See this thread: https://github.com/guzzle/guzzle/issues/2617

A similar problem was reported earlier in this forum too: https://www.ads-software.com/support/topic/form-suddenly-not-working-after-20-april-2020/

Downgrading libcurl version should resolve the issue.

Great to hear that!
There is PayPal donate button on the plugin page.

Did you check the debug log? Anything interesting there?

Please check the debug log

Looks like something went wrong when you copy/pasted authentication code during the plugin activation. Try to re-activate the plugin.

I think I squashed the bug. Please try the new version 2.5 and let me know if the problem still persists.

I think I squashed the bug. Please try the new version 2.5 and let me know if the problem still persists.

The relevant code is here:
https://plugins.trac.www.ads-software.com/browser/cf-google-sheets/trunk/lib/google-sheets.php

And it’s pretty simple – first I grab “!1:1” range from the Sheet and assign it to $header. Then I populate the $values array. And finally build $valueRange and pass it to Sheet’s append() method.

I could think of three possible things that could go wrong:
1) maybe $header has some empty elements in the beginning – which would explain the shift
2) maybe $values has some empty elements in the beginning
3) or maybe all structures are good, and it’s append() method that for some reason does the shift (even though the range passed to it is good)

Could you add some debug prints (or use any other debugging technique) to try to identify which of the above is true (if any)?

Sorry – I tried really hard but wasn’t able to reproduce this on my setup.
If you are capable of reading PHP code, I’d appreciate a lot your assistance with debugging this.

This is actually by design – you don’t want user input to be able to execute code in your Sheet due to security reasons. Hence all input is formatted as text.

Just as I wrote – implemented em_action_booking_add() filter and put redirect URL value into $return[‘redirect’]

Found the answer – simply had to implement em_action_booking_add() filter and populate $return[‘redirect’].

Yes – never tried it myself, but it should work just fine.