How to remove H1 title from category and CMS pages in Magento 2

Solution: for all category pages

/vendor/magento/module-catalog/view/frontend/layout/catalog_category_view.xml. add line close to bottom of fime

    </referenceBlock>
     <referenceBlock name="page.main.title" remove="true" /> 
</body>

Solution: for individual pages

go to admin->content- > pages ->design section and paste in the xml <referenceBlock name="page.main.title" remove="true" />

Magento2 Server reached max_children setting
WARNING: [pool staging_4pens_com] server reached max_children setting (5), consider raising it

Reaching this limit would be caused by long-running PHP processes, causing additional PHP processes from additional site traffic to begin to stack and queue which can lead to increased site load time, and eventually result in timeouts.

Solution:

increase memory_limit in php.ini to 128M

using root access increase max children setting to 15

sudo grep max_children /var/log/php?.?-fpm-sp.log.1 /var/log/php?.?-fpm-sp.log

If any of your apps have reached their max_children limit, you’ll see output like this:

[24-Apr-2017 19:56:17] WARNING: [pool my-wordpress-app] server reached max_children setting (20), consider raising it

To increase the max_children setting for an app, SSH in to your server as root and rename this file:

/etc/phpX.Y-sp/fpm-pools.d/APPNAME.d/main.conf

to this:

/etc/phpX.Y-sp/fpm-pools.d/APPNAME.d/main.custom.conf

Next, edit the file and change the value on this line to the maximum number of PHP processes you want the app to be able to have running:

pm.max_children = 20

Last step , restart that PHP server version with the command:

sudo service phpX.Y-fpm-sp restart
Magento2 Created at Date sort column/ filter on product admin grid

Solution:

We can add the below code on this file :vendor/magento/module-catalog/view/adminhtml/ui_component/product_listing.xml

<column name="created_at">
   <argument name="data" xsi:type="array">
        <item name="config" xsi:type="array">
            <item name="filter" xsi:type="string">dateRange</item>
            <item name="editor" xsi:type="string">text</item>
            <item name="label" xsi:type="string" translate="true">Created At</item>
            <item name="sortOrder" xsi:type="number">60</item>
        </item>
    </argument>
</column>

Magento2 Web Setup Wizard stuck after failed rollback

Solution:

Try running the following 2 commands from the magento root directory as the magento user:

mv var /.update_error.flag
var/.tmp_update_error.flag
var/.update_queue.json
var/.tmp_update_queue.json
This will remove the flag that causes the Web Setup Wizard to stay stuck in this state.

or manually rename these files, .update_queue.json, .tmp_update_queue.json

magento2 Recaptcha problem

reCaptcha V3 “You cannot proceed with …. your reCaptcha reputation is too low”

{“0”:”Warning: file_get_contents(): https:\/\/ wrapper is disabled in the server configuration by allow_url_fopen=0 in \/home\

Solution: Edit the php.ini file and enable using below code

allow_url_fopen = 1 //0 for Off and 1 for On Flag
allow_url_include = 1 //0 for Off and 1 for On Flag

search improvement in magento2

AND or OR? Magento’s Search Types and Search Operators,

In Magento 1.9x there is a way choose alternative search method for the on-site search, how would achieve an ‘AND’ operator for searches in Magento 2?

Here is the solution, (as always recommended backup you system and db prior to making any file changes. also it is always recommended you do not change Magento core files, instead apply this fix by creating an override custom extension/module)

edit search_request.xml
vendor\magento\module_catalog_search\etc\search_request.xml

change <queryReference clause=”should” ref=”search” />

to  <queryReference clause=”must” ref=”search”/>

//www.expertwebsolutionsinc.com/wp-content/uploads/2020/06/expertwebsoutions-bottom.png