harshsurve

Thanks @garyf711

Yes it worked like a charm. Thanks for the solution.

Thanks for the help.

AFter digging deeper it seems to be an issue with Database migration. On having a look at the Database tables on the new installation I observed that on a fresh installation the tables are Editable inline – but as soon as I migrate import the tables from the production site – the imported tables are not aditable inline.

I’m not very well versed wit MySql and dont know whether it matters in this issue. Pls help me with this.

Was able to reproduce the Error. A clean wordpress install with WooCommerce works very well and doesnot give any errors.

The issue reoccurs when I export my Website database was imported from the earlier server.

So can conclude that the issue is not due to Hosting Server.

Note: Both the Hosting Servers – old as well as new are with the same Hosting provider with exactly same technicals and same version of MySql

Thanks for your reply. Shall surely contact my Host and look at the PHP_MAX_Execution_time to be increased and try if the issue resolves. For the mean time below is the WPDEBUG.LOG output and the WooCommerce>Status fro your review.

WPDEDUG.LOG

[03-Dec-2019 19:35:48 UTC] PHP Fatal error: Uncaught RuntimeException: Error saving action: Unable to save action. in /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php:33
Stack trace:
#0 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(109): ActionScheduler_wpPostStore->save_action(Object(ActionScheduler_Action))
#1 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php(59): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/functions.php(18): ActionScheduler_ActionFactory->single(‘woocommerce_upd…’, Array, 1575401748, ”)
#3 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php(44): as_schedule_single_action(1575401748, ‘woocommerce_upd…’, Arr in /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php on line 33

[03-Dec-2019 19:38:37 UTC] PHP Fatal error: Uncaught InvalidArgumentException: Unidentified action 0 in /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php:488
Stack trace:
#0 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php(475): ActionScheduler_wpPostStore->get_date_gmt(‘0’)
#1 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(78): ActionScheduler_wpPostStore->get_date(‘0’)
#2 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date(‘failed’, ‘oldest’)
#3 /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(27): ActionScheduler_wcSystemStatus->get_oldest_and_newest(Array)
#4 /home/ in /home/prayorjv/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php on line 488

WooCommerce>Status

### WordPress Environment ###

WordPress address (URL): https://prayagasia.com
Site address (URL): https://prayagasia.com
WC Version: 3.8.1
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.25
PHP Post Max Size: 8 MB
PHP Time Limit: 600
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 10.1.43-MariaDB-cll-lve
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp63_
Total Database Size: 337.51MB
Database Data Size: 318.85MB
Database Index Size: 18.66MB
wp63_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp63_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_adventure_tours_storage: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_assets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_cross_sell: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_products: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_report_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_amz_search: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_comments: Data: 304.47MB + Index: 18.59MB + Engine MyISAM
wp63_entrada_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp63_entrada_price_range: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_entrada_wishlist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_ewwwio_images: Data: 0.87MB + Index: 0.00MB + Engine MyISAM
wp63_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_hotel_room: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_actions: Data: 0.59MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_forms_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_form_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_lists_subscribers: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_subscribers: Data: 0.36MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_subscriber_fields: Data: 0.25MB + Index: 0.00MB + Engine MyISAM
wp63_mailster_subscriber_meta: Data: 0.40MB + Index: 0.00MB + Engine MyISAM
wp63_options: Data: 2.77MB + Index: 0.00MB + Engine MyISAM
wp63_polls: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_poll_answer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_postmeta: Data: 2.40MB + Index: 0.00MB + Engine MyISAM
wp63_posts: Data: 1.12MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_sliders: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_sliders_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_slides: Data: 0.75MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_slides_bkp: Data: 0.75MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_static_slides: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
wp63_revslider_static_slides_bkp: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
wp63_st_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_availability: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_cars: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_flights: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_flight_airport: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_flight_availability: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_hotel: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_inbox: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_location_nested: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_location_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_member_packages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_member_packages_order: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_order_item_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_price: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_properties: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_rental: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_tours: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_user_online: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_st_withdrawal: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_termmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp63_terms: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp63_term_relationships: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp63_term_taxonomy: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp63_usermeta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp63_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_bookings_availability: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_bookings_availabilitymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_booking_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_deposits_payment_plans: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_deposits_payment_plans_schedule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp63_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp63_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp63_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfConfig: Data: 0.74MB + Index: 0.00MB + Engine MyISAM
wp63_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfFileMods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfHits: Data: 0.35MB + Index: 0.03MB + Engine MyISAM
wp63_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfIssues: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp63_wfKnownFileList: Data: 2.01MB + Index: 0.00MB + Engine MyISAM
wp63_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfLogins: Data: 0.14MB + Index: 0.00MB + Engine MyISAM
wp63_wfls_2fa_secrets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp63_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp63_wfNotifications: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp63_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp63_wfStatus: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp63_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?Error messages should not be shown to visitors.

### Active Plugins (20) ###

All In One SEO Pack: by Michael Torbert – 3.3.3
BackupBuddy: by iThemes – 8.5.0.0
Classic Editor: by WordPress Contributors – 1.5
Comet Cache Pro: by WebSharks
Inc. – 170220

Connects - Mailster Addon: by Brainstorm Force – 2.2.0
Contact Form 7: by Takayuki Miyoshi – 5.1.6
Convert Plus: by Brainstorm Force – 3.5.1
Progressive Web Apps For WordPress: by DaftPlug – 3.0
Duplicate Post: by Enrico Battocchi – 3.2.3
Entrada Post Type: by WAITUK – 3.7.9
Entrada VC Addons: by WAITUK – 3.7.9
Entrada WC Taxonomy: by WAITUK – 3.7.9 – Not tested with the active version of WooCommerce
WPBakery Page Builder: by Michael M - WPBakery.com – 6.0.5
Loco Translate: by Tim Whitlock – 2.3.1
Mailster - Email Newsletter Plugin for WordPress: by EverPress – 2.4.6
Slider Revolution: by ThemePunch – 6.1.4
TinyMCE Advanced: by Andrew Ozz – 5.3.0
Widget Importer & Exporter: by ChurchThemes.com – 1.5.5
WooCommerce: by Automattic – 3.8.1
Wordfence Security: by Wordfence – 7.4.2

### Inactive Plugins (4) ###

Akismet Anti-Spam: by Automattic – 4.1.3
Customizer Export/Import: by The Beaver Builder Team – 0.9.1
EventON: by AshanJay – 2.8
EventON - Full cal: by Ashan Jay – 1.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: ?
Force SSL: –
Currency: INR (?)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: booking (booking)
external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #1742 - /shop/
Cart: #1570 - /cart/
Checkout: #1571 - /checkout/
My account: #1664 - /my-account/
Terms and conditions: #2634 - /terms-and-conditions/

### Theme ###

Name: Entrada Child
Version: 3.7.9
Author URL: https://www.waituk.com
Child Theme: ?
Parent Theme Name: Entrada
Parent Theme Version: 3.7.9
Parent Theme Author URL: https://www.waituk.com
WooCommerce Support: ?

### Templates ###

Overrides: entrada/woocommerce/archive-product.php
entrada/woocommerce/cart/cart.php version 3.5.0 is out of date. The core version is 3.8.0
entrada/woocommerce/cart/cart-totals.php
entrada/woocommerce/checkout/cart-errors.php
entrada/woocommerce/checkout/form-billing.php
entrada/woocommerce/checkout/form-checkout.php
entrada/woocommerce/checkout/form-coupon.php
entrada/woocommerce/checkout/form-login.php version 3.4.0 is out of date. The core version is 3.8.0
entrada/woocommerce/checkout/form-pay.php
entrada/woocommerce/checkout/form-shipping.php
entrada/woocommerce/checkout/payment-method.php
entrada/woocommerce/checkout/payment.php
entrada/woocommerce/checkout/review-order.php version 3.3.0 is out of date. The core version is 3.8.0
entrada/woocommerce/checkout/thankyou.php version 3.2.0 is out of date. The core version is 3.7.0
entrada/woocommerce/content-product.php
entrada/woocommerce/content-single-product.php
entrada/woocommerce/emails/email-order-items.php version 3.5.0 is out of date. The core version is 3.7.0
entrada/woocommerce/global/form-login.php
entrada/woocommerce/loop/loop-end.php
entrada/woocommerce/loop/loop-start.php
entrada/woocommerce/myaccount/form-edit-account.php
entrada/woocommerce/myaccount/form-edit-address.php
entrada/woocommerce/myaccount/form-login.php
entrada/woocommerce/myaccount/form-lost-password.php
entrada/woocommerce/myaccount/my-account.php
entrada/woocommerce/myaccount/my-address.php
entrada/woocommerce/myaccount/my-orders.php
entrada/woocommerce/myaccount/orders.php version 3.2.0 is out of date. The core version is 3.7.0
entrada/woocommerce/myaccount/view-order.php
entrada/woocommerce/order/order-details-customer.php
entrada/woocommerce/order/order-details-item.php version 3.0.0 is out of date. The core version is 3.7.0
entrada/woocommerce/order/order-details.php version 3.5.2 is out of date. The core version is 3.7.0
entrada/woocommerce/single-product/rating.php
entrada/woocommerce/single-product.php

Outdated Templates: ?
					
					
						Learn how to update

Sorry to bother you. The problem has been solved. It was being caused due to defered loading of scripts by my WP theme.

Will surely get back if I find more

Thanks

Harsh Vardhan

It’s almost 15 Hrs now….NO Wordcfence API error or wp_wf config problem from the last activation. My host had opened the port 9050 for my domain and whitelisted the site

Just had a chat with the Namecheap Support guys…they do have a server side scurity scanning, but it doesn’t truncate or delete any tables. Also they opened the port 9050 for my site and added it in the whitelist.

From my side – i’ve again deactivated the plughin, dropped the tables and reactivated again..things are working fine …so far.

Will check again in a few hours

Sorry for the late reply

For me it’s MyISAM.

Hello All,

Have been following this thread for the last few days as I’m facing the issue on almost 6 WP installations. I tried dropping the tables and it works for a while..the options are saved, but the problem reappears everytime the wordfence Cron runs. I’m not a coding guy so won’t be able to help much, but would like to share my observations.

I’ve already tried all the suggestions and none seems to work. My hosting guys (Namecheap)also tried to check if anything is currpting the tables, but couldn’t find any.

Also it’s not about plugin conflict as I’ve tried it after deactivating all plugins …but the issue reappears after a day.

Also, don’t thinks it’s theme specific as I’ve 6 different themes but the issue is common to all.

I don’t think it’s a PHP memory limit issue as I’ve 512 MB limit but still Wordfence is not able to save the options…wfconfig.

On the diagnostics page, I can see all the tables are populated instead ne i.e. wfconfig. Somehow the wfconfig table is empty I don’t know whether its curropted.