No Products showing in Categorie view

Hi,

I'm having a few issues with no products showing in any Category views. It was working up till I started adding sub Categories. I've tried deleting the sub categorizes and tried a new category module with no changes. Any suggestions?

kmr

Hi

Can I please see an example of such page ?

Hi, Thanks for your reply.

When in debug mode I receive the following error msg whenever looking at a page that has a category module published.

JDatabaseMySQLi::query: 1146 - Table 'rssequip.km9gp_vm_product' doesn't exist SQL=SELECT content.product_id AS id, COUNT(comments.product_id) AS count FROM km9gp_vm_product AS content LEFT JOIN km9gp_vm_product_reviews AS comments ON comments.product_id = content.product_id WHERE comments.published AND ( content.product_id = 247 OR content.product_id = 246 OR content.product_id = 245 OR content.product_id = 244 OR content.product_id = 243 OR content.product_id = 242 OR content.product_id = 241 OR content.product_id = 240 OR content.product_id = 239 OR content.product_id = 238 OR content.product_id = 237 OR content.product_id = 236 OR content.product_id = 235 OR content.product_id = 234 OR content.product_id = 233 OR content.product_id = 231 OR content.product_id = 228 OR content.product_id = 229 OR content.product_id = 230 OR content.product_id = 224 OR content.product_id = 225 OR content.product_id = 226 OR content.product_id = 227 OR content.product_id = 220 ) GROUP BY comments.product_id ;
Call stack
# Function Location
1 JSite->render() JROOT/index.php:48
2 JDocumentHTML->render() JROOT/includes/application.php:261
3 JDocumentHTML->_renderTemplate() JROOT/libraries/joomla/document/html/html.php:433
4 JDocumentHTML->getBuffer() JROOT/libraries/joomla/document/html/html.php:655
5 JDocumentRendererModules->render() JROOT/libraries/joomla/document/html/html.php:371
6 JDocumentRendererModule->render() JROOT/libraries/joomla/document/html/renderer/modules.php:39
7 JModuleHelper::renderModule() JROOT/libraries/joomla/document/html/renderer/module.php:106
8 include() JROOT/libraries/joomla/application/module/helper.php:175
9 NSP_GK4_Helper->getDatas() JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:28
10 NSP_GK4_VM_Source->getComments() JROOT/modules/mod_news_pro_gk4/helper.php:425
11 JDatabase->loadObjectList() JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.vm.php:382
12 JDatabaseMySQLi->query() JROOT/libraries/joomla/database/database.php:1071
13 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() JROOT/libraries/joomla/error/error.php:251

Page and site can be viewed at www.remotesafetysolutions.com.au

kmr

Hi

Theese errors are strictly connected with VM so You should report it on its developers forum.

You haven't mentioned that category page is not visible at all. Please send me joomla panel access. I'll check couple things.

Hi

I have no idea what's going on ;/ Everything looks to be configured ok. I've checked all reasonable explanations. I've even switched to a different template to check if it's a template issue. But it's not. Category view is not showing with default joomla template as well. Try reinstall VM style located in rest_files package if this will not work I'll send this to programmers. I've found only one even stranger case of such behaviour described in VM forum http://forum.virtuemart.net/index.php?topic=100045.0

Hi

The only thing I've changed was to enable/disable mainbody on frontpage but it was not the case and there were no change at that time. I've also tried to attache VM to a different menu item, but still no category displayed.

Anyway I can see Your site like it was before, so it could be a cache from my changes. Try clear joomla and browser's cache to check.