swinggraphics

I see you’ve reached out to us via email about this issue so I’ll mark this thread as solved.

I will mark this resolved when the issue is resolved. Yes, I opened an email ticket 4 days ago, but so far they have not taken any direct action, and they asked me to follow up to this thread.

In the meantime, I suggest increasing your PHP time limit

Changing the the max execution time has no effect. It still shows the “No data to display” message after about 2 seconds.

deleting/re-importing the customer data, as mentioned in my previous reply

As mentioned in a previous reply of mine, I did this already. Truth be told, I did it three times.

wp_wc_customer_lookup has 2784 rows.

Kindly locate the?wp_users?table in the database, and see if the entries are all there (they should be more than 2 thousand, for customers only).

There are 190 users with the Customer role. This feels reasonable, assuming most people check out as a guest.

Subsequently, take a look at the?wp_usermeta?table, also?– preferred billing/shipping information. WooCommerce saves the order billing/shipping information as user meta. In this way, this information will be available for future orders and a faster checkout process.

This needs clarification. Obviously I can’t read through all the usermeta and would not know if anything is awry even if I could. And why do we care about the billing/shipping information right now?

Have there been any recent modifications to the database structure, such as changes in column names, data types, or configurations, that might coincide with when the issue started occurring?

I don’t know. Did WC make any such changes in an update? Certainly nobody is editing the database manually.

Were there any recent data import/export processes or migrations that could have impacted the data integrity within the WooCommerce customer tables?

No

Apart from WooCommerce updates, have there been any updates to WordPress core, server software, or any other related software components that might have coincided with the emergence of this issue?

Unfortunately, nobody remembers looking at the Customers page before, so we have no idea when it broke.

Sounds like a great idea. Please try the recommendations out and keep us updated.

??? I feel pretty sure I’ve been clear that I have tried every suggestion with no success.

Could you confirm of any other plugins or custom code running on your staging site as well as your productions site?

As I already said twice, staging has only WC and Storefront active. This is the only thing we need to be concerned with. I am obviously not going to experiment on production.

Thanks, everyone, for the ideas. We’ll keep trying.

Staging was not showcasing the same issue before 8.4.0. Correct?

The problem was present on staging with 8.3.0, and still present after updating.

HPOS?is enabled, or otherwise? Currently, or at some other point in time.

I’m sure it has never been enabled.

Sure, that is worth a try. I cleared the analytics cache, set the Date Type, ran Delete Previously Imported Data, and then ran Re-import Data. On the Customers page, the number of customers changed to 2,784customers (up from 2,194), but still none show in the table.

Also to note: this staging copy of the website was created some months ago and is used to preflight updates before applying to production. This issue with the customers list exists on both staging and production. It was suggested that there’s a problem with the database itself. If that is the case, it has been an unnoticed problem for a long time, or a specific update caused it on staging and production independently.

From the error log you provided, it seems like the issue is related to the?0000-00-00 00:00:00?value in the?date_last_active?field. This could potentially be a date formatting issue or a problem with the database itself.

I think a value of 0000-00-00 00:00:00 would not be a problem. I understandUnknown column '0000-00-00 00:00:00' in 'field list' means it is trying to find a column named 0000-00-00 00:00:00. Obviously that is not going to work.

I tried all the Clear tools and flushed permalinks.

As already noted:

• Storefront is the active theme.
• WooCommerce is the only active plugin.
• All Status page items are green or gray (ie, compatible / up-to-date).

`
### WordPress Environment ###

WordPress address (URL): removed
Site address (URL): removed
WC Version: 8.4.0
REST API Version: ? 8.4.0
WC Blocks Version: ? 11.6.2
Action Scheduler Version: ? 3.7.0
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.41 (Ubuntu)
PHP Version: 8.0.20
PHP Post Max Size: 16 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 8.0.30
Max Upload Size: 16 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.4.0
WC Database Prefix: wpjk_
Total Database Size: 107.97MB
Database Data Size: 71.45MB
Database Index Size: 36.52MB
tables list removed

### Post Type Counts ###

attachment: 604
custom_css: 1
gift_card: 8
nav_menu_item: 36
page: 16
post: 1
product: 169
product_variation: 304
revision: 343
shop_coupon: 4
shop_order: 3664
shop_order_refund: 9
wc_afrsm: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (1) ###

WooCommerce: by Automattic – 8.4.0

### Inactive Plugins (30) ###

removed

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
gift-card (gift-card)
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 Woo.com: ?
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### WC Pages ###

Shop base: #5 - /shop/
Cart: #6 - /cart/
Checkout: #7 - /checkout/
My account: #8 - /my-account/
Terms and conditions: #55 - /terms-conditions/

### Theme ###

Name: Storefront
Version: 4.5.3
Author URL: https://woocommerce.com/
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
product-block-editor
coupons
core-profiler
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
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: customize-store
minified-js
new-product-management-experience
product-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-12-14 17:24:55 -05:00
Options: ?
Notes: 137
Onboarding: completed

### Action Scheduler ###

Complete: 170
Oldest: 2023-11-13 11:15:54 -0500
Newest: 2023-12-14 01:04:10 -0500

Pending: 6
Oldest: 2023-12-14 14:22:41 -0500
Newest: 2023-12-14 14:22:41 -0500

Failed: 344
Oldest: 2020-06-25 17:01:43 -0400
Newest: 2023-05-31 08:01:05 -0400


### Status report information ###

Generated at: 2023-12-14 01:04:11 -05:00
`

@woo-hc My post includes a screenshot. I cannot provide the full system report. If necessary, I can post specific info from the WC status report, but nothing looks relevant; everything is green or regular gray.

This occurs with the YouTube integration specifically, as the YouTube integration will use the placeholder from the actual embedded video itself.

It was not doing that before, but it is now! This is perfect. Before, it was showing the generic default placeholder image in the plugin’s assets folder.

The bug still exists, but I cannot waste more time on it.

With combine JS enabled in Optimizer, the script tag is removed from the page. The filter does not work to keep it on the page. The script is not added by Complianz. It really doesn’t matter how it gets added to the page, as Optimizer runs on the generated code. After going in circles with chat, they opened a ticket. The reply to the ticket was “you can disable JS combining”. I am leaving it at that because it isn’t worth the time. But it is frustrating and disappointing.

I noticed the Account Details link on the Plugins page. Deactivated the existing connections, then the normal interface appeared on the Malcare admin page.

I’m asking on this thread because the suggestion to regenerate WebP seems to have resolved it, but I do not see a “Regenerate WebP” option anywhere.

My site has lots of images that are not served as WebP. “Regenerate WebP images”—How do we do that?