Title: No reports shown – database error Last modified: August 31, 2016 --- # No reports shown – database error * Resolved [nobsi8000](https://wordpress.org/support/users/nobsi8000/) * (@nobsi8000) * [10 years, 3 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/) * Hi, * I have several sites and none of them is working with the plugin. API key is generated and in the Google Console I see activity when I start the plugin. The plugin runs a while, the progress bar is moving. But when the plugin finishes work no reports are shown. * In the the DB-Log there are a lot of errors of this type: [23-Feb-2016 09:22: 58 UTC] WordPress-Datenbank-Fehler Column ‘page_id’ cannot be null für Abfrage INSERT INTO `kas_wp_gpi_page_reports` (`page_id`, `strategy`, `rule_key`, `rule_name`,` rule_impact`, `rule_blocks`) VALUES (NULL, ‘desktop’, ‘AvoidLandingPageRedirects’,‘ Avoid landing page redirects’, ‘0’, ‘a:1:{i:0;a:1:{s:6:\”header\”;a:2:{s:6:\” format\”;s:77:\”Your page has no redirects. Learn more about avoiding landing page redirects.\”;s:4:\”args\”;a:1:{i:0;a:2:{s:4:\”type\”;s:9:\”HYPERLINK\”;s: 5:\”value\”;s:64:\”[https://developers.google.com/speed/docs/insights/AvoidRedirects](https://developers.google.com/speed/docs/insights/AvoidRedirects)\”;}}}}}’) von do_action_ref_array, call_user_func_array, googlePagespeedInsights->googlepagespeedinsightsworker, googlePagespeedInsights->googlepagespeedinsightsdowork, googlePagespeedInsights- >google_pagespeed_insights_Save_Values * Do you have any suggestions for me? * Best Regards, Richard * [https://wordpress.org/plugins/google-pagespeed-insights/](https://wordpress.org/plugins/google-pagespeed-insights/) Viewing 8 replies - 1 through 8 (of 8 total) * Thread Starter [nobsi8000](https://wordpress.org/support/users/nobsi8000/) * (@nobsi8000) * [10 years, 3 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-7096678) * Hi again, * after one day the plugin works fine. * Best Regards Richard * Plugin Author [Matt Keys](https://wordpress.org/support/users/mattkeys/) * (@mattkeys) * [10 years, 3 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-7096729) * Hey sorry I wasn’t able to get to your support request sooner as I’ve been out of town. * I am glad that the plugin is working for you now, but it is awfully mysterious that it was getting that problem before. Let me know if it comes back and I will take a look. * [wpjannek](https://wordpress.org/support/users/wpjannek/) * (@wpjannek) * [9 years, 10 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-7096856) * Hi mattkeys, * have the same problem, only it doesn’t go away alone :-/ * `WordPress-Datenbank-Fehler Column 'page_id' cannot be null f\xc3\xbcr Abfrage INSERT INTO`wp_gpi_page_reports`(`page_id`,`strategy`,`rule_key`,`rule_name`,` rule_impact`,`rule_blocks`) VALUES (NULL, 'desktop', 'PrioritizeVisibleContent',' Prioritize visible content', '2', 'a:2:{i:0;a:1:{s:6:\\"header\\";a:1:{s:6:\\" format\\";s:176:\\"Your page requires additional network round trips to render the above-the-fold content. For best performance, reduce the amount of HTML needed to render above-the-fold content.\\";}}i:1;a:2:{s:6:\\"header\\";a:2:{s:6:\\" format\\";s:324:\\"The entire HTML response was not sufficient to render the above-the-fold content. This usually indicates that additional resources, loaded after HTML parsing, were required to render above-the-fold content. Prioritize visible content that is needed for rendering above-the-fold by including it directly in the HTML response.\\";s:4:\\"args\\";a:1:{i:0;a:2:{s:4:\\"type\\";s:9:\\"HYPERLINK\\"; s:5:\\"value\\";s:74:\\"https://developers.google.com/speed/docs/insights/PrioritizeVisibleContent\\";}}} s:4:\\"urls\\";a:1:{i:0;a:1:{s:6:\\"result\\";a:2:{s:6:\\"format\\";s:99:\\"Only about $1 of the final above-the-fold content could be rendered with the full HTML response $2.\\";s:4:\\"args\\";a:2:{i:0;a:2:{s:4:\\"type\\";s:10:\\"PERCENTAGE\\"; s:5:\\"value\\";s:3:\\"67%\\";}i:1;a:2:{s:4:\\"type\\";s:13:\\"SNAPSHOT_RECT\\"; s:5:\\"value\\";s:11:\\"snapshot:10\\";}}}}}}}') von do_action('wp_ajax_gpi_run_worker_service'), call_user_func_array, gpi_run_worker_service, googlePagespeedInsights->googlepagespeedinsightsworker, googlePagespeedInsights->googlepagespeedinsightsdowork, googlePagespeedInsights- >google_pagespeed_insights_Save_Values, W3_Db->insert, W3_DbCache->insert, W3_DbCallUnderlying- >insert, W3_Db->insert, W3_DbProcessor->insert, W3_Db->default_insert, W3_Db- >query, W3_DbProcessor->query, W3_Db->default_query, referer: http://XXX.XXX. de/wp-admin/tools.php?page=google-pagespeed-insights&render=options` * WordPress 4.5.3 all other plugins disabled. * Seems that the plugin doesn’t get the page_id right (null) from wp. * I hope you can help me. * Thanks Jan * Plugin Author [Matt Keys](https://wordpress.org/support/users/mattkeys/) * (@mattkeys) * [9 years, 10 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-7096857) * Hi Jan, * Would you be able to provide me temporary access to your sites WP Admin area so that I can diagnose this problem? * If so, can you send credentials to me through my sites contact form: [http://mattkeys.me/about/](http://mattkeys.me/about/). * Also, if you know which page it was trying to check when this problem occurred, that might help me reproduce the issue. * Thanks! * Plugin Author [Matt Keys](https://wordpress.org/support/users/mattkeys/) * (@mattkeys) * [9 years, 10 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-7096858) * Thanks for providing me access Jan. While I was looking at the site it seemed to ‘fix itself’ like it did with the original reporter of this issue. * From the little bit of testing I was able to do while it was still not working, I think that somehow the plugin is trying to update a pagespeed result, even though no existing results exist. Which leads to the NULL value and the errors. * I am working on version 2.0 of this plugin which will bring about a bunch of fixes and improvements and I hope to investigate this problem more and have it resolved in that release. In the meantime if anyone else runs into this, I believe selecting “Delete EVERYTHING” from the admin area will resolve this problem. * Jan, on your particular site I noticed the the WP Cron method doesn’t work, I am guessing it is disabled on your server? Or perhaps it is being manually triggered but at an interval longer than I waited for. The Ajax scan method works, but is a bit funky, hoping to look into better options for this in v2.0 as well. * [Els Guns](https://wordpress.org/support/users/els-guns/) * (@els-guns) * [9 years, 8 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-8182898) * Hi Matt, same issue here (WordPress database error Column ‘page_id’ cannot be null for query INSERT INTO `gpi_page_reports`). Tried all scan techniques and“ Delete EVERYTHING” didn’t work. greets, Els * [wpjannek](https://wordpress.org/support/users/wpjannek/) * (@wpjannek) * [9 years, 8 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-8197743) * Hi mattkeys, * same again here. No reports generated and no errors in log. Tested all methods with “delete all”. * :-/ * Plugin Author [Matt Keys](https://wordpress.org/support/users/mattkeys/) * (@mattkeys) * [9 years, 8 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-8198852) * Sorry everyone who is having trouble with this. I don’t have any immediate resolutions to this problem. I have a version 2.0 of the plugin that is mostly done, but I have had to pause on development of that version until my paid client workload goes back down to normal (which can’t come soon enough). * I hope to be back to this soon! Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘No reports shown – database error’ is closed to new replies. * ![](https://ps.w.org/google-pagespeed-insights/assets/icon-256x256.png?rev=1692787) * [Insights from Google PageSpeed](https://wordpress.org/plugins/google-pagespeed-insights/) * [Support Threads](https://wordpress.org/support/plugin/google-pagespeed-insights/) * [Active Topics](https://wordpress.org/support/plugin/google-pagespeed-insights/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/google-pagespeed-insights/unresolved/) * [Reviews](https://wordpress.org/support/plugin/google-pagespeed-insights/reviews/) * 8 replies * 4 participants * Last reply from: [Matt Keys](https://wordpress.org/support/users/mattkeys/) * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/no-reports-shown-database-error/#post-8198852) * Status: resolved