MAGE2DB.COM

Magento 2.2, Magento 2.3, Magento2.4 Installation Issue on Windows 10, XAMPP

Magento 2 Installation at 51% Error: (Wrong file in Gd2.php:64) Module ‘Magento_Theme’

Magento 2.x Login As Customer Not Enabled

Posted on November 12, 2021May 3, 2022 by John

If above error as Image or “Login As Customer Not Enabled” occurs

Solution : There are following below link to redirect on solution page , where each steps has been explained properly.

The user has not enabled the “Allow remote shopping assistance” functionality. Contact the customer to discuss this user configuration

Magento 2 All Database Tables [500 & more Tables]

How To Set Multi Shipping Settings In Magento 2

How To Set Origin Shipping in Magento 2

Difference Between Offline Shipping Method and Online Shipping Method

Magento 2 Online Customers Options

How To Apply Customer Group Price of Products in Magento 2

How To Add Customer Groups Dropdown in Magento 2 Admin Form and Grid By UI Component

How To Get all Customers Data in Magento 2

How To Create Customer Order in Magento 2 Admin Panel

Magento 2 Login As Customer Not Enabled

How To Configure Customer Account Sharing Options in Magento 2

Magento 2 Redirect To Customer Dashboard After Login

Which Magento 2 database table store customer shipping and billing address

How To Remove Sales Order Data & Customer Data in Magento 2

Which Magento 2 database table store customer’s Email Data

Which Magento 2 Database Table Store Customer Newsletter Data

Which Magento 2 database table store customer’s shipping and billing address

How To Remove Sales Order Data & Customer Data in Magento 2

Which Magento 2 Database Tables Store Customer Rating

Which Magento 2 Database Tables Store Customer Wishlist Products

Magento 2 Increase Customer Session Time

Which Magento 2 Database Table Store Patches

The user has not enabled the “Allow remote shopping assistance” functionality. Contact the customer to discuss this user configuration

Posted on November 12, 2021January 7, 2022 by John

Mageno 2, this errors occurs while Admin trying to login as Customer Login from admin end due to following below reasons.

[1] – To view store as Customer’s point of view.
[2] – To modify Customer’s Data as per their permission.
[3] – To check Sales Order, Invoice, Shipment process, delivery status as per customer’s permission.
[4] – To assist customers, how to shopping, as Best Shopping Deals, Best Running Discount, Festive Offers etc.

Solution For :: The user has not enabled the Allow remote shopping assistance functionality. Contact the customer to discuss this user configuration

There are following below steps need to follow

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Left panel, choose CUSTOMERS > Login as Customer

Step [3] -Right panel opened Login as Customer Settings

Login as Customer Settings having following fields

Enable Extension : Select Yes to enable Admin Login as Customer

Disable Page Cache For Admin User : If Yes, the page cache will be disabled for the admin user.

Store View To Login To : There two drop down values

by default Auto-Detection & Manual selection

Use the “Manual Selection” option on a multi-website setup that has “Share Customer Accounts” enabled globally. If set to “Manual Selection”, the “Login as Customer” admin can select a Store after logging in.

Title For Login As Customer Opt in Checkbox : To change name for Title For Login As Customer, by default “Allow remote shopping assistance”

Login As Customer Checkbox Tooltip : To change description for Login As Customer Checkbox Tooltip

By default “This allows merchants to “see what you see” and take actions on your behalf in order to provide better assistance.”

Step [4] – Finally clicked on Save Config button & clear cache

All above steps settings applicable upto Magento 2.3.7

Once Release Magento 2.4, customers will also have to enable Allow remote shopping assistance from their Dashboard before an admin can log in:

Go Customer’s Account Dashboard & left side click on Account Information & checked Allow remote shopping assistance

If a customer has not enabled this option (Magento 2.4 and Later Version), then when an admin tries to log in to their account, an error message will be displayed: “The user has not enabled the “Allow remote shopping assistance” functionality. Contact the customer to discuss this user configuration.”

If Admin want to avoid this exta step, disable the module LoginAsCustomerAssistance via command line in Root Directory (Magento 2.4 & later version)

php bin/magento module:disable Magento_LoginAsCustomerAssistance

Once above command run, option “Allow remote shopping assistance “
will be not displayed in Customer Account DashBoard Section

How do disable Allow remote shopping assistance in Magento 2.4

How To Install Magento 2.4.x & 2.4.5 via Composer

Posted on November 11, 2021August 27, 2022 by John

There are following below Steps need to follow

Here, we considering machine has been already installed following below software as per compatibility of Magento 2.4 Requirement

PHP Latest Version 7.4 or above
Elastic Search Latest Version 7.6 & above
MYSQL Latest Version 5.7 or 8.0
Apache Version 2.4 or Nginx Version 1.8
Composer 2.0

Step[1] – Download Magento 2.4

Run the following below command in the root directory [Create Empty Folder inside C:/xampp/htdocs/magento244] to download Magento 2 by using composer

[1.1] Magento 2.4 Community Edition

composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition .

[1.2] [ Magento 2.4.x Enterprise Edition (Adobe Commerce Enterprise Edition 2.4.x) / Magento 2.4.x Cloud Edition 2.4.x (Adobe Commerce Cloud Edition 2.4.x) ]

Here below command for Magento 2.4.4

composer create-project --repository-url=https://repo.magento.com/ magento/project-enterprise-edition=2.4.4 .

Step[2] – Set Correct Directory & Files Permission

Run the following below command in the root directory to set correct Directory & Files Permission

sudo chmod 777 app/etc

sudo chmod 644 app/etc/*.xml

find var -type d -exec chmod 777 {} \;

find pub/media -type d -exec chmod 777 {} \;

find pub/static -type d -exec chmod 777 {} \;

sudo chmod -R 777 generated

sudo chmod -R 777 var

sudo chmod u+x bin/magento

Step[3] – Magento 2.4 Instllation Command

Run the following below command to Magento 2.4

php bin/magento setup:install --base-url="http://127.0.0.1/magento24sample/" --db-host="localhost" --db-name="magesampledata24" --db-user="root" --admin-firstname="admin" --admin-lastname="admin" --admin-email="admin@admin.com" --admin-user="admin" --admin-password="admin123" --language="en_US" --currency="INR" --timezone="America/Chicago" --use-rewrites="1" --backend-frontname="admin"

--------------------------------------------------------------------

Above Command having following below data

[1] base-url=http://127.0.0.1/magento24sample/
[2] db-host="localhost"
[3] db-name::" magesampledata24"
[4] db-user:: "root"
[5] admin-firstname="admin"
[6] admin-lastname="admin"
[7] admin-email="admin@admin.com"
[8] admin-user="admin"
[9] admin-password="admin123"
[10] language="en_US"
[11] currency="USD"
[12] timezone="America/Chicago"
[13] use-rewrties="1"
[14] backend-frontname="admin"

Steps[4] – Magento 2.4 Installation Process Showing

Similarly, way as above will be displayed other running steps

Finally last two running steps

If Message displaying as below, indicates, Magento 2 Installation has been successfully installed.

[SUCCESS]: Magento installation complete.
[SUCCESS]: Magento Admin URI: /admin

Run below CLI Command

php bin/magento deploy:mode:set developer

php bin/magento setup:upgrade

php bin/magento setup:static-content:deploy -f

php bin/magento indexer:reindex

php bin/magento cache:clean

php bin/magento cache:flush

Now run, Magento 2.4 Frontend URL as well as Admin URL

http://127.0.0.1/magento24sample/
http://127.0.0.1/magento24sample/admin 

admin credentials admin / admin123

During Installation,

When installing Magento 2.4.x & if getting below error

In PatchApplier.php line 170:
Unable to apply data patch Magento\Theme\Setup\Patch\Data\RegisterThemes for module Magento_Theme. Original exception message: Wrong file
In Gd2.php line 64:
Wrong file
Error format as below

Solution: Find validateURLScheme function in vendor\magento\framework\Image\Adapter\Gd2.php file. at line 96. Replace function with this: !file_exists($filename)

Replace existing validateURLScheme function with modified validateURLScheme function as per below code

private function validateURLScheme(string $filename) : bool
  {
      $allowed_schemes = ['ftp', 'ftps', 'http', 'https'];
      $url = parse_url($filename);
      if ($url && isset($url['scheme']) && !in_array($url['scheme'], $allowed_schemes) && !file_exists($filename)) {
          return false;
      }

      return true;
  }

Finally, Magento 2.4 or 2.4.x Installation will be completed 100% after above changes by Composer

If you want to Magento 2.4.x Sample Data Deployment, follow below Link

How to Install Magento 2.4.x with Sample Data via Command Line

Other Important Magento 2.X Link

Magento 2.3 To Magento 2.4.5 Comptibility For PHP, MYSQL, Composer, Apache etc

Magento 2.2, Magento 2.3, Magento2.4 Installation Issue on Windows 10, XAMPP

Magento 2 Installation at 51% Error: (Wrong file in Gd2.php:64) Module ‘Magento_Theme’

How To Check SEO Rewrite Enabled or Not in Magento 2.x By Using Database

Posted on November 10, 2021May 3, 2022 by John

There are following below SQL Query need to run in Magento 2 Database To Check SEO Rewrite Enabled or Not

select * from core_config_data where path = "web/seo/use_rewrites";

Which SQL Query To Display Multiple Websites & Stores in Magento 2.x

Posted on November 10, 2021May 3, 2022 by John

There are following below SQL Query need to run.


SELECT * FROM `core_config_data` WHERE path in 
("web/unsecure/base_url", 
  "web/unsecure/base_link_url", 
  "web/secure/base_url", 
  "web/secure/base_link_url"
);

As above Query, when run Query, display all websites / Stores in Magento 2

[1] Scope_ID = 0 & Its Website Value = http://dev.abc.com/

[2] Scope_ID = 2 & Its Website Value = http://dev.xyz.com/

[3] Scope_ID = 6 & Its Website Value = http://dev.pqr.com/

[4] Scope_ID = 10 & Its Website Value = http://dev.demo.com/

[5] Scope_ID = 13 & Its Website Value = http://dev.demostore.com/

Here Scope_ID Refer Store ID

Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation

Posted on November 9, 2021January 8, 2022 by John

While MySQL Database trying to import & getting below error

“Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation”

Solution :: Before start to import, need to run below sed command, for database, that you want to import, here database name magento24.sql

sed 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i /var/www/html/magento24.sql

“sed command removing the DEFINER= statement from database file”

After that run MySQL Database import Command

mysql -u root -p magento24  < /var/www/html/magento24.sql

It will be working fine, Finally issue has been resolved.

How To Run Apache, PHP 7.4 & MySQL on CentOS 7 or 8

Posted on November 8, 2021January 30, 2022 by John

[1] – Apache Sever :: Apache Start, Restart, Stop & Status check on CentOS 7/8

[1.1] – Apache Start Command on CentOS 7/8::

sudo systemctl start httpd

[1.2] – Apache Restart Command on CentOS 7/8 ::

sudo systemctl restart httpd

[1.3] – Apache Stop Command on CentOS 7/8 ::

sudo systemctl stop httpd

[1.4] – Apache Status Command on CentOS 7/8 ::

sudo systemctl status httpd

[2] – PHP 7.4 :: Start, Restart, Stop & Status Check on CentOS 7/8

[2.1] – PHP 7.4 Start Command on CentOS 7/8::

sudo systemctl start php74-php-fpm.service

[2.2] – PHP 7.4 Restart Command on CentOS 7/8::

sudo systemctl restart php74-php-fpm.service

[2.3] – PHP 7.4 Stop Command on CentOS 7/8::

sudo systemctl stop php74-php-fpm.service

[2.4] – PHP 7.4 Status Command on CentOS 7/8::

sudo systemctl status php74-php-fpm.service

[3] MYSQL 5.7 / 8 :: Start, Restart, Stop & Status Check on CentOS 7/8

[3.1] – MYSQL 5.7 / 8 Start Command on CentOS 7/8::

sudo service mysqld start

[3.2] – MYSQL 5.7 / 8 Restart Command on CentOS 7/8::

sudo service mysqld restart

[3.3] – MYSQL 5.7 / 8 Stop Command on CentOS 7/8::

sudo service mysqld stop

[3.4] – MYSQL 5.7 / 8 Status Command on CentOS 7/8::

sudo service mysqld status

Other important Magento 2.4.x issue as below

Magento 2.3 To Magento 2.4.5 Comptibility For PHP, MYSQL, Composer, Apache etc

Magento 2.2, Magento 2.3, Magento2.4 Installation Issue on Windows 10, XAMPP

Magento 2 Installation at 51% Error: (Wrong file in Gd2.php:64) Module ‘Magento_Theme’

What is Composer.json Format in Magento 2.3 & After Upgrade in Magento 2.4 Enterprise Edition & Commerce Cloud Edition

Posted on November 7, 2021January 30, 2022 by John

Once you upgrade Magento 2.3 Enterprise Edition & Commerce Cloud Edition To Magento 2.4 Enterprise Edition & Commerce Cloud Edition

Format Composer.json [ Magento 2.3 Enterprise Edition & Commerce Cloud Edition ]

{

    "name": "magento/project-enterprise-edition",

    "description": "eCommerce Platform for Growth (Enterprise Edition)",

    "type": "project",

    "version": "2.4.0",

    "license": "OSL-3.0",

    "config": {

        "preferred-install": "dist",

        "sort-packages": true

    },

    "repositories": {

        "repo": {

            "type": "composer",

            "url": "https://repo.magento.com"

        }

    },

    "require": {
        "aheadworks/module-blog": "^2.7",
        "cloudinary/cloudinary-magento2": "1.15.2",
        "cybersource/global-payment-management": "3.3.0",
        "dotmailer/dotmailer-magento2-extension": ">=4.4.0 <4.5.1",
        "laminas/laminas-mime": "^2.7",
        "magento/magento-cloud-metapackage": ">=2.3.5 <2.3.6"
    },

    "suggest": {

        "ext-pcntl": "Need for run processes in parallel mode"

    },

    "conflict": {

        "gene/bluefoot": "*"

    },

    "autoload": {

        "psr-4": {

            "Magento\\Setup\\": "setup/src/Magento/Setup/",

            "Magento\\": "app/code/Magento/",

            "Zend\\Mvc\\Controller\\": "setup/src/Zend/Mvc/Controller/"

        },

        "psr-0": {

            "": [

                "app/code/",

                "generated/code/"

            ]

        },

        "files": [

            "app/etc/NonComposerComponentRegistration.php"

        ],

        "exclude-from-classmap": [

            "**/dev/**",

            "**/update/**",

            "**/Test/**"

        ]

    },

    "autoload-dev": {

        "psr-4": {

            "Magento\\Sniffs\\": "dev/tests/static/framework/Magento/Sniffs/",

            "Magento\\Tools\\": "dev/tools/Magento/Tools/",

            "Magento\\Tools\\Sanity\\": "dev/build/publication/sanity/Magento/Tools/Sanity/",

            "Magento\\TestFramework\\Inspection\\": "dev/tests/static/framework/Magento/TestFramework/Inspection/",

            "Magento\\TestFramework\\Utility\\": "dev/tests/static/framework/Magento/TestFramework/Utility/"

        }

    },

    "minimum-stability": "alpha",

    "prefer-stable": true,

    "extra": {

        "component_paths": {

            "trentrichardson/jquery-timepicker-addon": "lib/web/jquery/jquery-ui-timepicker-addon.js",

            "components/jquery": [

                "lib/web/jquery.js",

                "lib/web/jquery/jquery.min.js",

                "lib/web/jquery/jquery-migrate.js"

            ],

            "blueimp/jquery-file-upload": "lib/web/jquery/fileUploader",

            "components/jqueryui": [

                "lib/web/jquery/jquery-ui.js"

            ],

            "twbs/bootstrap": [

                "lib/web/jquery/jquery.tabs.js"

            ],

            "tinymce/tinymce": "lib/web/tiny_mce_4"

        },

        "magento-force": true,

        "magento-deploystrategy": "copy",
		"composer-exit-on-patch-failure": true,
        "patches": {
            "magento/module-customer": {
               "Unsuscribe email: Customer sent newsletter unsubscribe email when registering for a new account": "m2-hotfixes/newsletter.patch"
            }
        }

    }

}

Format Composer.json [ Magento 2.4 Enterprise Edition & Commerce Cloud Edition ]

Once Upgrade Magento 2.3 Enterprise Edition & Commerce Cloud Edition To Magento 2.4 Enterprise Edition & Commerce Cloud Edition

{

    "name": "magento/project-enterprise-edition",

    "description": "eCommerce Platform for Growth (Enterprise Edition)",

    "type": "project",

    "version": "2.4.0",

    "license": "OSL-3.0",

    "config": {

        "preferred-install": "dist",

        "sort-packages": true

    },

    "repositories": {

        "repo": {

            "type": "composer",

            "url": "https://repo.magento.com"

        }

    },

    "require": {
        "magento/product-enterprise-edition": "2.4.0",
		"aheadworks/module-blog": "^2.7",
        "cybersource/global-payment-management": "3.3.0",
        "dotmailer/dotmailer-magento2-extension": "4.6.0",
        "laminas/laminas-mime": "^2.7",
        "magento/magento-cloud-metapackage": ">=2.4.0 <2.4.3"
    },

    "suggest": {

        "ext-pcntl": "Need for run processes in parallel mode"

    },

    "conflict": {

        "gene/bluefoot": "*"

    },

    "autoload": {

        "psr-4": {

            "Magento\\Setup\\": "setup/src/Magento/Setup/",

            "Magento\\": "app/code/Magento/",

            "Zend\\Mvc\\Controller\\": "setup/src/Zend/Mvc/Controller/"

        },

        "psr-0": {

            "": [

                "app/code/",

                "generated/code/"

            ]

        },

        "files": [

            "app/etc/NonComposerComponentRegistration.php"

        ],

        "exclude-from-classmap": [

            "**/dev/**",

            "**/update/**",

            "**/Test/**"

        ]

    },

    "autoload-dev": {

        "psr-4": {

            "Magento\\Sniffs\\": "dev/tests/static/framework/Magento/Sniffs/",

            "Magento\\Tools\\": "dev/tools/Magento/Tools/",

            "Magento\\Tools\\Sanity\\": "dev/build/publication/sanity/Magento/Tools/Sanity/",

            "Magento\\TestFramework\\Inspection\\": "dev/tests/static/framework/Magento/TestFramework/Inspection/",

            "Magento\\TestFramework\\Utility\\": "dev/tests/static/framework/Magento/TestFramework/Utility/"

        }

    },

    "minimum-stability": "alpha",

    "prefer-stable": true,

    "extra": {

        "component_paths": {

            "trentrichardson/jquery-timepicker-addon": "lib/web/jquery/jquery-ui-timepicker-addon.js",

            "components/jquery": [

                "lib/web/jquery.js",

                "lib/web/jquery/jquery.min.js",

                "lib/web/jquery/jquery-migrate.js"

            ],

            "blueimp/jquery-file-upload": "lib/web/jquery/fileUploader",

            "components/jqueryui": [

                "lib/web/jquery/jquery-ui.js"

            ],

            "twbs/bootstrap": [

                "lib/web/jquery/jquery.tabs.js"

            ],

            "tinymce/tinymce": "lib/web/tiny_mce_4"

        },

        "magento-force": true,

        "magento-deploystrategy": "copy",
		"composer-exit-on-patch-failure": true,
        "patches": {
            "magento/module-customer": {
               "Unsuscribe email: Customer sent newsletter unsubscribe email when registering for a new account": "m2-hotfixes/newsletter.patch"
            }
        }

    }

}

Other important Magento 2.4.x issue as below

Magento 2.3 To Magento 2.4.5 Comptibility For PHP, MYSQL, Composer, Apache etc