News:

Support the VirtueMart project and become a member

Main Menu

debug VM Search SQL query?

Started by EvanGR, December 22, 2021, 15:52:30 PM

Previous topic - Next topic

EvanGR

Hello,

I want to print (vmdebug) the SQL query from the VM Search module.
It's probably in the model product.php somewhere, but I am having a hard time finding it. (the variable that holds the final complete query)
Can anyone help?

Thanks!

GJC Web Design

products model -> function sortSearchListQuery()

GJC Web Design
VirtueMart and Joomla Developers - php developers [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation

EvanGR

Thanks!

And there was a commented out vmdebug statement in there:
vmdebug ( ' joined ? ',$select, $joinedTables, $whereString, $groupBy, $orderBy, $this->filter_order_Dir );   

Which helped a lot.

daniellemiller

And there is no simpler solution for solving this problem! I tried too with your steps and so far I have not succeeded ...

Studio 42


daniellemiller What you tried and for what problem ???
Free XML sitemap generator [url="http://shop.st42.fr/en/catalog/products/virtuemart-2-sitemap.htm"]http://shop.st42.fr/en/catalog/products/virtuemart-2-sitemap.htm[/url]  , Free Unused Image cleaner [url="http://shop.st42.fr/en/products/virtuemart-media-folder-clear.htm"]http://shop.st42.fr/en/products/virtuemart-media-folder-clear.htm[/url]
Language Switch in product & category [url="http://shop.st42.fr/en/categories-tools/multi-language-for-virtuemart.htm"]http://shop.st42.fr/en/categories-tools/multi-language-for-virtuemart.htm[/url]
More extentions [url="http://shop.st42.fr/en/"]http://shop.st42.fr/en/[/url]

Milbo

#5
There is a simpler solution. The new version has a new debug option, which just enables the commented line. and that helps a lot ;-)

https://dev.virtuemart.net/attachments/1297/com_virtuemart.3.8.9.10578_package_or_extract.zip
Should I fix your bug, please support the VirtueMart project and become a [url=http://extensions.virtuemart.net/support/virtuemart-supporter-membership-detail]member[/url]
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/