Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.7
    • Fix Version/s: N/A
    • Component/s: Optimizer
    • Labels:
    • Environment:

      Description

      I link a crash report, it append everytime I exec this kind of request.
      Another query :
      Query (0x5645a0188020): SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight`

      FROM cj_product p INNER JOIN cj_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)

      INNER JOIN cj_category_product cp ON (cp.id_product = p.id_product)
      INNER JOIN cj_category c ON (c.id_category = cp.id_category AND
      c.nleft >= 4
      AND c.nright <= 5
      AND c.active = 1) LEFT JOIN `cj_stock_available` sa
      ON (sa.id_product = p.id_product AND sa.id_shop = 1)
      WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 605) AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 562 OR fp.`id_feature_value` = 558) AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 338)
      GROUP BY p.id_product

      I can reproduce the bug by running it in PhpMyAdmin :
      If I remove the LEFT here : "LEFT JOIN `cj_stock_available`". The query don't crash the server.
      I repaired the table with
      mysqlcheck -u USER -p --check -A --auto-repair
      But same problem.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alice Alice Sherepa
                Reporter:
                pierre21 Pierre
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: