DB Cleaning Question

1. It should be cleaned since they are not useful.

2. “edd_api_request_55607a56c4acb8810f01e34bac1f5c80” and other “edd_api_request” entries in the wp_options table belong to your plugin? — not belongs to our plugin.

Hi Ahmed,

Thank you for your quick answer.
It looks like the “edd_api_request” entries belong not to the plugin itself but to its extensions like “Advanced AMP Ads”, “AMP Pro Extension Manager”, “Purge AMP CDN Cache”.

This is the “edd_api_request_55607a56c4acb8810f01e34bac1f5c80” in full (option_value_lenght 12781):

a:2:{s:7:"timeout";i:1618628239;s:5:"value";s:12725:"{"new_version":"1.19.19","stable_version":"1.19.19","name":"Advanced AMP Ads","slug":"amptoolkit-incontent-ads","url":"https:\/\/accounts.ampforwp.com\/downloads\/advancedampads\/?changelog=1","last_updated":"2021-04-16 14:44:12","homepage":"https:\/\/accounts.ampforwp.com\/downloads\/advancedampads\/","package":"https:\/\/accounts.ampforwp.com\/edd-sl\/package_download\/MTYxODY3MzIzOTpmODViNTdhMmUwOWUxMWQxYzQ2ZDg5YWQ0YThkZDBhMjoyMDkxMTplYmI1NjA2MzRjZjM0MTQ3MGI4MzUwMzgxMWFmY2FlODpodHRwc0AvL3d3dy5ydXNzaWFuZG9nLm5ldDow","download_link":"https:\/\/accounts.ampforwp.com\/edd-sl\/package_download\/MTYxODY3MzIzOTpmODViNTdhMmUwOWUxMWQxYzQ2ZDg5YWQ0YThkZDBhMjoyMDkxMTplYmI1NjA2MzRjZjM0MTQ3MGI4MzUwMzgxMWFmY2FlODpodHRwc0AvL3d3dy5ydXNzaWFuZG9nLm5ldDow","sections":{"description":"","changelog":"<p>1.19.19 (16 April 2021)<\/p>\n<ul>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the Validation error of Invalid Characters when custom JSON Added in Doubleclick ADS.<\/li>\n<li>Resolved the issue of Deprecated Required parameter $parallex_fx_height follows optional parameter $parallex_checker 1 in PHP 8.02 or above.<\/li>\n<li>Resolved the issue of no further options to enter the paragraph show up for the Incontent Ad #3 or #4 for DoubleClick Incontent Ads.<\/li>\n<\/ul>\n<p>1.19.18 (22 March 2021)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved Validation error The attribute 'srcset' in tag 'amp-img' is set to the invalid value when set as Show AD after 20%.<\/li>\n<\/ul>\n<p>1.19.17 (05 March 2021)<\/p>\n<ul>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of Plugin Activation link showing when AMPforWP Plugin has different path.<\/li>\n<li>Resolved the issue of GDPR AD Compliant not working, added attribute data-block-on-consent=\"_till_accepted<\/li>\n<li>Resolved the issue of Double click Json attribute not added for Incontent Ads 3, 4.<\/li>\n<li>Resolved the issue of Show Ad after 50% and 60% not rendering ADS on their respective position.<\/li>\n<\/ul>\n<p>1.19.16 (12 February 2021)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to render Author JSON value for Double Click ADS.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not showing Image in Custom Advertising Section when Parallex Option is enabled.<\/li>\n<\/ul>\n<p>1.19.15 (08 January 2021)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not showing Image in Custom Advertising Section when Parallex Option is enabled.<\/li>\n<\/ul>\n<p>1.19.14 (31 October 2020)<\/p>\n<ul>\n<li>Features Added: =<\/li>\n<li>Added support of Custom HTML for banners and Custom amp-ad code for Sticky ADS.<\/li>\n<li>Added support to use multiple AdSense Ads on Homepage Loop.<\/li>\n<\/ul>\n<p>1.19.13 (11 September 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Restructured the code pattern for JSON AD Targetting.<\/li>\n<\/ul>\n<p>1.19.12 (28 August 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added Option to add JSON markup in the Double Click ADS.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of ADS not working when Table is present in Content.<\/li>\n<li>Resolved the issue of ADS displaying on Front Page.<\/li>\n<\/ul>\n<p>1.19.11 (21 August 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the validation error.<\/li>\n<\/ul>\n<p>1.19.10 (06 August 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to Show AMP ADS Meta as per Role Based Access Option.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of Malformed URL 'https:\/\/www.<div%20class=' for attribute 'src' in tag 'amp-img'.<\/li>\n<\/ul>\n<p>1.19.9 (31 July 2020)<\/p>\n<ul>\n<li>Features Added: =<\/li>\n<li>Added an option for showing the ADS between related post and recent posts.<\/li>\n<li>Added support of Responsive Ads for Amazon.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not being displayed as per the positioning.<\/li>\n<\/ul>\n<p>1.19.8 (26 June 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS displayed inspite of no paragraphs in Content.<\/li>\n<\/ul>\n<p>1.19.7 (05 June 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved PHP Fatal error: Uncaught ArgumentCountError: Too few arguments<\/li>\n<\/ul>\n<p>1.19.6 (08 May 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to insert dynamic tags and categories using key values in Doubleclick ADS.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of Static Height Value in Flying Carpet ADS.<\/li>\n<li>Resolved the issue of \"Show AD after Paragraphs\" option not showing for Amazon incontent Ads when Position set as Custom.<\/li>\n<\/ul>\n<p>1.19.5 (27 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the Validation error issue occured due to Whitespace added in srcset attribute.<\/li>\n<\/ul>\n<p>1.19.4 (24 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, the ADS in between Loop Option not working.<\/li>\n<\/ul>\n<p>1.19.3 (17 April 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added two more Incontent AD Slots Incontent Ad #5 and Incontent Ad #6.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved, Incontent ADS showing beyond 80% when set as Show AD after 80% of the content.<\/li>\n<li>Resolved, ADS between loop moving the loop posts towards the rightside.<\/li>\n<\/ul>\n<p>1.19.2 (03 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, ADS showing within the blockquotes.<\/li>\n<\/ul>\n<p>1.19.1 (13 March 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, ADS not aligned in Centre.<\/li>\n<\/ul>\n<p>1.19 (27 December 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Same AD loading twice due to another Plugin, issue resolved.<\/li>\n<\/ul>\n<p>1.18 (13 December 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>!important tag causing validation errors in amp-sticky-ad with Custom advertisement issue resolved.<\/li>\n<\/ul>\n<p>1.17 (06 Sep 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>amp-sticky-ad loading more than once Validation error resolved.<\/li>\n<\/ul>\n<p>1.16 (31 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>'data-enable-refresh' Attribute Feature Added.<\/li>\n<\/ul>\n<p>1.15 (23 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>Enable multi-size ad requests Feature Added.<\/li>\n<li>Bug Fixed =<\/li>\n<li>Hide ADS Option not working with Core Advertisment Section ADS resolved.<\/li>\n<\/ul>\n<p>1.14 (09 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>MGID Advertisement Support Added.<\/li>\n<li>Bugs Fixed =<\/li>\n<li>Sticky Ads not working in the Custom Advertisement Section resolved.\n<ul>\n<li>Notices fixed.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>1.13 (02 Aug 2019)<\/p>\n<ul>\n<li>Bug Fixed =<\/li>\n<li>Redux Class not found Fatal Error resolved.<\/li>\n<\/ul>\n"},"banners":{"high":"","low":""},"icons":"a:0:{}","description":[""],"changelog":["<p>1.19.19 (16 April 2021)<\/p>\n<ul>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the Validation error of Invalid Characters when custom JSON Added in Doubleclick ADS.<\/li>\n<li>Resolved the issue of Deprecated Required parameter $parallex_fx_height follows optional parameter $parallex_checker 1 in PHP 8.02 or above.<\/li>\n<li>Resolved the issue of no further options to enter the paragraph show up for the Incontent Ad #3 or #4 for DoubleClick Incontent Ads.<\/li>\n<\/ul>\n<p>1.19.18 (22 March 2021)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved Validation error The attribute 'srcset' in tag 'amp-img' is set to the invalid value when set as Show AD after 20%.<\/li>\n<\/ul>\n<p>1.19.17 (05 March 2021)<\/p>\n<ul>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of Plugin Activation link showing when AMPforWP Plugin has different path.<\/li>\n<li>Resolved the issue of GDPR AD Compliant not working, added attribute data-block-on-consent=\"_till_accepted<\/li>\n<li>Resolved the issue of Double click Json attribute not added for Incontent Ads 3, 4.<\/li>\n<li>Resolved the issue of Show Ad after 50% and 60% not rendering ADS on their respective position.<\/li>\n<\/ul>\n<p>1.19.16 (12 February 2021)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to render Author JSON value for Double Click ADS.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not showing Image in Custom Advertising Section when Parallex Option is enabled.<\/li>\n<\/ul>\n<p>1.19.15 (08 January 2021)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not showing Image in Custom Advertising Section when Parallex Option is enabled.<\/li>\n<\/ul>\n<p>1.19.14 (31 October 2020)<\/p>\n<ul>\n<li>Features Added: =<\/li>\n<li>Added support of Custom HTML for banners and Custom amp-ad code for Sticky ADS.<\/li>\n<li>Added support to use multiple AdSense Ads on Homepage Loop.<\/li>\n<\/ul>\n<p>1.19.13 (11 September 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Restructured the code pattern for JSON AD Targetting.<\/li>\n<\/ul>\n<p>1.19.12 (28 August 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added Option to add JSON markup in the Double Click ADS.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of ADS not working when Table is present in Content.<\/li>\n<li>Resolved the issue of ADS displaying on Front Page.<\/li>\n<\/ul>\n<p>1.19.11 (21 August 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the validation error.<\/li>\n<\/ul>\n<p>1.19.10 (06 August 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to Show AMP ADS Meta as per Role Based Access Option.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of Malformed URL 'https:\/\/www.<div%20class=' for attribute 'src' in tag 'amp-img'.<\/li>\n<\/ul>\n<p>1.19.9 (31 July 2020)<\/p>\n<ul>\n<li>Features Added: =<\/li>\n<li>Added an option for showing the ADS between related post and recent posts.<\/li>\n<li>Added support of Responsive Ads for Amazon.<\/li>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS not being displayed as per the positioning.<\/li>\n<\/ul>\n<p>1.19.8 (26 June 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the issue of ADS displayed inspite of no paragraphs in Content.<\/li>\n<\/ul>\n<p>1.19.7 (05 June 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved PHP Fatal error: Uncaught ArgumentCountError: Too few arguments<\/li>\n<\/ul>\n<p>1.19.6 (08 May 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added support to insert dynamic tags and categories using key values in Doubleclick ADS.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved the issue of Static Height Value in Flying Carpet ADS.<\/li>\n<li>Resolved the issue of \"Show AD after Paragraphs\" option not showing for Amazon incontent Ads when Position set as Custom.<\/li>\n<\/ul>\n<p>1.19.5 (27 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved the Validation error issue occured due to Whitespace added in srcset attribute.<\/li>\n<\/ul>\n<p>1.19.4 (24 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, the ADS in between Loop Option not working.<\/li>\n<\/ul>\n<p>1.19.3 (17 April 2020)<\/p>\n<ul>\n<li>Feature Added: =<\/li>\n<li>Added two more Incontent AD Slots Incontent Ad #5 and Incontent Ad #6.<\/li>\n<li>Bugs Fixed: =<\/li>\n<li>Resolved, Incontent ADS showing beyond 80% when set as Show AD after 80% of the content.<\/li>\n<li>Resolved, ADS between loop moving the loop posts towards the rightside.<\/li>\n<\/ul>\n<p>1.19.2 (03 April 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, ADS showing within the blockquotes.<\/li>\n<\/ul>\n<p>1.19.1 (13 March 2020)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Resolved, ADS not aligned in Centre.<\/li>\n<\/ul>\n<p>1.19 (27 December 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>Same AD loading twice due to another Plugin, issue resolved.<\/li>\n<\/ul>\n<p>1.18 (13 December 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>!important tag causing validation errors in amp-sticky-ad with Custom advertisement issue resolved.<\/li>\n<\/ul>\n<p>1.17 (06 Sep 2019)<\/p>\n<ul>\n<li>Bug Fixed: =<\/li>\n<li>amp-sticky-ad loading more than once Validation error resolved.<\/li>\n<\/ul>\n<p>1.16 (31 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>'data-enable-refresh' Attribute Feature Added.<\/li>\n<\/ul>\n<p>1.15 (23 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>Enable multi-size ad requests Feature Added.<\/li>\n<li>Bug Fixed =<\/li>\n<li>Hide ADS Option not working with Core Advertisment Section ADS resolved.<\/li>\n<\/ul>\n<p>1.14 (09 Aug 2019)<\/p>\n<ul>\n<li>Feature Added =<\/li>\n<li>MGID Advertisement Support Added.<\/li>\n<li>Bugs Fixed =<\/li>\n<li>Sticky Ads not working in the Custom Advertisement Section resolved.\n<ul>\n<li>Notices fixed.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>1.13 (02 Aug 2019)<\/p>\n<ul>\n<li>Bug Fixed =<\/li>\n<li>Redux Class not found Fatal Error resolved.<\/li>\n<\/ul>\n"]}";}

Can I clean the entries of the extensions that we currently don’t use and leave only the entries of “AMP cache” extension?

Can you please take the complete backup of the live site and staging site and test it on the staging site by cleaning it? If everything is fine then you can do it on the Live site.

Ok, thank you for your recommendation.

I have cleaned them, and everything seems to work fine. Thank you.