Hi again,
after one day the plugin works fine.
Best Regards
Richard
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.
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 INTOwp_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
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/.
Also, if you know which page it was trying to check when this problem occurred, that might help me reproduce the issue.
Thanks!
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.
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
Hi mattkeys,
same again here. No reports generated and no errors in log. Tested all methods with “delete all”.
:-/
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!
