News:

Support the VirtueMart project and become a member

Main Menu

Slow database queries

Started by roman5527, November 05, 2018, 20:04:02 PM

Previous topic - Next topic

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


Milbo

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).') ) ';
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/