News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Slow query - wrong category id

Started by pivovary, November 29, 2018, 14:29:27 PM

Previous topic - Next topic

pivovary

Hello,
i have with slow query

SELECT c.* FROM joom_virtuemart_customs  as c INNER JOIN joom_virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id)\\nINNER JOIN joom_virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id=\\\"-2\\\" and searchable=\\\"1\\\" and (field_type=\\\"S\\\" or field_type=\\\"P\\\") and c.published = 1 GROUP BY c.virtuemart_custom_id

In query is virtuemart_category_id='-2' but this category not exist. Please can you check where is problem?

Studio 42

Vm and joomla Release ?
template ?
Some special plugins or modules ?
Because i dont know this query, i dont think that VM core use INNER JOIN but only LEFT JOIN most time

pivovary

Sorry,
VM 3.4.2
Joomla 3.8.13
I don't use special plugin for virtuemart
Template is custom but this query is not there

pivovary

This is query from components/com_virtuemart/views/category/category.view.php server is overload every day

jenkinhill

There is no file called category.view.php in default VirtueMart.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

pivovary


Milbo

#6
It is the search for customfields, please try the new uploaded version

Try this one http://dev.virtuemart.net/attachments/download/1151/com_virtuemart.3.4.3.9992_package_or_extract.zip (reupped)
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

pivovary

Hi, on test server all ok, but i do not want upload to production server. If i update it's possible downgrade if will be problem?

jenkinhill

Quote from: pivovary on December 06, 2018, 06:29:50 AM
If i update it's possible downgrade if will be problem?

It can be a problem, so use Akeeba backup to make an archive of the current site, then test the update. If no good then replace the site with the backup.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum