Run the following command
sed -i '1,200d' file_name.sql
All posts by Pramod T P
Magento 2 Show Current Mode
Run the following command
php bin/magento deploy:mode:showSQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed, query was
Just set is_used_in_grid as false.
Extract sql.gz file
You can use the below command to extract sql.gz file.
gzip -d example.sql.gz
windows 10 host file location
C:\Windows\System32\drivers\etc
Expand Root Partition CentOS
Run the following command to increase the root partition
lvextend -L+15G /dev/mapper/centos-root && xfs_growfs -d /dev/mapper/centos-root
magento 2 multi store default nginx configuration
map $http_host $MAGE_RUN_CODE {
in.phpcodez.com default;
}
map $http_host $MAGE_RUN_TYPE {
in.phpcodez.com store;
}
server {
listen 80;
server_name in.phpcodez.com;
set $MAGE_ROOT /usr/share/nginx/html/phpcodez;
set $MAGE_MODE developer;
include /usr/share/nginx/html/phpcodez/nginx.conf.sample;
}
Invalid Base URL. Value must be a URL or one of placeholders: {{base_url}}
Make sure that URL ends with a /(slash) .
example : http://phpcodez.com/
magento 2 increase session timeout
- Log in to Magento using your administrator account.
In the left sidebar, click Stores, and then under Settings, click Configuration. - Click Advanced, and then click Admin.
Under Security, in the Admin Session Lifetime (seconds) text box, - type the session timeout interval in seconds that you want to use. For example, a value of 1200 sets a timeout interval of 20 minutes.
- Click Save Config.
- Log out of Magento, and then log back in. The new session timeout interval is now active.
Magento 2 Observers
Observers are the particular classes that control the general behavior, performance, or change in the business logic of the store. They are executed whenever a specific event for which they were set to listen is triggered.
To create an observer in Magento 2, you must place your class file under the ModuleRoot/Observer directory. The observer class file should use Magento\Framework\Event\Observer and Magento\Framework\Event\ObserverInterface class and define the executive function.