TechPik
Forum Replies Created
-
There are no fatal errors from today. Last fatal error was on 23th March.
2023-03-23T08:48:28+00:00 CRITICAL Uncaught Error: Call to a member function update_status() on null in /home/customer/www/...info/public_html/wp-content/plugins/woocommerce-gateway-stripe/includes/class-wc-stripe-intent-controller.php:683 Stack trace: #0 /home/customer/www/....info/public_html/wp-includes/class-wp-hook.php(308): WC_Stripe_Intent_Controller->update_failed_order_ajax('') #1 /home/customer/www/....info/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array) #2 /home/customer/www/....info/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #3 /home/customer/www/....info/public_html/wp-content/plugins/woocommerce/includes/class-wc-ajax.php(94): do_action('wc_ajax_wc_stri...') #4 /home/customer/www/....info/public_html/wp-includes/class-wp-hook.php(308): WC_AJAX::do_wc_ajax('') #5 /home/customer/www/....info/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array) #6 /home/customer/www/....info/public_html/wp in /home/customer/www/....info/public_html/wp-content/plugins/woocommerce-gateway-stripe/includes/class-wc-stripe-intent-controller.php on line 683Yes the white spaces are too bog. Here is the Checkout page: https://tinyurl.com/mryshvcz
Check the image below. I mean that the black Apple Pay button is working perfectly but if someone uses the Apple Pay option inside Stripe then it does not work.
View post on imgur.com
Similar thing happened with another plugin. The Follow-up plugin is this https://woocommerce.com/products/follow-up-emails/ WordPress Environment WordPress address (URL): https:// Site address (URL): https:// WC Version: 7.3.0 REST API Version: ✔ 7.3.0 WC Blocks Version: ✔ 9.1.5 Action Scheduler Version: ✔ 3.5.3 Log Directory Writable: ✔ WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: ✔ Server Environment Server Info: LiteSpeed PHP Version: 7.4.33 PHP Post Max Size: 1 GB PHP Time Limit: 1500 PHP Max Input Vars: 2000 cURL Version: 7.84.0 OpenSSL/1.1.1p SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.37-MariaDB-log-cll-lve Max Upload Size: 1 GB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ Database WC Database Version: 7.3.0 WC Database Prefix: wpzr_ Total Database Size: 1646.45MB Database Data Size: 1639.78MB Database Index Size: 6.67MB wpzr_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpzr_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_actionscheduler_actions: Data: 0.60MB + Index: 0.21MB + Engine MyISAM wpzr_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_actionscheduler_logs: Data: 0.27MB + Index: 0.21MB + Engine MyISAM wpzr_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_comments: Data: 0.08MB + Index: 0.03MB + Engine MyISAM wpzr_e_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_e_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_e_notes_users_relations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_coupons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_coupon_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_customers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_followup_customer_carts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_followup_customer_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_customer_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_email_excludes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_email_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_followup_email_orders: Data: 0.10MB + Index: 0.03MB + Engine MyISAM wpzr_followup_email_tracking: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_followup_followup_history: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wpzr_followup_order_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_subscribers_to_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_followup_subscriber_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_litespeed_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_litespeed_url_file: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_loginizer_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_newsletter: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_newsletter_emails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_newsletter_sent: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_newsletter_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_newsletter_user_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_options: Data: 3.01MB + Index: 0.10MB + Engine MyISAM wpzr_postmeta: Data: 1618.69MB + Index: 3.30MB + Engine MyISAM wpzr_posts: Data: 4.47MB + Index: 1.45MB + Engine MyISAM wpzr_rank_math_analytics_objects: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_rank_math_internal_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpzr_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wpzr_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpzr_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpzr_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wfblockediplog: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wpzr_wfblocks7: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpzr_wfconfig: Data: 2.07MB + Index: 0.01MB + Engine MyISAM wpzr_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wffilemods: Data: 4.93MB + Index: 0.60MB + Engine MyISAM wpzr_wfhits: Data: 1.05MB + Index: 0.15MB + Engine MyISAM wpzr_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wfissues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wpzr_wfknownfilelist: Data: 3.54MB + Index: 0.18MB + Engine MyISAM wpzr_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wflogins: Data: 0.37MB + Index: 0.08MB + Engine MyISAM wpzr_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpzr_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpzr_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpzr_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wfsnipcache: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpzr_wfstatus: Data: 0.13MB + Index: 0.06MB + Engine MyISAM wpzr_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wpforms_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wpmailsmtp_debug_events: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpzr_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_wt_iew_action_history: Data: 0.20MB + Index: 0.00MB + Engine MyISAM wpzr_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_yoast_seo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpzr_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM Post Type Counts attachment: 43 elementor_cf_db: 20287 elementor_library: 2 follow_up_email: 2 nav_menu_item: 3 page: 12 post: 1 product: 1 revision: 231 shop_order: 32 shop_order_refund: 1 wpcode: 8 Security Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ Active Plugins (16) Akismet Anti-Spam: by Automattic – 5.0.2 Dynamic Content for Elementor: by Dynamic.ooo – 1.9.5.4 Elementor Pro: by Elementor.com – 3.10.1 Elementor: by Elementor.com – 3.10.0 WPCode Lite: by WPCode – 2.0.6 LiteSpeed Cache: by LiteSpeed Technologies – 5.3.2 Loginizer: by Softaculous – 1.7.6 Newsletter: by Stefano Lissa & The Newsletter Team – 7.5.9 Order Export & Order Import for WooCommerce: by WebToffee – 2.3.0 Order Status Rules for WooCommerce: by WPFactory – 2.9.2 Rank Math SEO: by Rank Math – 1.0.106 Follow-Up Emails: by WooCommerce – 4.8.20 WooCommerce: by Automattic – 7.3.0 (update to version 7.4.1 is available) Wordfence Security: by Wordfence – 7.8.2 WP Mail SMTP: by WPForms – 3.7.0 WPForms Lite: by WPForms – 1.7.9.1 Inactive Plugins (3) Contact Form DB - Elementor: by Web Ace Tech Services – 1.8.0 Hello Dolly: by Matt Mullenweg – 1.7.2 W3 Total Cache: by BoldGrid – 2.2.11 Dropin Plugins (3) advanced-cache.php: advanced-cache.php db.php: db.php object-cache.php: object-cache.php Settings API Enabled: – Force SSL: – Currency: USD ($) 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: ✔ Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #20738 - /shop/ Cart: #20739 - /cart/ Checkout: #20740 - /checkout/ My account: #20741 - /my-account/ Terms and conditions: ❌ Page not set Theme Name: Astra Version: 4.0.1 (update to version 4.0.2 is available) Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ Templates Overrides: – Admin Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks 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 Daily Cron: ✔ Next scheduled: 2023-03-03 13:07:30 -05:00 Options: ✔ Notes: 54 Onboarding: completed Action Scheduler Complete: 812 Oldest: 2023-02-13 01:17:08 +0000 Newest: 2023-03-03 04:14:39 +0000 Failed: 36 Oldest: 2022-12-06 13:15:38 +0000 Newest: 2023-03-02 16:10:31 +0000 Pending: 9 Oldest: -0001-11-30 00:00:00 +0000 Newest: 2023-03-10 04:14:02 +0000 Status report information Generated at: 2023-03-02 23:14:52 -05:00 `Hello! I tried it with both “Use order date created” and “Use order date modified” but it still changes the status at the same time.
Thank you very much:)
Hi!
I meant something else. I will describe it as an example.
Rule #1: Change Order Status from Processing to Completed
Time trigger: 2 days
Use Action Scheduler: 1 hour
Now I imported 12 Orders to my website from different website on 10th January 2023 at 11:00
These order dates are from the 8th, 9th and 10th January and with different times.
Now it is 12th January 2023 at 11:00 and all 12 orders are changed from Processing to Completed.
But actually some orders from 8th should have changed to Completed on 10th and 11th January and not all at the same time. So I understand that the Rules take into account the date and time the import was made. How to make it work so that it works with the actual Order dates.Thank you. I got it working but I found the problem that I had earlier. I import orders which all have specific dates, but the Status Rules plugin changes all the Statuses at once. So I understand that it takes into account the date of import.
My question is how to import orders so it takes into account the date and time the order was created? Do I need to use hidden meta data fields?Here is the site: [ expanded into the link field ]
- This reply was modified 3 years, 5 months ago by Jan Dembowski.
- This reply was modified 3 years, 5 months ago by Jan Dembowski.
- This reply was modified 3 years, 5 months ago by Jan Dembowski.
Do you know how to solve the CPU problem or do you know where can I find freelancer to do it?
Thanks for the code, it works nice, but could it be that it is using a lot of CPU? I received the following message from the host (see below). Is it possible that I have too many orders that it needs to process? Can the code be made to check recurring emails from orders that are at most 1 month old?
Website host recorded almost 300 slow SQL queries for the last 24 hours. All of them are SELECT SQL queries and they looks like the one below:Executed 6h 47m 18s ago for 6.566684 sec on Database –> dbk9jpzqg6gvbh
Date: 2023-01-04 06:32:34 Query_time: 6.566684 Rows_examined: 2499816: Rows_sent 1 Lock_time: 0.000330 Query_chars: 425
SELECT COUNT(DISTINCT posts.ID) as total_guest_orders FROM wpdy_posts AS posts INNER JOIN wpdy_postmeta AS postmeta ON postmeta.post_id = posts.ID INNER JOIN wpdy_postmeta AS billing_email ON billing_email.post_id = posts.ID WHERE posts.post_type = ‘shop_order’ AND postmeta.meta_key = ‘_customer_user’ AND postmeta.meta_value = 0 AND billing_email.meta_value IN(‘mica**@liv*.pt’);Thank you for the suggestion. I will try it. May I ask which import plugin did you use. I will test it also.
Thank you, its working perfectly. Thank you.
- This reply was modified 3 years, 5 months ago by TechPik.
Thank you very much. It would be very helpful feature.
Any help?