Magento 2 after install showing blank page

Very simple. Please go to below file location  C:\xampp\htdocs\magento23\vendor\magento\framework\View\Element\Template\File\Validator.php Replace below code :  protected function isPathInDirectories($path, $directories) { if (!is_array($directories)) { $directories = (array)$directories; } $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { if (0 === strpos($realPath, $directory)) { return true; } } return false; } With: protected function isPathInDirectories($path, $directories) { if (!is_array($directories)) {Read More

Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, View, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, S HOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER privileges

Very simple Check into my.ini file in MySql config section and check whether skip-grant-tables is there below #skip-grant-tables

How to get all cli command in Magento 2

It’s very simple. Just go to your root directory. And run following command C:\xampp\htdocs\magento2> php bin/magento Output : Magento CLI 2.3.0   Usage: command [options] [arguments]   Options: -h, –help            Display this help message -q, –quiet           Do not output any message -V, –version         Display this application version –ansi            Force ANSI output –no-ansi         Disable ANSI outputRead More

Magento 2 delete all sample product data from database

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `catalog_category_product_index`; TRUNCATE TABLE `catalog_category_product_index_tmp`; TRUNCATE TABLE `catalog_compare_item`; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_price_index`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TABLE `catalog_product_bundle_selection_price`; TRUNCATE TABLE `catalog_product_bundle_stock_index`; TRUNCATE TABLE `catalog_product_entity`; TRUNCATE TABLE `catalog_product_entity_datetime`; TRUNCATE TABLE `catalog_product_entity_decimal`; TRUNCATE TABLE `catalog_product_entity_gallery`; TRUNCATE TABLE `catalog_product_entity_int`; TRUNCATE TABLE `catalog_product_entity_media_gallery`; TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;Read More

Magento 2 delete all Orders/Invoices data from database

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `gift_message`; TRUNCATE TABLE `quote`; TRUNCATE TABLE `quote_address`; TRUNCATE TABLE `quote_address_item`; TRUNCATE TABLE `quote_id_mask`; TRUNCATE TABLE `quote_item`; TRUNCATE TABLE `quote_item_option`; TRUNCATE TABLE `quote_payment`; TRUNCATE TABLE `quote_shipping_rate`; TRUNCATE TABLE `reporting_orders`; TRUNCATE TABLE `sales_bestsellers_aggregated_daily`; TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`; TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`; TRUNCATE TABLE `sales_creditmemo`; TRUNCATE TABLE `sales_creditmemo_comment`; TRUNCATE TABLE `sales_creditmemo_grid`; TRUNCATE TABLE `sales_creditmemo_item`;Read More

Magento 2 add simple product programmatically

just create a file like upload.php and run from root directory. <?php use \Magento\Framework\App\Bootstrap; include(‘app/bootstrap.php’); $bootstraps = Bootstrap::create(BP, $_SERVER); $object_Manager = $bootstraps->getObjectManager(); $app_state = $object_Manager->get(‘\Magento\Framework\App\State’); $app_state->setAreaCode(‘frontend’); $set_product = $object_Manager->create(‘\Magento\Catalog\Model\Product’); try{ $set_product->setWebsiteIds(array(1)); $set_product->setAttributeSetId(4); $set_product->setTypeId(‘simple’); $set_product->setCreatedAt(strtotime(‘now’)); $set_product->setName(‘BD product simple product’); $set_product->setSku(‘bd-pro-simple’); $set_product->setWeight(1.0000); $set_product->setStatus(1); $category_id= array(4,5,6,7); $set_product->setCategoryIds($category_id); $set_product->setTaxClassId(0); $set_product->setVisibility(4); $set_product->setManufacturer(29); $set_product->setColor(20); $set_product->setPrice(1999); $set_product->setCost(1800); $set_product->setMsrpDisplayActualPriceType(1); $set_product->setMetaTitle(‘BD product simple product’);Read More

Magento 2 install with cli mode

Go to your root directory C:\xampp\htdocs\magento2> and run following command php bin/magento setup:install –base-url=”http://127.0.0.1/magento2/” –db-host=”localhost” –db-name=”databasename” –db-user=”databaseuser” –db-password=”databasepass” –admin-firstname=”Yourname” –admin-lastname=”Yourname” –admin-email=”borntowinanwar@gmail.com” –admin-user=”admin” –admin-password=”strongpassword” –backend-frontname=”admin”

Magento 2 after install shows blank page

Please below instruction hope it will resolve. Just got to vendor/magento/framework/View/Element/Template/File/validation.php And go to line 138 lines Replace  $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { if (0 === strpos($realPath, $directory)) { return true; } } With  $realPath = $this->fileDriver->getRealPath($path); foreach ($directories as $directory) { $directory = $this->fileDriver->getRealPath($path); if (0 === strpos($realPath, $directory)) { returnRead More