News:

Looking for documentation? Take a look on our wiki

Main Menu

sql repeat command

Started by tanasus, November 30, 2018, 00:01:09 AM

Previous topic - Next topic

tanasus

Hello all,
im using Joomla! 3.9.1 and VM 3.4.2.
I see at my sql the command SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `nfojm_virtuemart_products` as p L run continuously and this cause me high sql cpu problem...
I think it is a bug...
Any help ?

SimonHodgkiss

Hello,

I have this issue as well now!

Anyone know how to fix?

Joomla 3.9.10 and virtuemart 3.4.2

Thanks
Thanks Simon Hodgkiss

Happy to help where I can.

StefanSTS

Hi,

high sql cpu usage in VM 3.4.2 might come from
1. enabling the setting "Virtuemart 404 handling", that should be switched off in VM config -> tab Shop.

2. Another possible issue in Vm Config -> Templates -> tab Shopfront settings. Set all "Omit" to "No".

You might want to test VM 3.5.0.10098 on a test environment, I guess it should be solved there.

Regards
Stefan
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.