29.7010 [ms]
|
UPDATE `wp_options` SET `option_value` = 'a:10:{s:32:\"7e8a95c4009f3442210cf713baa672d3\";s:589:\"04-28 09:45: /wp-json/wp/v2/posts/406SHORTCURL
start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/stopsopa-again/)!\nSHORTCURL stop=</a> but not found in
(https://wordpress.org/plugins/stopsopa-again/)!\n \";s:32:\"fd32e5c2d6d320f40f6050a18b7c7f20\";s:138682:\"05-02
01:16: /tag/wordpress/feed/SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/smaly-widget/)!\n \";s:32:\"5d949050b0740f84271fd98877871368\";s:136773:\"05-02
00:54: /category/my-plugins/stop-sopa-again/SHORTCURL start=<a class="plugin-download button download-button button-large" but
not found in (https://wordpress.org/plugins/stopsopa-again/)!\n \";s:32:\"8d05e9b5b81bf097ae25ba5eb2421104\";s:151231:\"05-02
01:16: /tag/wordpress/feed/SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/spostarbust/)!\n \";s:32:\"120aff8f810259f8ba17d3b3f2896e66\";s:143354:\"05-02
01:39: /SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/comment-testimonials/)!\n \";s:32:\"c862651754f5ce07f7c0a01839ef43bc\";s:148900:\"05-02
01:39: /SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/shortcurl/)!\n \";s:32:\"804f44fb2a836fb12d5fc6a310cd32c9\";s:159144:\"05-02
01:42: /shortcode-support-added-to-sql-reports/SHORTCURL start=<a class="plugin-download button download-button button-large"
but not found in (https://wordpress.org/plugins/elisqlreports/)!\n \";s:32:\"83b7aa9e5251a220d107463e4e3541c4\";s:140084:\"05-02
00:58: /display-name-if-no-gravatar/SHORTCURL start=<a class="plugin-download button download-button button-large" but not
found in (https://wordpress.org/plugins/0gravatar/)!\n \";s:32:\"eb9ac8290c58f3b1774defdfeb138f1b\";s:139967:\"05-02
01:16: /tag/wordpress/feed/SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/wordcents/)!\n \";s:32:\"492cadb77c7f18dc0fb6cd8909d1b748\";s:149672:\"05-02
01:16: /tag/wordpress/feed/SHORTCURL start=<a class="plugin-download button download-button button-large" but not found in
(https://wordpress.org/plugins/terribl/)!\n \";}' WHERE `option_name` =
'SHORTCURL_admin_notices';
|
Hi Eli… great script but I’m having a slight problem. I named one of my reports with an apostrophe ‘My Report’ and now I cannot delete the report. I assume the apostrophes are screwing up the SQL delete statement? I tried deactivating your plugin and deleting all files and reinstalling plugin, but the reports remain. Can I delete them directly from SQL using phpMyAdmin, and if so, where are these report names stored? Donation will follow should you reply … scouts honor!
Thanks for bringing this to my attention I will add a fix for the apostrophe issue in my next release. For now you can delete all your saved reports with this SQL:
DELETE FROM wp_options WHERE option_name LIKE ‘ELISQLREPORTS_reports_array’
If you are WP Serialize Savvy you hack up this option in phpMyAdmin to keep your other reports or just remove the apostrophe from the name but be sure to correct the value length markers or it won’t work at all.
Hi Eli:
I am looking for a plugin that will pull custom fields and return in a report format. Not a sql programmer so not sure this will work with your plugin. But, it seems if it is in mysql it should be able to be pulled.
Thanks
Joy
Where there’s SQL, there’s a way!
If you can give me a good idea of what you want your report to look like I can help you formulate an SQL query.