pingbara
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] WooCommerce database update in progress foreverI have found something a bit strange, not sure it is normal or not. I have cleared many “fail”, “pending” and very old hooks (such as year 2022-2023) in the table “wp_actionscheduler_actions” by using phpMyAdmin. Those hooks removed are hooks from WooCommerce and some from other caching plugin.
However, it seems the hooks removed succesfully from phpMyAdmin still shown up in my wordpress dashboard Scheduled Actions page as a pending and others !. Should the hooks in WordPress Scheduled Actions same as the hooks in the table named “wp_actionscheduler_actions” ?
Forum: Plugins
In reply to: [WooCommerce] WooCommerce database update in progress foreverI have tried deactivated all the plugins except from the WooCommerce. The result is alomost the same. But now the “pending” job of 796,513 items in Scheduled Actions page has decreased to 792,800, I can’t remember that whether the pendding jobs used to decrease or not before settinng up the server side cron on the day before yesterday. So, it means if I can wait until the pending job becomes “0” (zero), then the database updating will be completed, am I right ?
My hosting provider dose not allow “WooCommerce WP-CLI” That is so sad. Do you have any other way to do it now ? T__T
As per your recommendation to look at this thread, In the post they fixed the problem by adding below codes. Is it safe to do? If I do it and nothing change, how can I revert back to code:
ALTER TABLEwp_actionscheduler_actions
ADDprioritytinyint(10) unsigned NOT NULL;PS) I clicked to see all the pending jobs around 70,000 jobs, it shown a lot of hooks consisting of a big piles of hooks from WooCommerce and some caching plugins, all of them are extrelemy old, such as year 2022 or 2023. Should I delete them will be better? So they will not be pending jobs ? How to delete ? deleting through wordpress dashboard can do only 10 items at a time. It is nearly impossible to finish 70,000 items by this method.
Forum: Plugins
In reply to: [WooCommerce] WooCommerce database update in progress foreverHi ,so apologise for my late reply. I have spent most of my time on solving this problem but I totally failed. I have very limited knowledge about coding and database stuff. I have never thought that using wordpress will be this hard. I have searched for information on how to solve this problem on the internet and then i tried many methods but none of them work at all:
- I have tried disabled the wp-cron. Then enabled the real cron job (server side cron job). This does not work.
- I have tried removing some hooks in the table named
wp_actionscheduler_actions. Those hooked removed are the hooks belong to some cache plugin that piled up and marked with the status “fail”. And I have also removed the WooCommerce’s hooks those are very old (1year ago) and marked with status “fail”. In total, can reduced the database size for almost 800MB. This method does not work. - I have tried clearing “Clear transients” and “Clear expired transients” in wooCommerce tools. This does not work.
- I have tried deactived and even removed and reinstalled the woocommerce plugin. This does not work.
- Lastly, i have tried manually clicking update the wooCommerce database one by one. It took vey long time to finish. But after finished, then some more updates were shown up into my system to manually update like forever. This does not work.
Below is my System Status Report: (I have hided my prefix for security reason, if you need full prefix please tell me.)
` WordPress Environment WordPress address (URL): https://www.xn--72c0amvsjca4a5b9cwc.com Site address (URL): https://www.xn--72c0amvsjca4a5b9cwc.com WC Version: 8.9.2 REST API Version: ✔ 8.9.2 Action Scheduler Version: ✔ 3.7.4 Log Directory Writable: ✔ WP Version: 6.5.4 WP Multisite: – WP Memory Limit: 800 MB WP Debug Mode: – WP Cron: – Language: en_US External object cache: – Server Environment Server Info: Apache/2 PHP Version: 8.0.30 PHP Post Max Size: 800 MB PHP Time Limit: 600 PHP Max Input Vars: 10000 cURL Version: 7.87.0 OpenSSL/1.1.1w SUHOSIN Installed: – MySQL Version: 10.6.17-MariaDB-cll-lve Max Upload Size: 800 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ Database WC Database Version: 7.7.0 WC Database Prefix: wp_ Total Database Size: 1479.84MB Database Data Size: 1091.37MB Database Index Size: 388.47MB wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 517.00MB + Index: 252.70MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.17MB + Index: 0.11MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 78.63MB + Index: 54.14MB + Engine InnoDB wp_ahrefs_seo_content: Data: 14.55MB + Index: 6.41MB + Engine InnoDB wp_ahrefs_seo_snapshots: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_comments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_defender_audit_log: Data: 3.52MB + Index: 1.08MB + Engine InnoDB wp_defender_email_log: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_defender_lockout: Data: 2.52MB + Index: 1.23MB + Engine InnoDB wp_defender_lockout_log: Data: 9.52MB + Index: 7.94MB + Engine InnoDB wp_defender_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_defender_scan_item: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_section_storage: Data: 0.11MB + Index: 0.06MB + Engine InnoDB wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_sliders: Data: 0.09MB + Index: 0.03MB + Engine InnoDB wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB wp_options: Data: 5.23MB + Index: 0.13MB + Engine MyISAM wp_postmeta: Data: 205.54MB + Index: 11.08MB + Engine MyISAM wp_posts: Data: 62.10MB + Index: 4.25MB + Engine MyISAM wp_responsive_menu: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_smush_dir_images: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_terms: Data: 0.28MB + Index: 0.26MB + Engine MyISAM wp_term_relationships: Data: 0.11MB + Index: 0.25MB + Engine MyISAM wp_term_taxonomy: Data: 0.05MB + Index: 0.04MB + Engine MyISAM wp_usermeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wcsc_logs: Data: 1.13MB + Index: 0.86MB + Engine InnoDB wp_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_orders: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_websitez_stats: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpr_above_the_fold: Data: 1.74MB + Index: 0.11MB + Engine MyISAM wp_wpr_rocket_cache: Data: 6.07MB + Index: 1.26MB + Engine MyISAM wp_wpr_rucss_used_css: Data: 20.93MB + Index: 3.14MB + Engine MyISAM wp_yoast_indexable: Data: 113.67MB + Index: 17.09MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 2.52MB + Index: 4.55MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 42.58MB + Index: 20.06MB + Engine InnoDB wp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB Post Type Counts attachment: 46324 custom_css: 3 elementor_library: 3 envira: 1 itsec-dash-card: 10 itsec-dashboard: 2 nav_menu_item: 145 oembed_cache: 8 page: 535 post: 298 product: 174 pt_view: 1 revision: 638 rmp_menu: 1 safecss: 1 slideshow: 5 smartblock: 1 sp_wp_tabs: 2 tablepress_table: 1 text-blocks: 80 wd_ip_lockout: 224 wd_iplockout_log: 5002 wdscan_result: 2 wp_block: 1 wp_navigation: 1 wpcode: 2 wplp-news-widget: 1 Security Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ Active Plugins (23) Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2 Classic Editor: by WordPress Contributors – 1.6.3 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5 GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20.2 Image Widget: by The Events Calendar – 4.4.9 WPCode Lite: by WPCode – 2.1.12 Post Tags and Categories for Pages: by curtismchale – 1.4.1 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6 Responsive Menu: by ExpressTech – 4.3.5 Text Blocks: by Hal Gatewood – 1.5.3 Seed Fonts: by Seed Webs – 2.4.2 Smart Slider 3: by Nextend – 3.5.1.23 Stars Rating: by Fahid Javid – 4.0.3 WooCommerce: by Automattic – 8.9.2 Yoast SEO: by Team Yoast – 22.8 WP Gallery Custom Links: by johnogg – 1.12 Hummingbird Pro: by WPMU DEV – 3.8.1 WP Rocket | Logging cron periodicity: by WP Rocket Support Team – WP Rocket: by WP Media – 3.16 WP SEO Structured Data Schema: by WPSEMPlugins – 2.7.10 Smush Pro: by WPMU DEV – 3.16.4 WP Tabs Pro: by ShapedPlugin – 2.2.1 WPMU DEV Dashboard: by WPMU DEV – 4.11.26 Inactive Plugins (4) Redis Object Cache: by Till Krüss – 2.5.2 WP-Cron Status Checker: by Webhead LLC – 1.2.5 WP Rocket | Change Preload Parameters: by WP Rocket Support Team – Yoast Test Helper: by Team Yoast – 1.18 Dropin Plugins () advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php Settings API Enabled: – Force SSL: – Currency: THB (฿) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: 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: – Enforce Approved Product Download Directories: ✔ HPOS feature enabled: ✔ Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: – Logging Enabled: ✔ Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 8 MB WC Pages Shop base: ❌ Page not set Cart: ❌ Page ID is set but the page does not exist Checkout: ❌ Page ID is set but the page does not exist My account: ❌ Page ID is set but the page does not exist Terms and conditions: ❌ Page not set Theme Name: Spacious Child by Methee Version: 1.0.0 Author URL: https://themegrill.com/wordpress-themes/ Child Theme: ✔ Parent Theme Name: Spacious Pro Parent Theme Version: 2.6.7 Parent Theme Author URL: https://themegrill.com/wordpress-themes/ WooCommerce Support: ✔ Templates Overrides: – Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management product-virtual-downloadable product-external-affiliate product-grouped product-linked product-pre-publish-modal product-custom-fields remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings async-product-editor-category-field launch-your-store Daily Cron: ✔ Next scheduled: 2024-06-06 15:50:37 +07:00 Options: ✔ Notes: 173 Onboarding: completed Action Scheduler Complete: 63,094 Oldest: 2024-05-06 09:43:46 +0700 Newest: 2024-06-06 00:00:20 +0700 Pending: 796,513 Oldest: 2023-05-13 07:15:39 +0700 Newest: 2024-06-06 00:00:27 +0700 Failed: 26,013 Oldest: 2022-11-02 09:47:45 +0700 Newest: -0001-11-30 06:42:04 +0642 Canceled: 351 Oldest: 2024-05-10 20:43:53 +0700 Newest: 2024-05-20 14:58:11 +0700 Status report information Generated at: 2024-06-06 09:43:46 +07:00 `Below is the error that my hosting gave me, they said that this might cause the poroblem but i don’t know what to do with this error report:
woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php
[host http://www.xn--72c0amvsjca4a5b9cwc.com] Backend fatal error: PHP Fatal error: Uncaught InvalidArgumentException: Unidentified action 3039985 in /home/comcom/domains/xn--72c0amvsjca4a5b9cwc.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:1086\nStack trace:\n#0 /home/comcom/domains/xn--72c0amvsjca4a5b9cwc.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(305): ActionScheduler_DBStore->mark_failure()\
Please help. It seems this problem slowdown my wordpress admin area also.
Best Regards,
Methee S
- This reply was modified 1 year, 11 months ago by pingbara.
Forum: Plugins
In reply to: [WooCommerce] WooCommerce database update in progress foreverI check database and found that the size of _actionscheduler_action is almost reaching 1GB now ! Is this normal?
I have one last question.
If I have the ‘redirect attachment URLs to the attachment itself’ toggle set to ‘YES’.
Then all my attachment pages will be eliminated, I have just re-checked that the amount of attachment pages are around 20000 pages !!. Then in Google Search Console there will be 404 error for 20000 pages as the attachment page are eleminated. If the spider bot comes fast then maybe within a night or a week there will be 20000 of 404 pages !!
Will such a huge amount of 404 pages affect the overall ranking of my home page or other pages which are rich in content?
Or will it be better for google if I i do 410 redirect for those deleted attachment pages. Or i can simply let it be 404 pages
Yes, correct I want the conaical url of the attachment page to be the attachment page itself. I think many types of businsess such as photography, the attachement pages are very important if modified correctly.
I have taken a look in your recommended developr filter, I can’t find the code to fix my question. I don’t think I can do the filter for my problem. It is so difficult for me. I don’t know much about coding I know only some basic html and css that is why i rely on wordpress to build my sites.
Hi, with your second answer below:
2. If you have the ‘redirect attachment URLs to the attachment itself’ toggle set to ‘no’, then it won’t redirect to the image itself. You’ll also be able to configure the attachment pages and check if you want them to show up in the search results or not. If you have it set to ‘no’ for the ‘show in the search results’ option, then the attachment page itself will have a ‘noindex’ tag and won’t show up in the search results. You also won’t have to worry about it being flagged as thin content.
==> in this case i understand now that the attachment page is safe from thin content as it will not be indexed. But how about the image itself (not attachment page), will the image be able to be indexed by google and shown in image search result.
@suwash kunwar
No, you cannot use the “site: followed by url+slug” for the non English url.
I can confirm that this URL is indexed and ranked in google, please see below snapshot:https://drive.google.com/file/d/1-G8Q1QO3ypQGfScRqw-1DVwHIyhP_EEQ/view?usp=sharing
Anyway, this is not the main problem. My main problem is that “why my attachment page is not automatically self-canonicalize ?” Please see below screenshot for more information:
https://drive.google.com/file/d/1AyG3dHyQYPCfH6E3aMHqBlzpRh-luM7S/view?usp=sharing
Thanks
Methee S.- This reply was modified 5 years ago by pingbara.
The problem is that i DID NOT set the redirect attachment page to attachment itself to ‘yes’.
But the canonical url is not self-canonicalize. Instead, its canonical url point to “the image file”.You can check the url above that i have provided.
Hi
I have done [Resetting the Indexables and Migrations] and [Run SEO data optimization] but the problem is not solved.
Thanks
MetheeI am new to wordpress, i cannot understand at all above the word “filter” anyway I will try to study.
Thanks
which plugin that you used it to clone the pages ?
Hi thank you fro your reply
I can confirm that the post (textblock) has a title name.
By resetting the Yoast SEO Indexables, will I lost any plugin configurations that I am currently have at this moment? after reseting do i need to re-configure the plugin ?
will there be any bad effect on SEO* More information:
Those posts having errors are created by using th “Reusable Text Blocks Plugin”.Best Regards,
Hi thanks for your reply
Below is the link
https://www.พวงหรีดธรรมะ.com/text-blocks/รายชื่อวัดในจังหวัดอำน/