***SOLVED *** Bug in Products Pagination in Backend.

[beltoforion]

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 .

[Milbo]

Thanks, we will take a look on it.

[jjk]

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

[Milbo]

ahh nice thanks, that helps.

[jjk]

Additional Note: If I remember correctly, the products are still shown if you select a filter, but the complete list doesn't show again.