Upgrade insecure request
Sometime an https will show an insecure sign due to some contents or 3rd party contents are not a secure https. The easier way to ensure…
-
Braintree for Paypal Client_Token
Paypal integration now required Braintree SDK, to use the Braintree SDK, you will require the Client_Token generate from the server. What is Client Token? A client…
Opencart 2.2 view order undefined error solution
If you have problem after enabled SSL, here is the quick fix. Go to admin/controller/sale/order.php in line 850 change $data[‘store_url’] = $this->request->server[‘HTTPS’] ? str_replace(“http”, “https”, $order_info[‘store_url’]) :…
Configure Monit
After installing Monit, you may want to use the web Interface. To access it you need to go to http://your.ip.address:2812 eg http://127.0.0.1:2812 If you have firewall…
Monit Installation for CentOS7
To keep thing short, I straight into Monit installation assuming you have installed CentOS7. Configure EPEL repo to download the latest version of Monit rpm -ivh…
VestaCP – FTP 530 Login Incorrect
If you are using VestaCP and facing this problem, can try the following fix. Check the FTP user path in /etc/passwd using this command cat /etc/passwd…
Force https and www using htaccess
To force a website domain with https and www, simply add this line to your www root htaccess file RewriteEngine On RewriteCond %{HTTPS} off [OR] RewriteCond…
Replace table string with SQL Query
Fastest way to replace a table field string with SQL statement. UPDATE [THETABLENAME] SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, ‘string_to_replace’, ‘new_string’)
How to check duplicate records in MySQL database?
SQL query statement to find duplicate records in a database table. SELECT fieldname1, fieldname2, COUNT(duplicatefieldname) FROM tablename GROUP BY duplicatefieldname HAVING COUNT(duplicatefieldname) > 1
Change MySQL timezone during MySQL Connect
If you are using NOW() at your MySQL query, you may have problem when you hosted the file at different timezone server. The easier way to…