A no nonsense notebook for nerds
-
How to install a new theme in WordPress using a compressed theme file
Follow these steps to install a new WordPress theme to your website using a compressed theme file(.zip,.tar,.rar etc): Step 1: Open the wp-content folder in the root directory of WordPress and go to the themes folder. Step 2: Upload the zip(or any other compressed file) theme file inside the theme folder. Step 3: Go back to…
-
How to remove links of a learndash course which has not started yet? without code changes
-
Simple joining of data from two different tables on basis of a common key
-
How to change WordPress user roles in MySQL database using PhpMyAdmin?
We will be editing the database rows using PhpMyAdmin tool given with cPanel by many hosting companies You can change the WordPress user roles by following the given steps: Step 1: Open phpMyAdmin on cPanel. Step 2: Open the wp_usermeta or xxx_usermeta table in the database as highlighted. (wp_ is just prefix, your table prefix…
-
Magento 2 cli commands [continued]
1. Setting GD2 as defualt image adapter from command line Magento >= 2.2 Magento >= 2.2 2. Disable Minify CSS Files option from command line Magento >= 2.2 Magento < 2.2 3. Disable Merge CSS Files option from command line Magento < 2.2
-
How to install theme in Magento 2
Download the theme and copy the app folder and paste it in your magento root directory Open Shell, in the root directory, enter php bin/magento setup:upgrade . This will upgrade all the magento files. 2. Also, Clear cache ,type php bin/magento cache:clean . 3. Now force deploy the static files by typing php bin/magento setup:static-content:deploy -f . It will take a while. 4. Now,…
-
[SOLVED] PHP must be run as a CLI application error : Content-type: text/html; charset=UTF-8
php bin/magento cache:cleanContent-type: text/html; charset=UTF-8bin/magento must be run as a CLI application as root user, run the following commands (For php v7.0) The solution involves fixing php variable’s path. We need to find which php is being used right now, you can find out by To fix this PHP cli error, see how to edit…
-
MySQL error 1449: The user specified as a definer does not exist
Why this error happens? Most of the times, reason is that your database dump through command line or PhpMyAdmin or even other libraries can have SQL’s Definer statements. Now, as per MySQL’s Official Documentation: The DEFINER clause specifies the MySQL account to be used when checking access privileges at routine execution time for routines that have the SQL…
-
Magento 2 all cli commands
-
How to connect cpanel through SSH
Following are the steps to connect to cpanel through SSH:- Go to your cpanel and create a public private key-pair, under SSH access->manage keys. 2. Under manage keys section, go on create a new key. 3. Create a key and give key name, key password, key type and key size. 4. Click on generate keys…
Got any book recommendations?