Sometime if admin user is locked out, and we cant login at admin side. We receive the error message “User is locked”.
|
1 |
php magento admin:user:unlock {admin user name} |
Sometimes When we install the Magento, and try to login in admin panel with correct credentials, but it won’t be accepted and login is denied. The reason is that details were not properly saved in Database. So we can’t login in back-end.
When you install or upgrade a module, you may need to change the database structure or add some new data in current table. Magento 2 provide you some classes which you can do all of them.
There are two ways to display 404 page in Magento.
1. We can call default CMS page of 404 which is already created in back-end.
2. We can call the noroute.phtml file for 404
Sometimes, the module is disabled or it does not display any content in the site as per below screen shot. […]
If there is no any access of admin. Without login at admin side we can clear che cache.
Now, here we are describing the command:
Enable the cache use this:
|
1 |
php bin/magento cache:enable |
Disable the cache use this:
|
1 |
php bin/magento cache:disable |
Flush the cache use this:
|
1 |
php bin/magento cache:flush |
Clean the cache in the site:
|
1 |
php bin/magento cache:clean |
Execute the above command using command line and be happy. […]
In the magento 2 we can set the schedule for different theme.
1) Login to Admin panel
2) Go to Content > Design > Schedule
3) Click on “Add new Design” theme
4) Select the theme,start date, from date and save the design theme
Now check […]
We are thinking how we will run the indexing using command line and which command we will use to run this.
Now here we are describing the command:
If we need to do whole index management in the site we will run the following command in project
In root magento directory
|
1 |
php bin/magento indexer:reindex |
in root/bin directory
|
1 |
php magento indexer:reindex |
To […]
Now You are thinking How we will get write the core Query in Magento.
Let’s Start. Here We give the example of insert, update, delete, select.
|
1 2 3 4 5 6 7 8 |
$themeId=3; $this->_resources = \Magento\Framework\App\ObjectManager::getInstance() ->get('Magento\Framework\App\ResourceConnection'); $connection= $this->_resources->getConnection(); $themeTable = $this->_resources->getTableName('theme'); $sql = "Insert into " . $themeTable . "(theme_id,theme_path) Values (" . $themeId . ",'webmull/christmastheme' )"; $connection->query($sql); |
|
1 2 3 4 5 6 7 8 |
$themeId=3; $this->_resources = \Magento\Framework\App\ObjectManager::getInstance() ->get('Magento\Framework\App\ResourceConnection'); $connection= $this->_resources->getConnection(); $themeTable = $this->_resources->getTableName('theme'); $sql = "Update FROM " . $themeTable . " set theme_path='webmull/christmastheme' WHERE theme_id = " . $themeId . ";"; $connection->query($sql); |
|
1 2 3 4 5 6 7 8 |
$themeId=3; $this->_resources = \Magento\Framework\App\ObjectManager::getInstance() ->get('Magento\Framework\App\ResourceConnection'); $connection= $this->_resources->getConnection(); $themeTable = $this->_resources->getTableName('theme'); $sql = "DELETE FROM " . $themeTable . " WHERE theme_id = " . $themeId . ";"; $connection->query($sql); |
4. Select
|
1 2 3 4 5 6 7 8 9 |
$themeId=3; $this->_resources = \Magento\Framework\App\ObjectManager::getInstance() ->get('Magento\Framework\App\ResourceConnection'); $connection= $this->_resources->getConnection(); $themeTable = $this->_resources->getTableName('theme'); $sql = "Select * FROM " . $themeTable . " WHERE theme_id = " . $themeId . ";"; $connection->query($sql); |
Hope, This Will Work in your system
When we try to install Magento 2 in our wamp server we got the error
Now, You are thinking how we will overwrite the grid.php in Magento 2. Because some module has grid.php and some has not.
Now We are adding the one massaction in Sales_order Grid at admin side which has no grid.php for order.
