Sync files in Mac using Rsync
The terminal command used to sync folders/files between 2 locations, very useful when you want to migrate or backup NAS storage. rsync -a –progress SourceFolder/Foldername/ DestinationFolder/Foldername/…
Fail to restart Vesta at AWS Instance
It said that all about the xfs file system problem mount -o remount,rw /dev/vda1 /
VestaCP can’t enable LETSENCRYPT
If you are facing problem to enable SSL Support with Let’s Encrypt in VestaCP GUI, you may try this method. open file with your favorite editor/usr/local/vesta/data/users/—user_name—/web.conffind…
Where is Manage.io data file stored?
Manager.io data is stored in SQLite database, with .manager extension. (e.g. f565db9ce123456188729588d6f5f2269.manager) By default, you can locate it in /Users/yourusername/.local folder. You can backup this file…
Copy folder path in MacOSX
Either you like to run a command at terminal or open hidden folder in, the fastest way to get the folder path is using Finder and…
SQL query valid email format data
Suitable for creating eNewsletter or bulk email application. We can use wildcard method in SQL. SELECT * FROM tableName WHERE emailField LIKE ‘%_@__%.__%’
MySQL Select Statement to joint 2 fields value into 1 return
You can use CONCAT to join 2 fields and return in 1 select statement value. e.g SELECT CONCAT(firstName,’, ‘,lastName) as fullName FROM tableName
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’]) :…