Hello.
I have ~17000 products in catalog.
If i enable Flat Catalog Product mode, module doesn’t appear anymore.
I tried to solve the problem myself and finally came to these lines:
/app/code/local/JoomlArt/JmCategoryList/Block/List.php
PHP Code:
$products->getSelect()->joinLeft(
array('_reviewed_order_table'=>$products->getTable('review_entity_summary')),
"_reviewed_order_table.store_id=$storeId AND _reviewed_order_table.entity_pk_value=e.entity_id",
array()
);
The module dies after this line if Flat Catalog Product mode is enabled. Shop still works, but doesn’t show the module.
php memory limit is set to 812M
14 answers
Hi Alexey!
Could you give us the login information FTP/Admin account to your support ticket BIQ-582-73223 in http://support.joomlart.com. I’ll check for you.
Thank you.
Ok. I did it. Remember that the system uses full-page caches, so refresh all "caches" very time you change something. And please let me know what exactly you change in the code, i hope it’s not a big deal. thanks.
http://support.joomlart.com/index.ph…ket/View/76870
Hi Alexey!
I haven’t seen your info. Please update it again.
Thank you.
Hello.
First time I updated the one you mentioned. But there are 3 similar tickets and now and i updated info in all of them.
http://support.joomlart.com/index.ph…ket/View/76870 AFA-328-32250
http://support.joomlart.com/index.ph…ket/View/76871 BIQ-582-73223
http://support.joomlart.com/index.ph…ket/View/76844 NTN-691-76872
I’ll follow you in BIQ-582-73223, please close other tickets. I have received your info. Thanks for giving it. I have checked and seen that you forgot to reindex data after change products and category to flat type. Please go to admin -> system -> index manager and click to submit button. I have done this for you and now the category list works well.
Please tell me if you need more help.
Thank you.
No, it doesn’t work!
It works only for "latest product" and "most viewed". if i choose "most reviewed" it doesn’t show up. i have "most reviewed" module in cms block named "position-10". If i remove the module from the block it works fine, if i put it again, module doesn’t work at all (even html).
The problem is here
/app/code/local/JoomlArt/JmCategoryList/Block/List.php
$products->getSelect()->joinLeft(
array(‘_reviewed_order_table’=>$products->getTable(‘review_entity_summary’)),
"_reviewed_order_table.store_id=$storeId AND _reviewed_order_table.entity_pk_value=e.entity_id" ,
array()
);
Also there is a similar problem with Product Slider if i choose any variant different from "latest procucts"
PS.
1. full-page cache still works even if you "disable" it in the cache manager. so please "refresh" this "Magento Booster" option in the cache management.
2. position-10 renders on the top the second column (under videos) on the home page.
Hi Alexey Bezugly!
I’m checking it as well but still couldn’t find the resolution. Please allow me more time.
Thank you.
Hello, 1.5 months passed. Now nobody even replies on support ticket (BIQ-582-73223). I’m still waiting.
Please can you tell me about your error now. may with a Screenshot please.
It’s all the same, You didn’t fix anything. If I use "most-reviewed" option and Flat Catalog Product mode the JmCategoryList module doesn’t show up. For example in in Static Block "position10" (top in the second column on the home page). If i choose any other option it works. Please fix it a soon as possible. Why does it take so long?
Hello.
If you don’t work on this problem just tell me. I’m shocked. 4 months passed and you did nothing.
I tried in lots of ways, Nothing Worked.
Are you the only programmer in the company? And please tell me exactly what you tried.
I have tried altering the Queries in the Module.
