Author Topic: sql repeat command  (Read 400 times)

tanasus

  • Beginner
  • *
  • Posts: 1
  • A beginner
sql repeat command
« 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 ?

SimonHodgkiss

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 93
  • Web Developer
  • Skype Name: simon.hodgkiss
Re: sql repeat command
« Reply #1 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
Thanks Simon Hodgkiss

Happy to help where I can.

StefanSTS

  • Global Moderator
  • Jr. Member
  • *
  • Posts: 420
  • VirtueMart Version: VM 4.2 on Joomla 4.5
Re: sql repeat command
« Reply #2 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
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

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