SFTP with Filezilla and Putty
In case of IP address restrictions, if you want to connect to SFTP via another host eg.a server, you can do this by SSHing in to the other host. Open a Putty session and connect to your host using SSH.
Tips Blog
Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
Delete a Magento order in 1.9 using MySQL
To delete an order from Magento 1.9 using SQL – “100001234” is the order number : SET @increment_id=’100001234′;SELECT @order_id:=entity_id FROM sales_flat_order WHERE increment_id=@increment_id;DELETE FROM sales_flat_order WHERE entity_id=@order_id;DELETE FROM sales_flat_order WHERE increment_id=@increment_id;DELETE FROM sales_flat_invoice WHERE increment_id=@increment_id; DELETE FROM sales_flat_shipment WHERE increment_id=@increment_id;DELETE
Magento – passing a variable value to a CMS page using Layout Update XML
In Magento I wanted to pass a variable or two from a CMS Page to my phtml template file. I wanted to do this as the client wanted backgrounds to change depending on the page, but there didn’t seem to
Test “Unreachable” hacked response manually on Google Webmaster Tools – can it fetch and index your site
Came across an interesting and frustrating problem with a client website. His WordPress site had been hacked -it was an advertisement hacking and swamped his site with adverts for clothing and also cleverely re-indexed the site on Google to advertise
How to SSH and SFTP into Siteground with Notepad++, Putty and Filezilla
I was getting a lot of timeouts using Notepad++ with plain FTP on Siteground. This was very annoying. I also find SSH very useful when editing websites, so decided it would be nice to have both SFTP and SSH access
How to use fail2ban and iptables
Config files for fail2ban are in /etc/fail2ban. On CentOS fail2ban uses SYSLOG which is /var/log/messages as its log file. grep fail2ban fail2ban bans addresses for ‘bantime’ seconds (often 10minutes) in /etc/fail2ban/fail2ban.conf List currently banned IP addresses : iptables -L -nv
Magento Shipping Matrix Rates Extension Tips
Go to Configuration -> Delivery/Shipping Methods In config change “Current Configuration Scope” (top left) to Main website – to download the CSV. If this doesn’t contain the rates you need, you’ll have to edit the database table directly. The table
WordPress wp_options has grown too big
Run this – clears out Nextgen gallery rows bloating the table : DELETE FROM wp_options WHERE option_name like ‘_transient_%’ OR option_name like ‘displayed_galleries%’
How to send PHP email using GMail SMTP – Enable Gmail SMTP security – stop authentication failure SMTP: Invalid response code received from server 534 error
Was having some troubles sending using PHP SMTP email and Gmail, kept getting an error saying “error: authentication failure [SMTP: Invalid response code received from server (code: 534…). It turns out you have to authorise Gmail to allow your PHP
Plesk 11 – add an SSL certificate and a dedicated IP address – how to get working
Adding a dedicated IP address and SSL certificate to Plesk 11 by default doesn’t work, because nginx doesn’t work properly and causes 404errors amongst other things. Procedure to get it to work/install is : Tools/Settings IP address – if the
You must be logged in to post a comment.