The OAuth 2.0 access token has expired, and a refresh token is not available. Re

Please post the exact error from Errors & Debug screen.

How many sites are you authorizing with a single GA account and do you have a network (WP Multisite)?

Hello Alin,

Thank you for responding so quickly.

I think I have about 15 – 20 sites using the same GA account. Note the GA account will service 50 sites.

The error script you have requested is below.

Regards,

John.

Last Error: 2015-08-26 02:01:58: exception ‘Google_Auth_Exception’ with message ‘The OAuth 2.0 access token has expired, and a refresh token is not available. Refresh tokens are not returned for responses that were auto-approved.’ in /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Auth/OAuth2.php:238
Stack trace:
#0 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Service/Resource.php(215): Google_Auth_OAuth2->sign(Object(Google_Http_Request))
#1 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Service/Analytics.php(1909): Google_Service_Resource->call(‘get’, Array, ‘Google_Service_…’)
#2 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(313): Google_Service_Analytics_DataGa_Resource->get(‘ga:107160833’, ‘7daysAgo’, ‘yesterday’, ‘ga:sessions,ga:…’, Array)
#3 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(439): GADWP_GAPI_Controller->handle_corereports(‘107160833’, ‘7daysAgo’, ‘yesterday’, ‘ga:sessions,ga:…’, Array, ‘gadash_qr3_1782…’)
#4 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(785): GADWP_GAPI_Controller->get_bottomstats(‘107160833’, ‘7daysAgo’, ‘yesterday’, ”)
#5 /home/reeflifesurvey/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/admin/ajax-actions.php(145): GADWP_GAPI_Controller->get(‘107160833’, ‘bottomstats’, ‘7daysAgo’, ‘yesterday’)
#6 [internal function]: GADWP_Backend_Ajax->ajax_widget_reports(”)
#7 /home/reeflifesurvey/public_html/wp-includes/plugin.php(503): call_user_func_array(Array, Array)
#8 /home/reeflifesurvey/public_html/wp-admin/admin-ajax.php(89): do_action(‘wp_ajax_gadash_…’)
#9 {main}

I’m wondering if you’re using any other analytics plugins or a plugin that may use a different Google Service (like Google Drive, Google Calendar, etc.). Basically, a plugin that requires an authorization from Google, as GADWP does.

I do have two other plugins that use Google products, these are the WP Google Translator and the WP Google Maps Pro.

neither of these require an API or other key from Google.

Your app does work fine for a couple of days then I get the error. Its working fine now after I re-authenticated with google.

Does this still sound like a plugin conflict?

Are you using plugins to cleanup transients or other similar cleanup tools? And, do you use a persistent object cache (like memcached)?

No cleanup tools. I did have a revision plugin tool but got rid of it as it caused some nasty conflicts with other plugins.

I am running W3 Total Cache and also have Jetpack installed.

Have you checked the error logs for anything strange? Maybe some PHP errors or Database read/write errors?

I’m also having this issue – interesting to note that the tracking IS taking place if I log into Google. The reporting by the plugin ends about 14 days ago which is about the time the site was upgraded to WP 4.3 …

I’ll open a separate thread if you want.

The tracking will work, the plugin has a failsafe system since authorization is not needed to do tracking. It’s one of the neat features no one knows about, but it’s there :).

I wonder if you guys have the same hosting provider.

Same issue here in several sites.

Looks like 14 days ago as well; see line #2 from error report.

“The OAuth 2.0 access token has expired, and a refresh token is not available. Refresh tokens are not returned for responses that were auto-approved.”

Sometimes I can see only the LAST 30 DAYS but not any other views. In some other sites, I see nothing.

Two of the sites where issue is occurring are long time users of GADWP and have a lot of traffic, so there is definitely data there.

If I clear and reestablish authorization, the data reappears for a short time before getting the not available message again. (This report is unavailable (0))

Thanks in advance for your help!

Last Error: 2015-08-26 13:36:36: exception ‘Google_Auth_Exception’ with message ‘The OAuth 2.0 access token has expired, and a refresh token is not available. Refresh tokens are not returned for responses that were auto-approved.’ in /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Auth/OAuth2.php:238
Stack trace:
#0 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Service/Resource.php(215): Google_Auth_OAuth2->sign(Object(Google_Http_Request))
#1 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google/Service/Analytics.php(1909): Google_Service_Resource->call(‘get’, Array, ‘Google_Service_…’)
#2 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(313): Google_Service_Analytics_DataGa_Resource->get(‘ga:6823880′, ’14daysAgo’, ‘yesterday’, ‘ga:sessions,ga:…’, Array)
#3 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(439): GADWP_GAPI_Controller->handle_corereports(‘6823880′, ’14daysAgo’, ‘yesterday’, ‘ga:sessions,ga:…’, Array, ‘gadash_qr3_3663…’)
#4 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/gapi.php(785): GADWP_GAPI_Controller->get_bottomstats(‘6823880′, ’14daysAgo’, ‘yesterday’, ”)
#5 /home/xxxxxx/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/admin/ajax-actions.php(145): GADWP_GAPI_Controller->get(‘6823880’, ‘bottomstats’, ’14daysAgo’, ‘yesterday’)
#6 [internal function]: GADWP_Backend_Ajax->ajax_widget_reports(”)
#7 /home/xxxxxx/public_html/wp-includes/plugin.php(503): call_user_func_array(Array, Array)
#8 /home/xxxxxx/public_html/wp-admin/admin-ajax.php(89): do_action(‘wp_ajax_gadash_…’)
#9 {main}

Hosting provider names, please. Since I can’t replicate it on my dev platform nor on any websites and networks I manage.

Clients’ websites are all on our managed dedicated server at PEER1 in Atlanta.

Been using GADWP successfully for a long time on many many sites, on the exact same server. No changes to server at all in the last months.

I build all WP sites from the same theme base (WP Jumpstart V1.x), and use almost the same set of plugins.

Each site has its own unique GA account.

Like others, just started seeing this issue in the last two weeks or so.

REDHAT Enterprise 6.6 x86_64 standard – whm WHM 11.50.0 (build 29)
Linux 2.6.32-504.16.2.el6.x86_64 x86_64

MySQL Version 5.1.73
PHP Version 5.3.29

Hope this helps!

@kenneth-feldman If you have time, test this and let me know if anything changes: https://github.com/deconf/Google-Analytics-Dashboard-for-WP/archive/oauth2-issue-fix.zip

Thanks Alin!

I have installed (replaced) the plugin in two sites.

I had to reauthorize before the stats reappeared, but will now monitor for a few days to see what happens.

Will update here soon with results either way.

Thank you again for the fast response!

Ok, finally, I’ve managed to replicate it.

So, if for some reason (I still suspect a plugin/theme or a cleanup tool) a transient gets broken (its timeout gets deleted or is never set due to an error) in WP 4.3 its value gets returned as it was a valid transient, leading to the above error.

I’ve also opened a core ticket about it, see #33561. I’ll try to find a solution and fix it ASAP since a core change takes time.

Meanwhile, make sure there’s nothing in your theme/plugins that could delete transient timeouts (%transient_timeout% in wp_options table, when database is used) without deleting the transient value itself.