Magento2 Error: “Something went wrong with processing the default view and we have restored the filter to...

How to not let the Identify spell spoil everything?

Hilchos Shabbos English Sefer

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Globe trotting Grandpa. Where is he going next?

What is the wife of a henpecked husband called?

What is a DAG (Graph Theory)?

What is a good reason for every spaceship to carry a weapon on board?

Why is Agricola named as such?

Is the child responsible for the Parent PLUS Loan when the parent has passed away?

Explanation of a regular pattern only occuring for prime numbers

Limits of a density function

How would an AI self awareness kill switch work?

any clues on how to solve these types of problems within 2-3 minutes for competitive exams

Boss asked me to sign a resignation paper without a date on it along with my new contract

Changing the laptop's CPU. Should I reinstall Linux?

Do authors have to be politically correct in article-writing?

Short story where statues have their heads replaced by those of carved insect heads

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Does diversity provide anything that meritocracy does not?

Airplane generations - how does it work?

How to assess the long-term stability of a college as part of a job search

TikZ graph edges not drawn nicely

Has any human ever had the choice to leave Earth permanently?



Magento2 Error: “Something went wrong with processing the default view and we have restored the filter to its original state” showing on the loop


Something went wrong with processing the default view and we have restored the filter to its original stateSomething went wrong with the subscription alert in Magento2Warning “Something went wrong” appears every time I try to enable a themeMagento 2 Module upgrade errorTry to install magento migration tool failsHow to solve admin grid error?Why do i have to always run the commands to clean cache in Magento 2.1.8?catalog products page showing error magento 2Magneto2 CatalogSearchMagento frontend and backend CSS is not workingMagento 2 | customer grid error













3















Whenever I open the Catalog Product it gives the following error on loop and continue loading the loader




Attention Something went wrong.



Something went wrong with processing the default view and we have
restored the filter to its original state.




I tried clear the cache(php bin/magento cache:clean)also upgraded magento(php bin/magento setup:upgrade)even given the files and folder permission but still facing the same problem.



loading










share|improve this question





























    3















    Whenever I open the Catalog Product it gives the following error on loop and continue loading the loader




    Attention Something went wrong.



    Something went wrong with processing the default view and we have
    restored the filter to its original state.




    I tried clear the cache(php bin/magento cache:clean)also upgraded magento(php bin/magento setup:upgrade)even given the files and folder permission but still facing the same problem.



    loading










    share|improve this question



























      3












      3








      3


      1






      Whenever I open the Catalog Product it gives the following error on loop and continue loading the loader




      Attention Something went wrong.



      Something went wrong with processing the default view and we have
      restored the filter to its original state.




      I tried clear the cache(php bin/magento cache:clean)also upgraded magento(php bin/magento setup:upgrade)even given the files and folder permission but still facing the same problem.



      loading










      share|improve this question
















      Whenever I open the Catalog Product it gives the following error on loop and continue loading the loader




      Attention Something went wrong.



      Something went wrong with processing the default view and we have
      restored the filter to its original state.




      I tried clear the cache(php bin/magento cache:clean)also upgraded magento(php bin/magento setup:upgrade)even given the files and folder permission but still facing the same problem.



      loading







      magento2 magento-2.1






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jul 2 '18 at 10:15







      Rahul Singh

















      asked Jul 2 '18 at 10:08









      Rahul SinghRahul Singh

      8411926




      8411926






















          4 Answers
          4






          active

          oldest

          votes


















          5














          Old post but for future viewers - a temporary fix is to clear (empty, not delete) the ui_bookmark table of your magento 2 database, this will reset the grid back to it's default and stop the infinite load.



          (you can find out your admin user ID in the admin_users table as well and only remove the ui_bookmark rows relevant to your account if this is a multi-admin site)



          The actual problem can be harder to diagnose, but a good place to start (and in my case) was to increase the php timeout limit.






          share|improve this answer
























          • yes working after empty ui_bookmark! Thanks

            – Jugal Kishor
            Aug 1 '18 at 14:09











          • Did not work for me using 2.2.5

            – dbcn
            Nov 28 '18 at 17:36



















          0














          File open: vendormagentoframeworkViewElementUiComponentDataProviderFulltextFilter.php



          Function change:



          public function apply(Collection $collection, Filter $filter)
          {
          if (!$collection instanceof AbstractDb) {
          throw new InvalidArgumentException('Database collection required.');
          }

          /** @var SearchResult $collection */
          $mainTable = $collection->getMainTable();
          $columns = $this->getFulltextIndexColumns($collection, $mainTable);
          if (!$columns) {
          return;
          }

          $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
          $collection->getSelect()
          ->where(
          'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
          // $filter->getValue()
          $this->escapeAgainstValue($filter->getValue())
          );
          }







          share|improve this answer































            0














            This commit can solve your problem.



            https://github.com/magento/magento2/pull/14905



            Magento/Framework/View/Element/UiComponent/DataProvider/FulltextFilter.php



            <?php
            /**
            * Copyright © Magento, Inc. All rights reserved.
            * See COPYING.txt for license details.
            */
            namespace MagentoFrameworkViewElementUiComponentDataProvider;
            use MagentoFrameworkDataCollection;
            use MagentoFrameworkDataCollectionAbstractDb;
            use MagentoFrameworkApiFilter;
            /**
            * Class Fulltext
            */
            class FulltextFilter implements FilterApplierInterface
            {
            /**
            * Returns list of columns from fulltext index (doesn't support more then one FTI per table)
            *
            * @param AbstractDb $collection
            * @param string $indexTable
            * @return array
            */
            protected function getFulltextIndexColumns(AbstractDb $collection, $indexTable)
            {
            $indexes = $collection->getConnection()->getIndexList($indexTable);
            foreach ($indexes as $index) {
            if (strtoupper($index['INDEX_TYPE']) == 'FULLTEXT') {
            return $index['COLUMNS_LIST'];
            }
            }
            return [];
            }
            /**
            * Add table alias to columns
            *
            * @param array $columns
            * @param AbstractDb $collection
            * @param string $indexTable
            * @return array
            */
            protected function addTableAliasToColumns(array $columns, AbstractDb $collection, $indexTable)
            {
            $alias = '';
            foreach ($collection->getSelect()->getPart('from') as $tableAlias => $data) {
            if ($indexTable == $data['tableName']) {
            $alias = $tableAlias;
            break;
            }
            }
            if ($alias) {
            $columns = array_map(
            function ($column) use ($alias) {
            return '`' . $alias . '`.' . $column;
            },
            $columns
            );
            }
            return $columns;
            }
            /**
            * Escape against value
            * @param string $value
            * @return string
            */
            private function escapeAgainstValue(string $value): string
            {
            return preg_replace('/([+-><()~*"@]+)/', ' ', $value);
            }
            /**
            * Apply fulltext filters
            *
            * @param Collection $collection
            * @param Filter $filter
            * @return void
            */
            public function apply(Collection $collection, Filter $filter)
            {
            if (!$collection instanceof AbstractDb) {
            throw new InvalidArgumentException('Database collection required.');
            }
            /** @var SearchResult $collection */
            $mainTable = $collection->getMainTable();
            $columns = $this->getFulltextIndexColumns($collection, $mainTable);
            if (!$columns) {
            return;
            }
            $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
            $collection->getSelect()
            ->where(
            'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
            $this->escapeAgainstValue($filter->getValue())
            );
            }
            }





            share|improve this answer































              0














              It was due to that some null SKU related error I resolved using the following query.



              UPDATE catalog_product_entity SET sku='' WHERE sku IS NULL;





              share








              New contributor




              Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
              Check out our Code of Conduct.




















                Your Answer








                StackExchange.ready(function() {
                var channelOptions = {
                tags: "".split(" "),
                id: "479"
                };
                initTagRenderer("".split(" "), "".split(" "), channelOptions);

                StackExchange.using("externalEditor", function() {
                // Have to fire editor after snippets, if snippets enabled
                if (StackExchange.settings.snippets.snippetsEnabled) {
                StackExchange.using("snippets", function() {
                createEditor();
                });
                }
                else {
                createEditor();
                }
                });

                function createEditor() {
                StackExchange.prepareEditor({
                heartbeatType: 'answer',
                autoActivateHeartbeat: false,
                convertImagesToLinks: false,
                noModals: true,
                showLowRepImageUploadWarning: true,
                reputationToPostImages: null,
                bindNavPrevention: true,
                postfix: "",
                imageUploader: {
                brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
                contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
                allowUrls: true
                },
                onDemand: true,
                discardSelector: ".discard-answer"
                ,immediatelyShowMarkdownHelp:true
                });


                }
                });














                draft saved

                draft discarded


















                StackExchange.ready(
                function () {
                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f232021%2fmagento2-error-something-went-wrong-with-processing-the-default-view-and-we-ha%23new-answer', 'question_page');
                }
                );

                Post as a guest















                Required, but never shown

























                4 Answers
                4






                active

                oldest

                votes








                4 Answers
                4






                active

                oldest

                votes









                active

                oldest

                votes






                active

                oldest

                votes









                5














                Old post but for future viewers - a temporary fix is to clear (empty, not delete) the ui_bookmark table of your magento 2 database, this will reset the grid back to it's default and stop the infinite load.



                (you can find out your admin user ID in the admin_users table as well and only remove the ui_bookmark rows relevant to your account if this is a multi-admin site)



                The actual problem can be harder to diagnose, but a good place to start (and in my case) was to increase the php timeout limit.






                share|improve this answer
























                • yes working after empty ui_bookmark! Thanks

                  – Jugal Kishor
                  Aug 1 '18 at 14:09











                • Did not work for me using 2.2.5

                  – dbcn
                  Nov 28 '18 at 17:36
















                5














                Old post but for future viewers - a temporary fix is to clear (empty, not delete) the ui_bookmark table of your magento 2 database, this will reset the grid back to it's default and stop the infinite load.



                (you can find out your admin user ID in the admin_users table as well and only remove the ui_bookmark rows relevant to your account if this is a multi-admin site)



                The actual problem can be harder to diagnose, but a good place to start (and in my case) was to increase the php timeout limit.






                share|improve this answer
























                • yes working after empty ui_bookmark! Thanks

                  – Jugal Kishor
                  Aug 1 '18 at 14:09











                • Did not work for me using 2.2.5

                  – dbcn
                  Nov 28 '18 at 17:36














                5












                5








                5







                Old post but for future viewers - a temporary fix is to clear (empty, not delete) the ui_bookmark table of your magento 2 database, this will reset the grid back to it's default and stop the infinite load.



                (you can find out your admin user ID in the admin_users table as well and only remove the ui_bookmark rows relevant to your account if this is a multi-admin site)



                The actual problem can be harder to diagnose, but a good place to start (and in my case) was to increase the php timeout limit.






                share|improve this answer













                Old post but for future viewers - a temporary fix is to clear (empty, not delete) the ui_bookmark table of your magento 2 database, this will reset the grid back to it's default and stop the infinite load.



                (you can find out your admin user ID in the admin_users table as well and only remove the ui_bookmark rows relevant to your account if this is a multi-admin site)



                The actual problem can be harder to diagnose, but a good place to start (and in my case) was to increase the php timeout limit.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jul 16 '18 at 15:30









                RhyanRhyan

                511




                511













                • yes working after empty ui_bookmark! Thanks

                  – Jugal Kishor
                  Aug 1 '18 at 14:09











                • Did not work for me using 2.2.5

                  – dbcn
                  Nov 28 '18 at 17:36



















                • yes working after empty ui_bookmark! Thanks

                  – Jugal Kishor
                  Aug 1 '18 at 14:09











                • Did not work for me using 2.2.5

                  – dbcn
                  Nov 28 '18 at 17:36

















                yes working after empty ui_bookmark! Thanks

                – Jugal Kishor
                Aug 1 '18 at 14:09





                yes working after empty ui_bookmark! Thanks

                – Jugal Kishor
                Aug 1 '18 at 14:09













                Did not work for me using 2.2.5

                – dbcn
                Nov 28 '18 at 17:36





                Did not work for me using 2.2.5

                – dbcn
                Nov 28 '18 at 17:36













                0














                File open: vendormagentoframeworkViewElementUiComponentDataProviderFulltextFilter.php



                Function change:



                public function apply(Collection $collection, Filter $filter)
                {
                if (!$collection instanceof AbstractDb) {
                throw new InvalidArgumentException('Database collection required.');
                }

                /** @var SearchResult $collection */
                $mainTable = $collection->getMainTable();
                $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                if (!$columns) {
                return;
                }

                $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                $collection->getSelect()
                ->where(
                'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                // $filter->getValue()
                $this->escapeAgainstValue($filter->getValue())
                );
                }







                share|improve this answer




























                  0














                  File open: vendormagentoframeworkViewElementUiComponentDataProviderFulltextFilter.php



                  Function change:



                  public function apply(Collection $collection, Filter $filter)
                  {
                  if (!$collection instanceof AbstractDb) {
                  throw new InvalidArgumentException('Database collection required.');
                  }

                  /** @var SearchResult $collection */
                  $mainTable = $collection->getMainTable();
                  $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                  if (!$columns) {
                  return;
                  }

                  $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                  $collection->getSelect()
                  ->where(
                  'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                  // $filter->getValue()
                  $this->escapeAgainstValue($filter->getValue())
                  );
                  }







                  share|improve this answer


























                    0












                    0








                    0







                    File open: vendormagentoframeworkViewElementUiComponentDataProviderFulltextFilter.php



                    Function change:



                    public function apply(Collection $collection, Filter $filter)
                    {
                    if (!$collection instanceof AbstractDb) {
                    throw new InvalidArgumentException('Database collection required.');
                    }

                    /** @var SearchResult $collection */
                    $mainTable = $collection->getMainTable();
                    $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                    if (!$columns) {
                    return;
                    }

                    $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                    $collection->getSelect()
                    ->where(
                    'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                    // $filter->getValue()
                    $this->escapeAgainstValue($filter->getValue())
                    );
                    }







                    share|improve this answer













                    File open: vendormagentoframeworkViewElementUiComponentDataProviderFulltextFilter.php



                    Function change:



                    public function apply(Collection $collection, Filter $filter)
                    {
                    if (!$collection instanceof AbstractDb) {
                    throw new InvalidArgumentException('Database collection required.');
                    }

                    /** @var SearchResult $collection */
                    $mainTable = $collection->getMainTable();
                    $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                    if (!$columns) {
                    return;
                    }

                    $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                    $collection->getSelect()
                    ->where(
                    'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                    // $filter->getValue()
                    $this->escapeAgainstValue($filter->getValue())
                    );
                    }








                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 17 '18 at 14:12









                    stncstnc

                    1




                    1























                        0














                        This commit can solve your problem.



                        https://github.com/magento/magento2/pull/14905



                        Magento/Framework/View/Element/UiComponent/DataProvider/FulltextFilter.php



                        <?php
                        /**
                        * Copyright © Magento, Inc. All rights reserved.
                        * See COPYING.txt for license details.
                        */
                        namespace MagentoFrameworkViewElementUiComponentDataProvider;
                        use MagentoFrameworkDataCollection;
                        use MagentoFrameworkDataCollectionAbstractDb;
                        use MagentoFrameworkApiFilter;
                        /**
                        * Class Fulltext
                        */
                        class FulltextFilter implements FilterApplierInterface
                        {
                        /**
                        * Returns list of columns from fulltext index (doesn't support more then one FTI per table)
                        *
                        * @param AbstractDb $collection
                        * @param string $indexTable
                        * @return array
                        */
                        protected function getFulltextIndexColumns(AbstractDb $collection, $indexTable)
                        {
                        $indexes = $collection->getConnection()->getIndexList($indexTable);
                        foreach ($indexes as $index) {
                        if (strtoupper($index['INDEX_TYPE']) == 'FULLTEXT') {
                        return $index['COLUMNS_LIST'];
                        }
                        }
                        return [];
                        }
                        /**
                        * Add table alias to columns
                        *
                        * @param array $columns
                        * @param AbstractDb $collection
                        * @param string $indexTable
                        * @return array
                        */
                        protected function addTableAliasToColumns(array $columns, AbstractDb $collection, $indexTable)
                        {
                        $alias = '';
                        foreach ($collection->getSelect()->getPart('from') as $tableAlias => $data) {
                        if ($indexTable == $data['tableName']) {
                        $alias = $tableAlias;
                        break;
                        }
                        }
                        if ($alias) {
                        $columns = array_map(
                        function ($column) use ($alias) {
                        return '`' . $alias . '`.' . $column;
                        },
                        $columns
                        );
                        }
                        return $columns;
                        }
                        /**
                        * Escape against value
                        * @param string $value
                        * @return string
                        */
                        private function escapeAgainstValue(string $value): string
                        {
                        return preg_replace('/([+-><()~*"@]+)/', ' ', $value);
                        }
                        /**
                        * Apply fulltext filters
                        *
                        * @param Collection $collection
                        * @param Filter $filter
                        * @return void
                        */
                        public function apply(Collection $collection, Filter $filter)
                        {
                        if (!$collection instanceof AbstractDb) {
                        throw new InvalidArgumentException('Database collection required.');
                        }
                        /** @var SearchResult $collection */
                        $mainTable = $collection->getMainTable();
                        $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                        if (!$columns) {
                        return;
                        }
                        $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                        $collection->getSelect()
                        ->where(
                        'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                        $this->escapeAgainstValue($filter->getValue())
                        );
                        }
                        }





                        share|improve this answer




























                          0














                          This commit can solve your problem.



                          https://github.com/magento/magento2/pull/14905



                          Magento/Framework/View/Element/UiComponent/DataProvider/FulltextFilter.php



                          <?php
                          /**
                          * Copyright © Magento, Inc. All rights reserved.
                          * See COPYING.txt for license details.
                          */
                          namespace MagentoFrameworkViewElementUiComponentDataProvider;
                          use MagentoFrameworkDataCollection;
                          use MagentoFrameworkDataCollectionAbstractDb;
                          use MagentoFrameworkApiFilter;
                          /**
                          * Class Fulltext
                          */
                          class FulltextFilter implements FilterApplierInterface
                          {
                          /**
                          * Returns list of columns from fulltext index (doesn't support more then one FTI per table)
                          *
                          * @param AbstractDb $collection
                          * @param string $indexTable
                          * @return array
                          */
                          protected function getFulltextIndexColumns(AbstractDb $collection, $indexTable)
                          {
                          $indexes = $collection->getConnection()->getIndexList($indexTable);
                          foreach ($indexes as $index) {
                          if (strtoupper($index['INDEX_TYPE']) == 'FULLTEXT') {
                          return $index['COLUMNS_LIST'];
                          }
                          }
                          return [];
                          }
                          /**
                          * Add table alias to columns
                          *
                          * @param array $columns
                          * @param AbstractDb $collection
                          * @param string $indexTable
                          * @return array
                          */
                          protected function addTableAliasToColumns(array $columns, AbstractDb $collection, $indexTable)
                          {
                          $alias = '';
                          foreach ($collection->getSelect()->getPart('from') as $tableAlias => $data) {
                          if ($indexTable == $data['tableName']) {
                          $alias = $tableAlias;
                          break;
                          }
                          }
                          if ($alias) {
                          $columns = array_map(
                          function ($column) use ($alias) {
                          return '`' . $alias . '`.' . $column;
                          },
                          $columns
                          );
                          }
                          return $columns;
                          }
                          /**
                          * Escape against value
                          * @param string $value
                          * @return string
                          */
                          private function escapeAgainstValue(string $value): string
                          {
                          return preg_replace('/([+-><()~*"@]+)/', ' ', $value);
                          }
                          /**
                          * Apply fulltext filters
                          *
                          * @param Collection $collection
                          * @param Filter $filter
                          * @return void
                          */
                          public function apply(Collection $collection, Filter $filter)
                          {
                          if (!$collection instanceof AbstractDb) {
                          throw new InvalidArgumentException('Database collection required.');
                          }
                          /** @var SearchResult $collection */
                          $mainTable = $collection->getMainTable();
                          $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                          if (!$columns) {
                          return;
                          }
                          $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                          $collection->getSelect()
                          ->where(
                          'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                          $this->escapeAgainstValue($filter->getValue())
                          );
                          }
                          }





                          share|improve this answer


























                            0












                            0








                            0







                            This commit can solve your problem.



                            https://github.com/magento/magento2/pull/14905



                            Magento/Framework/View/Element/UiComponent/DataProvider/FulltextFilter.php



                            <?php
                            /**
                            * Copyright © Magento, Inc. All rights reserved.
                            * See COPYING.txt for license details.
                            */
                            namespace MagentoFrameworkViewElementUiComponentDataProvider;
                            use MagentoFrameworkDataCollection;
                            use MagentoFrameworkDataCollectionAbstractDb;
                            use MagentoFrameworkApiFilter;
                            /**
                            * Class Fulltext
                            */
                            class FulltextFilter implements FilterApplierInterface
                            {
                            /**
                            * Returns list of columns from fulltext index (doesn't support more then one FTI per table)
                            *
                            * @param AbstractDb $collection
                            * @param string $indexTable
                            * @return array
                            */
                            protected function getFulltextIndexColumns(AbstractDb $collection, $indexTable)
                            {
                            $indexes = $collection->getConnection()->getIndexList($indexTable);
                            foreach ($indexes as $index) {
                            if (strtoupper($index['INDEX_TYPE']) == 'FULLTEXT') {
                            return $index['COLUMNS_LIST'];
                            }
                            }
                            return [];
                            }
                            /**
                            * Add table alias to columns
                            *
                            * @param array $columns
                            * @param AbstractDb $collection
                            * @param string $indexTable
                            * @return array
                            */
                            protected function addTableAliasToColumns(array $columns, AbstractDb $collection, $indexTable)
                            {
                            $alias = '';
                            foreach ($collection->getSelect()->getPart('from') as $tableAlias => $data) {
                            if ($indexTable == $data['tableName']) {
                            $alias = $tableAlias;
                            break;
                            }
                            }
                            if ($alias) {
                            $columns = array_map(
                            function ($column) use ($alias) {
                            return '`' . $alias . '`.' . $column;
                            },
                            $columns
                            );
                            }
                            return $columns;
                            }
                            /**
                            * Escape against value
                            * @param string $value
                            * @return string
                            */
                            private function escapeAgainstValue(string $value): string
                            {
                            return preg_replace('/([+-><()~*"@]+)/', ' ', $value);
                            }
                            /**
                            * Apply fulltext filters
                            *
                            * @param Collection $collection
                            * @param Filter $filter
                            * @return void
                            */
                            public function apply(Collection $collection, Filter $filter)
                            {
                            if (!$collection instanceof AbstractDb) {
                            throw new InvalidArgumentException('Database collection required.');
                            }
                            /** @var SearchResult $collection */
                            $mainTable = $collection->getMainTable();
                            $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                            if (!$columns) {
                            return;
                            }
                            $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                            $collection->getSelect()
                            ->where(
                            'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                            $this->escapeAgainstValue($filter->getValue())
                            );
                            }
                            }





                            share|improve this answer













                            This commit can solve your problem.



                            https://github.com/magento/magento2/pull/14905



                            Magento/Framework/View/Element/UiComponent/DataProvider/FulltextFilter.php



                            <?php
                            /**
                            * Copyright © Magento, Inc. All rights reserved.
                            * See COPYING.txt for license details.
                            */
                            namespace MagentoFrameworkViewElementUiComponentDataProvider;
                            use MagentoFrameworkDataCollection;
                            use MagentoFrameworkDataCollectionAbstractDb;
                            use MagentoFrameworkApiFilter;
                            /**
                            * Class Fulltext
                            */
                            class FulltextFilter implements FilterApplierInterface
                            {
                            /**
                            * Returns list of columns from fulltext index (doesn't support more then one FTI per table)
                            *
                            * @param AbstractDb $collection
                            * @param string $indexTable
                            * @return array
                            */
                            protected function getFulltextIndexColumns(AbstractDb $collection, $indexTable)
                            {
                            $indexes = $collection->getConnection()->getIndexList($indexTable);
                            foreach ($indexes as $index) {
                            if (strtoupper($index['INDEX_TYPE']) == 'FULLTEXT') {
                            return $index['COLUMNS_LIST'];
                            }
                            }
                            return [];
                            }
                            /**
                            * Add table alias to columns
                            *
                            * @param array $columns
                            * @param AbstractDb $collection
                            * @param string $indexTable
                            * @return array
                            */
                            protected function addTableAliasToColumns(array $columns, AbstractDb $collection, $indexTable)
                            {
                            $alias = '';
                            foreach ($collection->getSelect()->getPart('from') as $tableAlias => $data) {
                            if ($indexTable == $data['tableName']) {
                            $alias = $tableAlias;
                            break;
                            }
                            }
                            if ($alias) {
                            $columns = array_map(
                            function ($column) use ($alias) {
                            return '`' . $alias . '`.' . $column;
                            },
                            $columns
                            );
                            }
                            return $columns;
                            }
                            /**
                            * Escape against value
                            * @param string $value
                            * @return string
                            */
                            private function escapeAgainstValue(string $value): string
                            {
                            return preg_replace('/([+-><()~*"@]+)/', ' ', $value);
                            }
                            /**
                            * Apply fulltext filters
                            *
                            * @param Collection $collection
                            * @param Filter $filter
                            * @return void
                            */
                            public function apply(Collection $collection, Filter $filter)
                            {
                            if (!$collection instanceof AbstractDb) {
                            throw new InvalidArgumentException('Database collection required.');
                            }
                            /** @var SearchResult $collection */
                            $mainTable = $collection->getMainTable();
                            $columns = $this->getFulltextIndexColumns($collection, $mainTable);
                            if (!$columns) {
                            return;
                            }
                            $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable);
                            $collection->getSelect()
                            ->where(
                            'MATCH(' . implode(',', $columns) . ') AGAINST(?)',
                            $this->escapeAgainstValue($filter->getValue())
                            );
                            }
                            }






                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Feb 19 at 14:07









                            Gabriel FernandesGabriel Fernandes

                            476




                            476























                                0














                                It was due to that some null SKU related error I resolved using the following query.



                                UPDATE catalog_product_entity SET sku='' WHERE sku IS NULL;





                                share








                                New contributor




                                Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                Check out our Code of Conduct.

























                                  0














                                  It was due to that some null SKU related error I resolved using the following query.



                                  UPDATE catalog_product_entity SET sku='' WHERE sku IS NULL;





                                  share








                                  New contributor




                                  Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                  Check out our Code of Conduct.























                                    0












                                    0








                                    0







                                    It was due to that some null SKU related error I resolved using the following query.



                                    UPDATE catalog_product_entity SET sku='' WHERE sku IS NULL;





                                    share








                                    New contributor




                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.










                                    It was due to that some null SKU related error I resolved using the following query.



                                    UPDATE catalog_product_entity SET sku='' WHERE sku IS NULL;






                                    share








                                    New contributor




                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.








                                    share


                                    share






                                    New contributor




                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.









                                    answered 4 mins ago









                                    Navneet BhardwajNavneet Bhardwaj

                                    12




                                    12




                                    New contributor




                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.





                                    New contributor





                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.






                                    Navneet Bhardwaj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                    Check out our Code of Conduct.






























                                        draft saved

                                        draft discarded




















































                                        Thanks for contributing an answer to Magento Stack Exchange!


                                        • Please be sure to answer the question. Provide details and share your research!

                                        But avoid



                                        • Asking for help, clarification, or responding to other answers.

                                        • Making statements based on opinion; back them up with references or personal experience.


                                        To learn more, see our tips on writing great answers.




                                        draft saved


                                        draft discarded














                                        StackExchange.ready(
                                        function () {
                                        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f232021%2fmagento2-error-something-went-wrong-with-processing-the-default-view-and-we-ha%23new-answer', 'question_page');
                                        }
                                        );

                                        Post as a guest















                                        Required, but never shown





















































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown

































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown







                                        Popular posts from this blog

                                        “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

                                        How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

                                        變成蝙蝠會怎樣? 參考資料 外部連結 导航菜单Thomas Nagel, "What is it like to be a...