Hi,
i have problem after update to virtuemart 3.4.2. With 1000 products and 7 language
I dont't know where is this query and still run and run and server hang up.
Slow sql:
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`, l.product_name
FROM `joom_virtuemart_products` as p
INNER JOIN `joom_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `joom_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `joom_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `joom_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND .......
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` ASC, `product_name` ASC LIMIT 0, 100;
I think same problem as
http://forum.virtuemart.net/index.php?topic=141440.0
Please when it be available new version 3.4.3
I stop this problem edit in vmmodel.php after row
public function exeSortSearchListQuery($object, $select, $joinedTables, $whereString = '', $groupBy = '', $orderBy = '', $filter_order_Dir = '', $nbrReturnProducts = false ){
i added
if (preg_match("/`product_parent_id` = \"0\"/", $whereString))
{
return '';
}
VM3.4.3.9989 was release 2 days ago. http://dev.virtuemart.net/projects/virtuemart/files
Test on a copy of the live site first.
You know, how to repeat this problem? I don't know where url start this problem.I have only log from mysql server. Before update i test version 3.4.2 on dev server but without problem after update on production server problem start.
Another bug, VM Handle 404 causes cycling script and memory consuption
VM version 3.4.2
Joomla: 3.8.13
I do not use Soft VM 404 because i had many problems too.
And info about problem from hosting
[07-Dec-2018 14:04:43 Europe/Prague] PHP Warning: array_merge(): Argument #1 is not an array in /domains1/gh43254800/public/www_root/components/com_virtuemart/views/category/view.html.php on line 257
[07-Dec-2018 14:04:43 Europe/Prague] PHP Notice: Undefined index: debug in /domains1/gh43254800/public/www_root/administrator/components/com_virtuemart/helpers/vmmodel.php on line 816
Quote from: pivovary on December 07, 2018, 14:20:43 PM
Another bug, VM Handle 404 causes cycling script and memory consuption
VM version 3.4.2
Joomla: 3.8.13
Already fixed in VM3.4.3
Maybe test on monday, but i dont understant, why you not release oficial version when you know about this big issues.
This is the reason (mysql overload) that I'm still on VM3.4.0. I assume that VM3.4.3 will soon be released as the new stable official version?
You can already use it live.