Working Enviroment.
Joomla 1.5.23
Virtuemart 2.0 SVN revision 3511 (last update 6/16/2011 2:41PM)
Steps:
After reset all tables and get sample data proceed to Products in Control panel change Display number to 5, and click on page 2 link.
Bug: All products dissapear. And you have to logout and login from joomla to see them again.
***SOLVED***
MILBO thank you .
Thanks, we will take a look on it.
If Joomla 'Debug System' is enabled, the error log for this one shows:
500 - •An error has occurred.•
JDatabaseMySQL::query: 1052 - Column 'ordering' in order clause is ambiguous SQL=SELECT jos_virtuemart_products.`virtuemart_product_id` FROM jos_virtuemart_products LEFT OUTER JOIN jos_virtuemart_product_prices ON jos_virtuemart_products.virtuemart_product_id = jos_virtuemart_product_prices.virtuemart_product_id LEFT OUTER JOIN jos_virtuemart_product_manufacturers ON jos_virtuemart_products.virtuemart_product_id = jos_virtuemart_product_manufacturers.virtuemart_product_id LEFT OUTER JOIN jos_virtuemart_manufacturers ON jos_virtuemart_product_manufacturers.virtuemart_manufacturer_id = jos_virtuemart_manufacturers.virtuemart_manufacturer_id LEFT OUTER JOIN jos_virtuemart_product_categories ON jos_virtuemart_products.virtuemart_product_id = jos_virtuemart_product_categories.virtuemart_product_id LEFT OUTER JOIN jos_virtuemart_categories ON jos_virtuemart_product_categories.virtuemart_category_id = jos_virtuemart_categories.virtuemart_category_id LEFT OUTER JOIN jos_virtuemart_category_categories ON jos_virtuemart_categories.virtuemart_category_id = jos_virtuemart_category_categories.category_child_id LEFT OUTER JOIN jos_virtuemart_vendors ON jos_virtuemart_products.virtuemart_vendor_id = jos_virtuemart_vendors.virtuemart_vendor_id WHERE jos_virtuemart_products.`published`=1 GROUP BY jos_virtuemart_products.`virtuemart_product_id` ORDER BY ordering ASC
Call stack
# Function Location
1 JAdministrator->dispatch() ...\administrator\index.php:67
2 JComponentHelper->renderComponent() ...\administrator\includes\application.php:136
3 require_once() ...\libraries\joomla\application\component\helper.php:162
4 JController->execute() ...\administrator\components\com_virtuemart\admin.virtuemart.php:53
5 VirtuemartControllerProduct->Product() ...\libraries\joomla\application\component\controller.php:236
6 VirtuemartViewProduct->display() ...\administrator\components\com_virtuemart\controllers\product.php:69
7 VirtueMartModelProduct->getProductList() ...\administrator\components\com_virtuemart\views\product\view.html.php:246
8 VmModel->getPagination() ...\administrator\components\com_virtuemart\models\product.php:591
9 VirtueMartModelProduct->getTotal() ...\administrator\components\com_virtuemart\helpers\vmmodel.php:106
10 JDatabaseMySQLi->loadObjectList() ...\administrator\components\com_virtuemart\models\product.php:65
11 JDatabaseMySQLi->query() ...\libraries\joomla\database\database\mysqli.php:474
12 JError->raiseError() ...\libraries\joomla\database\database\mysqli.php:247
13 JError->raise() ...\libraries\joomla\error\error.php:171
14 JException->__construct() ...\libraries\joomla\error\error.php:136
ahh nice thanks, that helps.
Additional Note: If I remember correctly, the products are still shown if you select a filter, but the complete list doesn't show again.