VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: roman5527 on November 05, 2018, 20:04:02 PM

Title: Slow database queries
Post by: roman5527 on November 05, 2018, 20:04:02 PM
Hi, i see two weeks back on my hosting console , slow queries on database :

i see log which contains queries how : /you can see in file


problem is : I see many times error 502 or 503 on my site.

Does anyone have any idea where the problem might be?

thanks
Title: Re: Slow database queries
Post by: 2dmaster on November 05, 2018, 21:17:57 PM
In new update sql high load error fixed, try dev.virtuemart.net
Title: Re: Slow database queries
Post by: 2dmaster on November 05, 2018, 21:36:15 PM
Virtuemart 3.4.3 http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: Slow database queries
Post by: Milbo on November 06, 2018, 00:10:12 AM
Hello roman,

replace in the product model around line 698

$where[] = ' p.`virtuemart_product_id`!='.implode(' AND p.`virtuemart_product_id`!=',self::$_alreadyLoadedIds).' ';


against

$where[] = '   ( p.`virtuemart_product_id` NOT IN ('.implode(',',self::$_alreadyLoadedIds).') ) ';