Magento 2.3.3 category view page 2 no product find

[kf_luk]

Hi there,

I experience very strange issue. 

Page 2 of category view show "We can't find products matching the selection."

No matter number of product define each page. Page 2 show the above response.

link:https://newstore.srsworks.com/en/mobile-tablet.html

Click page 2 will show the above sentence.

My setup.

Apache + PHP + Mysql

Varnish + POUND

It would be great if any input for the strange case.

Thanks in advance.

Hilary

[theMageComp]

Hello @kf_luk 

Reindexing command is working properly? 

php bin/magento indexer:reindex

Try this as well
Run MySQL query 

update cataloginventory_stock_item set website_id = 0 where website_id = 1;

and then run in CLI 

php bin/magento index:reindex cataloginventory_stock

Did you ask theme guys regarding this issue?

Also check out this solution http://www.mr-jute.com/?p=2068

[Meetanshi]

Hello @kf_luk 

Please check for any error in the error log and system log in the var/log directory.

If you find any error related to the theme module, you need to contact the theme provider.

You can check if the error is due to the theme or not by changing the theme to the default luma and look for the issue.

Hope it helps.

[kf_luk]

Hi @theMageComp 

Thanks for reply.

Nothing in website_id=1

https://ibb.co/Rzd4MWk

I did reset index status and all index are re-indexed.

https://ibb.co/3fDmCQC

Contacted the theme guy. He said still in progress to fix.

I'm use this theme. 

https://themeforest.net/item/claue-clean-minimal-magento-2-theme/20155150

After install the theme,  Luma theme won't show page 2 product too.

Regards,

hilary

[kf_luk]

Hi @Meetanshi 

I will check the log to see if anything wrong there later today.

But change to Luma theme does not help. Page 2 still no product.

The theme seems override default structure of Magento. 

Say, I can't have default Menu show for other Website.

It must use the theme's Mega Menu.

I'm quite new to Magento, I'm unsure the theme break this or mis-configured.

But I remember my previous theme does not have similar issue.

I tried few so call best seller themes in themeforest and most of them are not work very well with Magento 2. Lot of bugs and not working out of box.

Thanks.

[kf_luk]

Hi @Meetanshi 

I've check the log file. The error is minor issue and should not cause the issue.

I capture part of them here.

Regarding to my current issue. May I know if remove the theme would help?

We already spend months on the theme and the theme guy won't fix.

Regards,

Hilary

[2019-11-20 00:55:10] main.INFO: Broken reference: the 'custom.sidebar.content' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] []
[2019-11-20 00:55:10] main.INFO: Broken reference: the 'megamenu' element cannot be added as child to 'page.top', because the latter doesn't exist [] []
[2019-11-20 00:55:10] main.INFO: Broken reference: the 'header.panel.wrapper' tries to reorder itself towards '', but their parents are different: 'header.container' and '' respectively. [] []
[2019-11-20 00:55:10] main.INFO: Broken reference: the 'navigation.sections' tries to reorder itself towards '', but their parents are different: 'page.top' and '' respectively. [] []
[2019-11-20 00:55:10] main.INFO: Broken reference: the 'custom.sidebar.content' tries to reorder itself towards '', but their parents are different: 'sidebar.additional' and '' respectively. [] []
[2019-11-20 00:55:10] main.INFO: Broken reference: the 'megamenu.script' tries to reorder itself towards 'footer-container', but their parents are different: 'page.wrapper' and '' respectively. [] []

[kf_luk]

I like to provide some update on the issue.

The theme guy disabled the elastic modules (Magento_AdvancedSearch Magento_Elasticsearch Magento_Elasticsearch6) then page 2 is working.

It's totally unacceptable solution as we need elasticsearch to provide quickly search.

[kf_luk · Accepted solution]

After review, this is Magento 2.3.3 bug. 

It was fixed by apply fix "Catalog pagination issue on Elasticsearch 6.x patch for Magento 2.3.3"

Link: https://magento.com/tech-resources/download#download2331

[Anonymous]

I have installed this patch for Elasticsearch 6 but it is not working on magento 2.3.4

[kf_luk]

You may try to change the search to mysql see if you can have 2nd page products. Once your get back the product, then change to Elasticsearch then re-index.

You may need to do it for each category. Once you trigger the Elasticsearch working. The problem will solve.