For example, you may have table with varchar, text or longtext fields and you may see garbled data in it. Though the text appears correctly on web pages, inside MySQL junk characters may appear. CREATE TABLE `my_news` ( `nid` bigint(10) NOT NULL DEFAULT '0', `title` text, `short_news` longtext) ENGINE=MyISAM DEFAULT CHARSET=utf8; In order to correct this error, try to alter the table in the following sequence. (more…)

In order to redirect HTTP to HTTPS in express server, try adding the following lines to your code base. app.set('trust proxy', 1); app.use(function(req, res, next) { if (! req.secure){ res.redirect("https://" + req.headers.host + req.url); } return next(); });

Step 1: Identify the user id for which you want to change the password Step 2: Issue the below MySQL command to update the password for the selected user update wpgi_users set user_pass=MD5('yourpasswordgoeshere') where wpgi_users.id=1

In order to force redirection of your website developed in Laravel from HTTP to HTTPS, you can try adding the following rules in .htaccess file. <fModule mod_rewrite.c> Options -Indexes RewriteEngine On RewriteCond %{HTTPS} !=on RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] RewriteRule ^(.*)$ public/$1 [L] </IfModule> Next, look at .env file and modify the value for APP_URL parameter APP_URL=https://yoursite.com

In order to force redirection of your Wordpress website from HTTP to HTTPS, the key task that you will need to do is to modify .htaccess file that is present in the root of the website directory. If you check your wordpress install, you will have the following code by default in your .htaccess file. <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / # BEGIN WordPress RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> (more…)

If you want to add certain files that was previously removed from Git repository, follow the steps given below. STEP 1: remove the file reference in .gitignore STEP 2: remove the cached reference from git. $ git rm --cached sampleconfig.txt (more…)