My products don’t show up

  • Resolved vinorum

    (@vinorum)


    8 years, 3 months ago

    I installed the plugin, when I want to filter by category (or anything), my categories show and I select one but when I click search it shows “No products found matching the filter criteria.” But I do have plenty of products in that category. Help please, I want to try the free version so I can buy the paid one.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author pimwick

    (@pimwick)

    Hi Vinorum,

    Are you able to review the debug.log to see if it contains any messages? We haven’t had any other reports of this issue, I’m wondering if there is something unexpected it is encountering?

    [ Signature deleted ]

    • This reply was modified 7 years, 2 months ago by Jan Dembowski.
    Thread Starter vinorum

    (@vinorum)

    Hmmm, not sure how to do that. I’ll gladly get you a copy of the debug if you help me get there.

    Plugin Author pimwick

    (@pimwick)

    Hello Vinorum,

    We have just released v1.9 of the plugin. You can upgrade this from within the Plugins section of the admin area.

    If you still get no results on v1.9 please attach a screenshot showing your filters and the results.

    As for looking at the debug log, it looks like there is a plugin called “WP Log Viewer” which can help out if you can’t access the filesystem. Typically the debug.log file lives at /wp-content/debug.log if you do have access to your filesystem.

    We’ll get this figured out, sorry you’re having problems!

    [ Signature deleted ]

    • This reply was modified 7 years, 2 months ago by Jan Dembowski.
    Thread Starter vinorum

    (@vinorum)

    Thanks for the reply. I do have access to my system files but the debug log wasn’t there. I updated the plugin but the problem persists. I’m attaching the screenshots of the problem.

    Here you can see the plugin shows all my categories in the filter

    Here you can see there is no result eventhough I have many products there

    Thread Starter vinorum

    (@vinorum)

    Hello, the new version of the plugin now shows the error. Here is what it says:

    Error en la base de datos de WordPress: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
    INSERT INTO pwbe_variations SELECT DISTINCT post.ID AS post_id, parent.ID AS parent_post_id FROM blog_posts AS post JOIN blog_posts AS parent ON (parent.ID = post.post_parent) LEFT JOIN blog_postmeta AS sku ON (sku.post_id = post.ID AND sku.meta_key = ‘_sku’) LEFT JOIN blog_postmeta AS regular_price ON (regular_price.post_id = post.ID AND regular_price.meta_key = ‘_regular_price’) LEFT JOIN blog_postmeta AS tax_status ON (tax_status.post_id = post.ID AND tax_status.meta_key = ‘_tax_status’) LEFT JOIN blog_postmeta AS tax_class ON (tax_class.post_id = post.ID AND tax_class.meta_key = ‘_tax_class’) LEFT JOIN blog_postmeta AS manage_stock ON (manage_stock.post_id = post.ID AND manage_stock.meta_key = ‘_manage_stock’) LEFT JOIN blog_postmeta AS stock ON (stock.post_id = post.ID AND stock.meta_key = ‘_stock’) LEFT JOIN blog_postmeta AS backorders ON (backorders.post_id = post.ID AND backorders.meta_key = ‘_backorders’) LEFT JOIN blog_postmeta AS stock_status ON (stock_status.post_id = post.ID AND stock_status.meta_key = ‘_stock_status’) LEFT JOIN blog_postmeta AS featured ON (featured.post_id = post.ID AND featured.meta_key = ‘_featured’) LEFT JOIN blog_postmeta AS visibility ON (visibility.post_id = post.ID AND visibility.meta_key = ‘_visibility’) WHERE post.post_type = ‘product_variation’ AND ((parent.post_title LIKE ‘%polo%’) )

    Error en la base de datos de WordPress: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
    INSERT INTO pwbe_products SELECT DISTINCT post.ID AS post_id FROM blog_posts AS post JOIN blog_posts AS parent ON (parent.ID = post.ID) LEFT JOIN blog_postmeta AS sku ON (sku.post_id = post.ID AND sku.meta_key = ‘_sku’) LEFT JOIN blog_postmeta AS regular_price ON (regular_price.post_id = post.ID AND regular_price.meta_key = ‘_regular_price’) LEFT JOIN blog_postmeta AS tax_status ON (tax_status.post_id = post.ID AND tax_status.meta_key = ‘_tax_status’) LEFT JOIN blog_postmeta AS tax_class ON (tax_class.post_id = post.ID AND tax_class.meta_key = ‘_tax_class’) LEFT JOIN blog_postmeta AS manage_stock ON (manage_stock.post_id = post.ID AND manage_stock.meta_key = ‘_manage_stock’) LEFT JOIN blog_postmeta AS stock ON (stock.post_id = post.ID AND stock.meta_key = ‘_stock’) LEFT JOIN blog_postmeta AS backorders ON (backorders.post_id = post.ID AND backorders.meta_key = ‘_backorders’) LEFT JOIN blog_postmeta AS stock_status ON (stock_status.post_id = post.ID AND stock_status.meta_key = ‘_stock_status’) LEFT JOIN blog_postmeta AS featured ON (featured.post_id = post.ID AND featured.meta_key = ‘_featured’) LEFT JOIN blog_postmeta AS visibility ON (visibility.post_id = post.ID AND visibility.meta_key = ‘_visibility’) WHERE post.post_type = ‘product’ AND ( ((parent.post_title LIKE ‘%polo%’) ) OR post.ID IN (SELECT parent_post_id FROM pwbe_variations) )

    Plugin Author pimwick

    (@pimwick)

    Great, thank you for the information!

    We have released an update that allows for larger result sets. Please upgrade and let me know if you still get the error.

    [ Signature deleted ]

    • This reply was modified 7 years, 2 months ago by Jan Dembowski.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘My products don’t show up’ is closed to new replies.