Virtuemart 3.4.2 - mysql overload

[pivovary]

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;

[pivovary]

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

Code Select Expand


public function exeSortSearchListQuery($object, $select, $joinedTables, $whereString = '', $groupBy = '', $orderBy = '', $filter_order_Dir = '', $nbrReturnProducts = false ){


i added

Code Select Expand


       if (preg_match("/`product_parent_id` = \"0\"/", $whereString))
        {
            return '';
        }


[jenkinhill]

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.

[pivovary]

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.

[pivovary]

Another bug, VM Handle 404 causes cycling script and memory consuption

VM version 3.4.2
Joomla: 3.8.13

[Studio 42]

I do not use Soft VM 404 because i had many problems too.

[pivovary]

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

[jenkinhill]

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

[pivovary]

Maybe test on monday, but i dont understant, why you not release oficial version when you know about this big issues.

[vep87895]

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?

[Milbo]

You can already use it live.