#StackBounty: #reindex #magento2.3.1 #cli Magento 2.3.1 Product EAV index throws error with GTID consistency

Bounty: 50

when i run reindex command After Below type error showing

SQLSTATE[HY000]: General error: 1787 Statement violates GTID
consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only
be executed outside transactional context. These statements are also
not allowed in a function or trigger because functions and triggers
are also considered to be multi-statement transactions., query was:
CREATE TEMPORARY TABLE IF NOT EXISTS catalog_product_index_eav_temp
LIKE catalog_product_index_eav_tmp


Get this bounty!!!

#StackBounty: #reindex #magento2.3.1 Magento 2.3.1 Product EAV index throws error with GTID consistency

Bounty: 50

when i run reindex command After below type error showing

SQLSTATE[HY000]: General error: 1787 Statement violates GTID
consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only
be executed outside transactional context. These statements are also
not allowed in a function or trigger because functions and triggers
are also considered to be multi-statement transactions., query was:
CREATE TEMPORARY TABLE IF NOT EXISTS catalog_product_index_eav_temp
LIKE catalog_product_index_eav_tmp


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!

#StackBounty: #cache #php-7 #topmenu #magento2.3.1 Magento 2.3 – Topmenu tabs with wrong (cached) 'active' class

Bounty: 50

I have a small menu problem. The active tabs do not match the active class. If I disable the static_block cache it works again, so it actually looks like the menu is cached and continues to display the content that is cached regardless of the tab selected.
I tried to put cacheable=false on the block of the topmenu concerned in the default.xml layout but this didn’t change anything.
if someone has already had this problem or has a lead…

Edit :
I fixed it quickly, by removing the topmenu from the cache, (if I understood what I did correctly) but as you can see it’s not terrible, but it works very well now

<?php

namespace MyNamespaceIndoBlockHtml;

use MagentoFrameworkDataTreeNodeFactory;
use MagentoFrameworkDataTreeFactory;
use MagentoFrameworkViewElementTemplate;
use MagentoFrameworkViewLayoutFactory;
use TemplateMonsterMegamenuHelperData;

class Topmenu extends MagentoThemeBlockHtmlTopmenu
{


    public $_helper;

    public $_layoutFactory;

    public function __construct(
        TemplateContext $context,
        NodeFactory $nodeFactory,
        TreeFactory $treeFactory,
        Data $helper,
        LayoutFactory $layoutFactory,
        array $data = []
    )
    {
        parent::__construct($context, $nodeFactory, $treeFactory, $data);
        $this->_helper        = $helper;
        $this->_layoutFactory = $layoutFactory;
    }

    /**
     * Get block cache life time
     *
     * @return int
     * @since 100.1.0
     */
    protected function getCacheLifetime()
    {
        return 0;
    }
}


Get this bounty!!!