VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: tanasus on November 30, 2018, 00:01:09 am

Title: sql repeat command
Post by: tanasus on November 30, 2018, 00:01:09 am
Hello all,
im using Joomla! 3.9.1 and VM 3.4.2.
I see at my sql the command
Code: [Select]
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 ?
Title: Re: sql repeat command
Post by: SimonHodgkiss on August 12, 2019, 19:31:33 pm
Hello,

I have this issue as well now!

Anyone know how to fix?

Joomla 3.9.10 and virtuemart 3.4.2

Thanks
Title: Re: sql repeat command
Post by: StefanSTS on August 13, 2019, 11:04:15 am
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