Slow database queries

[roman5527]

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

[2dmaster]

In new update sql high load error fixed, try dev.virtuemart.net

[2dmaster]

Virtuemart 3.4.3 http://dev.virtuemart.net/projects/virtuemart/files

[Milbo]

Hello roman,

replace in the product model around line 698

Code Select Expand


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


against

Code Select Expand


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