News:

Support the VirtueMart project and become a member

Main Menu

"Rebel products" when sorting by price

Started by dslove, June 06, 2017, 11:09:28 AM

Previous topic - Next topic

Milbo

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

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

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/