Author Topic: ***SOLVED *** Bug in Products Pagination in Backend.  (Read 4425 times)

erick_alcala

  • Jr. Member
  • **
  • Posts: 155
  • Everything is Possible!
    • Ofix-Comp
***SOLVED *** Bug in Products Pagination in Backend.
« on: June 16, 2011, 21:45:12 pm »
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 .
wanting to learn to create good templates

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9743
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Bug in Products Pagination in Backend.
« Reply #1 on: June 17, 2011, 11:20:19 am »
Thanks, we will take a look on it.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3376
  • using Matomo instead of Google Analytics
Re: Bug in Products Pagination in Backend.
« Reply #2 on: June 17, 2011, 19:04:25 pm »
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
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9743
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Bug in Products Pagination in Backend.
« Reply #3 on: June 18, 2011, 20:38:36 pm »
ahh nice thanks, that helps.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3376
  • using Matomo instead of Google Analytics
Re: Bug in Products Pagination in Backend.
« Reply #4 on: June 18, 2011, 21:03:13 pm »
Additional Note: If I remember correctly, the products are still shown if you select a filter, but the complete list doesn't show again.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations