FYI, here is the debug log:
12:19:15 PHP 5.6.17 Array
14:30:24 PHP 5.6.17 Array
20:53:48 PHP 5.6.17 Array
01:56:56 PHP 5.6.17 Array
11:26:21 PHP 5.6.17 Array
04:22:49 PHP 5.6.17 Array
14:48:16 PHP 5.6.17 Array
22:25:14 PHP 5.6.17 Array
00:41:34 PHP 5.6.17 Array
09:56:40 PHP 5.6.17 Array
11:15:00 PHP 5.6.17 Array
15:04:36 PHP 5.6.17 Array
21:11:53 PHP 5.6.17 Array
01:18:20 PHP 5.6.17 Array
02:37:31 PHP 5.6.17 Array
15:33:46 PHP 5.6.17 Array
03:57:45 PHP 5.6.17 Array
13:11:15 PHP 5.6.17 Array
15:03:50 PHP 5.6.17 Array
02:44:44 PHP 5.6.17 Array
11:16:04 PHP 5.6.17 Array
00:43:02 PHP 5.6.17 Array
11:36:16 PHP 5.6.17 Array
12:48:40 PHP 5.6.17 Array
14:23:33 PHP 5.6.17 Array
22:10:02 PHP 5.6.17 Array
02:28:59 PHP 5.6.17 Array
02:47:19 PHP 5.6.17 Array
02:47:55 PHP 5.6.17 Array
22:00:51 PHP 5.6.17 Array
01:00:47 PHP 5.6.17 Array
20:01:07 PHP 5.6.17 Array
20:01:27 PHP 5.6.17 Array
23:54:42 PHP 5.6.17 Array
Do the timestamps on the log match up with each time you submitted the form? Or are the ones that didn’t make it to the form missing from the log?
Were there any differences (in text or otherwise), between the form submissions that did / didn’t make it?
Lastly, have you tried regenerating your access token – maybe Google is denying it for some reason on an occasional basis (limiting API calls, for instance)?
Hmm, I’m not sure that the time stamps line up.
This morning, for example, there were form submissions at 9:31am, 9:45am, and 9:47am. The first one did not make it into the Google Sheet, but the other two were successful.
Here are the new log entries (since I posted yesterday):
11:30:42 PHP 5.6.17 Array
14:31:19 PHP 5.6.17 Array
Maybe the 14:31 time stamp matches up with the unsuccessful attempt at 9:31am? I’m not sure what the 11:30 time stamp would be though.
There are not any differences between submissions that are successful or unsuccessful. Sometimes they contain the exact same information (name, email address, and number).
I’m not sure how to regenerate the access token. Do you happen to have instructions for that? I’ve tried retrieving and reentering the access code, but that didn’t seem to help.
Thanks for your help! It’s really hard to diagnose the problem because it happens sporadically.
FYI, I was able to confirm this evening that an entry is added to the error log when a submission is not written to the Google sheet.
Interesting, that means that the plugin is doing what it should be doing, but either Google is blocking the request OR your server is hiccuping in the external call. Is there any other server you can test this with? If you’re using a shared host, you may want to ask them if they have had any issues with outbound traffic with the Google API lately.
