Database error empty search results

Resolved xszejdi
(@xszejdi)

3 years, 6 months ago
Hello!
Thanks for such great plugin! I hope You are well.
Actually i have two problems with my shop. I know You have a lot of unsolved topics and You are busy.

The first problem is if i search for a product in the WooCommerce products search engine (not text search from Your plugin) without any words, just click ‘search’, i can see database error, if i disable Your plugin and do it again, the error disappears. Take a look, please:

https://i.imgur.com/VTjUBhY.png

Second problem is that i’ve added recommended products under ‘No products found’ by overwriting ‘woocommerce_no_products_found.php’ file and ‘echo do_shortcode [myshortcode]’. It works great if customer looking for something using filtering and there’s no products, recommended products display correctly under ‘No products found’. I noticed, if customer looking for something using WooCommerce products search engine (not text search from Your plugin) and there’s no any products (for example i search: SDffhasajh, there is also ‘No products found’ but i can’t see recommended products below. Looks like it doesn’t ‘catch’ a shortcode. If i disable Your plugin and search the same again (SDffhasajh), i can see normally those recommended products under ‘No products found’ notice.

Best, Mateusz.
- This topic was modified 3 years, 6 months ago by xszejdi.
- This topic was modified 3 years, 6 months ago by xszejdi.

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Support mediawebster
(@mediawebster)

3 years, 6 months ago

Hello

1) Try in file – plugins\woocommerce-products-filter\ext\by_text\index.php – add this code – https://c2n.me/46ouIXl.png

2) Unfortunately, I can’t guess what the problem is. Drop me exact link to the issue
Thread Starter xszejdi
(@xszejdi)

3 years, 6 months ago
Thanks for quick reply @mediawebster,

1. Is something wrong? https://i.imgur.com/PQMI1r5.png > https://i.imgur.com/gMmpWZc.png

2. https://serwer1901590.home.pl/wszystkie-produkty/ Please, set ‘Pierre Rene’ then click the button ‘Zastosuj’. You can see products normally under ‘Brak wyników…’, then clear filtering with ‘Wyczyść’ and please, try type in search for example something like ‘SDFdfhsjfhsjdf’. Products are not displayed anymore.
- This reply was modified 3 years, 6 months ago by xszejdi.
- This reply was modified 3 years, 6 months ago by xszejdi.
Plugin Support mediawebster
(@mediawebster)

3 years, 6 months ago
Hello

1) Better try this code:
```
        if(!isset($request['woof_text']) OR !$request['woof_text']){
            return $where;
        }
```
2) I think the problem is that the search query applies to the shortcode.
You can try in file -plugins\woocommerce-products-filter\index.php delete/comment this code – https://c2n.me/46qFRQH.png – do test please
Thread Starter xszejdi
(@xszejdi)

3 years, 6 months ago

Hello @mediawebster!
1) Your code works great! Erros has gone! One question, what can i do to not lose it after plugin update?
2) Unfortunately, after removing this piece of code, it’s still the same. I really appreciate Your help, i don’t want to take your time anymore on this. I would be grateful if you could answer my one question.

Plugin Support mediawebster
(@mediawebster)

3 years, 6 months ago

Hello

1) I will pass this to the developers. I think they will add code in the next update.

2) Try to use this shortcode to show products on this template:
[woof_products product_ids=”x,y,z”] Where – x,y,z – IDs of the products

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Database error empty search results’ is closed to new replies.

Views