swinggraphics

Yes! Categories and search are working on my site now. Thank you!

@beknetland and others— You need to start a new topic with these separate issues, please.

Yes, category pages are working now, but not search.

@ehsanfarhangi Please start a new thread for the text replacement issue.

Thank you for looking into this)

“Discontinued Products data update complete. Thank you.”

Using the Storefront theme with only Query Monitor, WC and Discontinued Products active, all category pages display no products.

Main Query:
With DP activated:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
LEFT JOIN wpjk_term_relationships AS tt1
ON (wpjk_posts.ID = tt1.object_id)
WHERE 1=1
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (208)
AND tt1.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 0

With DP deactivated:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
WHERE 1=1
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 6

With DP 1.1.5:

SELECT SQL_CALC_FOUND_ROWS wpjk_posts.ID
FROM wpjk_posts
LEFT JOIN wpjk_term_relationships
ON (wpjk_posts.ID = wpjk_term_relationships.object_id)
WHERE 1=1
AND wpjk_posts.ID NOT IN (397,378,339,332,325,315,305,223)
AND ( wpjk_posts.ID NOT IN (
SELECT object_id
FROM wpjk_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wpjk_term_relationships.term_taxonomy_id IN (45) )
AND ((wpjk_posts.post_type = ‘product’
AND (wpjk_posts.post_status = ‘publish’
OR wpjk_posts.post_status = ‘private’)))
GROUP BY wpjk_posts.ID
ORDER BY wpjk_posts.menu_order ASC, wpjk_posts.post_title ASC
LIMIT 0, 12

Rows: 6

Updating via upload worked, thanks.

I understand. That would be a good feature. Gad knows why GF doesn’t fix this themselves to prevent duplicate payments.

Looking at the revision history, the Design Library blocks may have always been empty, so I’ll just delete those blocks and not worry about it. And removing those fixed the JS errors in the console, so I’ll mark this resolved!

Thank you, that is clear.

In the case of this site, CSS and JS minification and combination are disabled.

I installed WP Crontrol to investigate the cron events. I deactivated and reactivated Speed Optimizer. “siteground_optimizer_check_assets_dir” is not in the list.

I will explore the cache directory next time and try to discern what is taking up so much space, but it definitely would be great if it purged once a day with the cron event.

BTW your File Manger has a bug where it cannot browse some of these directories. Screenshot of the File Manager trying to load endlessly and the contents of the directory in FTP: https://imgur.com/a/6PnSvFd

You guys are the developer

USPS Shipping Method
Version: 4.8.2
Author: WooCommerce

Our server admin finally got around to trying your suggestion @smgdarien, and success! Thank you so much!

@woo-hc folks, please update the system requirements for the plugin.

Thanks @smgdarien! We will give that a try. What do you mean by “regenerating the lookup table”?

In this case, I used WP Sweep to remove Revisions, optimize tables, and then I was able to create a staging site. ??

Support from woo.com has indicated that particular server settings are required. Those should be listed in the system requirements for WC. They also stated that “Adding `SET SQL_MODE=’ALLOW_INVALID_DATES’; to the queries when they are run on your site produces expected results”. It seems to me that the query as run by the WC plugin should include that addition if it produces the intended results.

Despite changing the db server setting as instructed, our Customers table remains empty.

No reply is needed to this thread at this point, but I want to stop it from being marked “resolved” and closed to further replies; because when we do find the solution, I want to be able post it here.

Yes, I understand. But this thread is actually active with suggestions while the paid support is stagnant, so it makes sense from my standpoint to continue here. ???♂? If paid support will take over, that is fine. I will return when/if we fix the problem and mark this resolved. Thank you all for trying to figure this out.

Please note that “Delete Historical Data” does not exist. What I did do was: set max_execution_time set to 500, click “Delete Previously Imported Data”, uncheck “Skip previously imported customers and orders”, click “Start” with “All” selected under “Import historical data”. I get “Status: All historical data imported”. There are no errors in JS console, and only the familiar “Unknown column ‘0000-00-00 00:00:00′” in debug.log.