webdevwalton

Hi there,

Thanks for replying!

Here’s the status report:

` WordPress Environment

WordPress address (URL): https://piesbypost.com<br>Site address (URL): https://piesbypost.com<br>WC Version: 8.3.1<br>REST API Version: ? 8.3.1<br>WC Blocks Version: ? 11.4.9<br>Action Scheduler Version: ? 3.6.4<br>Log Directory Writable: ?<br>WP Version: ? 6.3.2 - There is a newer version of WordPress available (6.4.1)<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_GB<br>External object cache: – Server Environment

Server Info: nginx<br>PHP Version: 8.2.12<br>PHP Post Max Size: 100 MB<br>PHP Time Limit: 43300<br>PHP Max Input Vars: 10000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2

SUHOSIN Installed: –<br>MySQL Version: 8.0.33-25<br>Max Upload Size: 50 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.3.1<br>WC Database Prefix: wp_<br>Total Database Size: 304.64MB<br>Database Data Size: 178.81MB<br>Database Index Size: 125.83MB<br>wp_woocommerce_sessions: Data: 7.02MB + Index: 0.11MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 1.52MB + Index: 0.45MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 36.56MB + Index: 9.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.09MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.22MB + Index: 0.23MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 5.02MB + Index: 5.83MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 4.02MB + Index: 3.63MB + Engine InnoDB<br>wp_automatewoo_abandoned_carts: Data: 1.52MB + Index: 0.08MB + Engine InnoDB<br>wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_customers: Data: 1.52MB + Index: 1.84MB + Engine InnoDB<br>wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_guests: Data: 0.25MB + Index: 0.39MB + Engine InnoDB<br>wp_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_referral_advocate_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_automatewoo_referral_invites: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_bakesheet: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_cf7a_blacklist: Data: 0.28MB + Index: 0.02MB + Engine InnoDB<br>wp_cf7a_wordlist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 1.52MB + Index: 0.56MB + Engine InnoDB<br>wp_comments: Data: 12.52MB + Index: 10.09MB + Engine InnoDB<br>wp_defender_audit_log: Data: 14.52MB + Index: 11.58MB + Engine InnoDB<br>wp_defender_email_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_defender_lockout: Data: 2.52MB + Index: 2.28MB + Engine InnoDB<br>wp_defender_lockout_log: Data: 5.52MB + Index: 3.53MB + Engine InnoDB<br>wp_defender_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_defender_scan_item: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_views: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 1.20MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 7.45MB + Index: 0.30MB + Engine InnoDB<br>wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 44.58MB + Index: 49.16MB + Engine InnoDB<br>wp_posts: Data: 4.52MB + Index: 2.42MB + Engine InnoDB<br>wp_sbi_feed_caches: Data: 0.14MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_posts: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_smartcrawl_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 15.52MB + Index: 18.03MB + Engine InnoDB<br>wp_users: Data: 1.52MB + Index: 1.19MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 1.52MB + Index: 0.52MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_od_time_framemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_od_time_frames: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.17MB + Index: 0.23MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 1.52MB + Index: 1.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 1.52MB + Index: 0.69MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdi_themes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_exported_csv_items: Data: 0.16MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_gc_activity: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cards: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cardsmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wpvivid_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.25MB + Index: 0.22MB + Engine InnoDB Post Type Counts

acf-field: 122<br>acf-field-group: 23<br>attachment: 209<br>custom_css: 1<br>customize_changeset: 1<br>jb_store_css: 10<br>nav_menu_item: 15<br>page: 21<br>pie: 26<br>product: 34<br>product_variation: 9<br>revision: 13<br>shop_coupon: 105<br>shop_order: 8619<br>shop_order_refund: 109<br>side: 13<br>wp_block: 11<br>wp_global_styles: 1<br>wpcf7_contact_form: 1 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (26)

Advanced Custom Fields PRO: by WP Engine – 6.2.3<br>AutomateWoo - Refer A Friend Add-on: by WooCommerce – 2.6.13<br>AutomateWoo: by WooCommerce – 5.5.22<br>WP Engine Smart Plugin Manager: by WP Engine – 5.17.30<br>Contact Form 7: by Takayuki Miyoshi – 5.8.3<br>Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.5<br>Facebook for WooCommerce: by Facebook – 3.1.4<br>Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.21.0<br>Site Kit by Google: by Google – 1.114.0<br>Smash Balloon Instagram Feed: by Smash Balloon – 6.2.6<br>Jetpack Boost: by Automattic - Jetpack Site Speed team – 2.2.0<br>Mailchimp for WooCommerce: by Mailchimp – 3.3<br>Performance Lab: by WordPress Performance Team – 2.7.0<br>Post Types Order: by Nsp Code – 2.1.1<br>Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6<br>Lazy Load - Optimize Images: by WP Rocket – 2.3.6<br>TinyPNG - JPEG, PNG & WebP image compression: by TinyPNG – 3.4.3<br>Trustpilot-reviews: by Trustpilot – 2.5.925<br>WooCommerce Stripe Gateway: by WooCommerce – 7.7.0<br>WooCommerce Gift Cards: by WooCommerce – 1.12.1<br>WooCommerce Order Delivery: by Themesquad – 2.2.3<br>WooCommerce Shipping & Tax: by WooCommerce – 2.4.0<br>WooCommerce - ShipStation Integration: by WooCommerce – 4.3.9<br>WooCommerce: by Automattic – 8.3.1<br>Yoast SEO: by Team Yoast – 21.5<br>WP Migrate: by WP Engine – 2.6.10 Inactive Plugins (8)

AntiSpam for Contact Form 7: by Codekraft – 0.4.5<br>Branda Pro: by WPMU DEV – 3.4.9.3<br>MonsterInsights - Ads Addon: by MonsterInsights Team – 1.8.1<br>MonsterInsights - eCommerce Addon: by MonsterInsights Team – 8.4.0<br>MonsterInsights - EU Compliance: by MonsterInsights Team – 2.2.7<br>MonsterInsights Pro: by MonsterInsights – 8.17<br>SmartCrawl Pro: by WPMU DEV – 3.6.4<br>Smush: by WPMU DEV – 3.15.1 Dropin Plugins (2)

advanced-cache.php: advanced-cache.php<br>object-cache.php: Performance Lab Server Timing Object Cache Drop-In Must Use Plugins (6)

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0<br>WP Engine Cache Plugin: by WP Engine – 1.1.4<br>WP Engine Seamless Login Plugin: by WP Engine – 1.6.1<br>WP Engine Security Auditor: by wpengine – 1.1.1<br>WP Engine System: by WP Engine – 5.0.1<br>WP Migrate Compatibility: by Delicious Brains – 1.3 Settings

API Enabled: –<br>Force SSL: –<br>Currency: GBP (￡)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: bundle (bundle)<br>custom_bundle (custom_bundle)<br>custom_pack (custom_pack)<br>external (external)<br>flexible_pack (flexible_pack)<br>grouped (grouped)<br>mix and match (mix-and-match)<br>pack (pack)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)

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

Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop base: #6 - /shop/<br>Basket: #7 - /basket/<br>Checkout: #8 - /checkout/<br>My account: #9 - /my-account/<br>Terms and conditions: #580 - /terms-conditions/ Theme

Name: Pies By Post<br>Version: 1.0<br>Author URL: https://alexwalton.dev/<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ? Templates

Overrides: pies-by-post/woocommerce/global/wrapper-end.php<br>pies-by-post/woocommerce/global/wrapper-start.php Gift Cards

Database Version: 1.12.1<br>Loopback Test: ?<br>Task Queueing Test: ? Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-virtual-downloadable<br>product-external-affiliate<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-11-27 17:12:34 +00:00<br>Options: ?<br>Notes: 143<br>Onboarding: completed Action Scheduler

Canceled: 281<br>Oldest: 2023-10-28 10:52:57 +0000<br>Newest: -0001-11-30 00:00:00 +0000

Complete: 15,307<br>Oldest: 2023-10-28 00:26:20 +0000<br>Newest: 2023-11-27 12:57:28 +0000

Pending: 6<br>Oldest: 2023-11-27 12:57:57 +0000<br>Newest: 2023-12-25 20:54:00 +0000 Order Delivery

Minimum working days: 2<br>Checkout location: Before order notes<br>Checkout options: calendar<br>Max delivery days: 90<br>Delivery fields: required<br>Enable local pickup: ?<br>Overrides: - Shipping Days

Sunday: ?<br>Cut-off time: 14:00

Monday: ?<br>Cut-off time: 15:00

Tuesday: ?<br>Cut-off time: 15:00

Wednesday: ?<br>Cut-off time: 15:00

Thursday: ?<br>Cut-off time: 15:00

Friday: ?<br>Cut-off time: 15:00

Saturday: ?<br>Cut-off time: - Delivery Ranges

Default: 1 - 40<br>Shipping methods: - Delivery Days

Sunday: ?<br>No of orders: 0<br>Shipping methods: all<br>Time frames: no

Monday: ?<br>No of orders: 0<br>Shipping methods: all<br>Time frames: no

Tuesday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Wednesday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Thursday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Friday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Saturday: ?<br>No of orders: 200<br>Shipping methods: all_except<br>Time frames: no Status report information

Generated at: 2023-11-27 12:58:02 +00:00<br>`

Hi @emermatomo,

This error occurs when attempting to create any new user, no matter if the user has previously had an account on the site or not. I’ve attempted to clear the database previously, and that didn’t resolve the issue.

Appreciate it’s a tough one as you don’t have access to the codebase or server access ??

Is there any more support/other suggestions we could try?

Thank you,

Alex

Hi @emermatomo ,

The?[email protected] user did not have any existing account previously. This happens for any new user that is created.

Any ideas?

@emermatomo Sure. Here’s the log that’s created when attempting to add a new user:

{
"installName": "footprintas",
"environment": "PROD",
"type": "error",
"date": "2023-05-19T16:14:31.000Z",
"severity": "notice",
"client": "80.3.238.45:0] WordPress database error Duplicate entry '[email protected]' for key 'uniq_email' for query INSERT INTO wp_matomo_user (login, password, email, date_registered, superuser_access, ts_password_modified, idchange_last_viewed, invited_by) VALUES ('wp_developer', '$2y$10$PF6KFE0zdEIAIlZ1hvTKn.EYlTuWg79gFpycN119B62gsjUQG8npq', '[email protected]', '2023-05-19 16:14:31', '0', '2023-05-19 16:14:31', NULL, NULL) /* From [footprint.no/wp-admin/user-new.php] in [/nas/content/live/footprintas/wp-content/plugins/matomo/classes/WpMatomo/Db/WordPress.php:459",
"message": "*/ made by edit_user, wp_insert_user, WP_User->set_role, do_action('add_user_role'), WP_Hook->do_action, WP_Hook->apply_filters, WpMatomo\\User\\Sync->sync_current_users_1000, WpMatomo\\User\\Sync->sync_users, WpMatomo\\User\\Sync->ensure_user_exists, Piwik\\Plugins\\UsersManager\\Model->addUser, Piwik\\Db\\Adapter\\WordPress->insert, referer: https://footprint.no/wp-admin/user-new.php",
"uuid": "2718a7fe-251e-4b35-ab2d-90f7cdaddba9"
}

• This reply was modified 1 year, 9 months ago by webdevwalton.

Hi @emermatomo ,

I disabled the Matomo plugin, and the issue dissapeared. When I re-enable Matomo and try again, I’m hit with the same problem mentioned previously.

Any ideas?

Thanks,

Alex

Hi there,

I added the config line:

define( 'MATOMO_SUPPORT_ASYNC_ARCHIVING', false );

However I’m still getting issues when attempting to create a new user, and sign in as that new user.

Any suggestions?

Thanks, Alex

• This reply was modified 1 year, 10 months ago by webdevwalton.

Hi @emermatomo ,

Thanks for getting back to me.

I’ve attempted the above, but we’re still getting issues when adding new users.

Do you have any other suggestions?

Thanks for your help,

Alex

Hi Dimitar,

Thanks for this. Noticed that my images being added via PHP’s sprintf function aren’t getitng lazy loading applied to them.

Is there a technical reason as to why this could be the case?

Thanks,
Alex

Hi Plamen,

I am the website developer, haha.

I’ve only a few plugins installed, and implemeneted the img elements in a standard way. This is why I’m confused as to the behaviour of the lazyload..

Thanks,
Alex

Hi Dimitar,

Thanks for your response.

I haven’t added the img elements in any non-standard way. They’re standard img elements with a few classes.

Any ideas why it would strip out the necessary data-src attribute?

Thanks

I’ve also just noticed that the images aren’t in the correct ‘WebP’ format. Any ideas there?