Author Topic: "Rebel products" when sorting by price  (Read 6276 times)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10273
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: "Rebel products" when sorting by price
« Reply #15 on: June 13, 2017, 00:28:28 am »
Which db do you use? which mysql or mariadb version? You can also uncomment one line in the product model to see the used sql, when you use the vmdebug and use it directly on the db. Maybe you see then the problem.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

dslove

  • Jr. Member
  • **
  • Posts: 93
Re: "Rebel products" when sorting by price
« Reply #16 on: June 13, 2017, 08:03:14 am »
Hi Milbo, please let me know which line to uncomment & where.

Setup is as following:

DB type => mysqli
Database Version => 5.6.35
Database Collation => utf8_general_ci
Database Connection Collation => utf8mb4_general_ci
PHP Version => 7.0.19
Web Server => Apache
Joomla Version => 3.7.2
Virtuemart Version => 3.2.2

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10273
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: "Rebel products" when sorting by price
« Reply #17 on: June 13, 2017, 09:19:37 am »
Please install this version http://dev.virtuemart.net/attachments/download/1081/com_virtuemart.3.2.3.9577.zip

and then open the product model in /administrator/components/com_virtuemart/models and uncomment the line 259, $this->setDebugSql(1);

Then enable the vmdebug and you should see the sql. Then post the sql here and we can discuss it.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/