no products showing in categorry views

[keith_kmr]

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?

Also no category pages are visible at all.

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