Recent Updates Toggle Comment Threads | Keyboard Shortcuts

  • Wayne 11:29 pm on March 2, 2014 Permalink | Reply  

    wp clean up plugin 

    This plugin a beauty for trimming a bloated akismet database from wordpress. See here my kismet has over 600,000 entries of spam – bloating my wordpress table and slowing my site down. This plugin removes them with a click. No need to use phpmyadmin.


    Screen Shot 2014-03-03 at 10.27.04 am

  • Wayne 10:48 pm on January 28, 2014 Permalink | Reply  

    LOVE Fisher and Paykel 

    Our 10 year old washing machine pump motor has a small leak around the shaft.
    1. Download Fisher and Paykel service manual from the web.
    2. Order new pump  from ebay (from ASAP spare parts) for $36.30.
    3. Undo old motor and put new motor in – I DIDN’T EVEN NEED A SCREW DRIVER – It just had a plastic tab to flip and the pump motor screwed out with 1/3 turn.


    Diagnose leaky pump: 15 min

    Find and order part: 30 min.

    Time for part to arrive: 4 days.

    Undo old pump and install new pump:  5 min.

    Thanks Fisher and Paykel.


  • Wayne 3:23 am on November 16, 2013 Permalink | Reply  

    For those of you interested in health issues, I’ve started a little blog here keeping tabs on controversial health issues.

  • Wayne 4:43 am on September 13, 2013 Permalink | Reply
    Tags: deals, travel   

    Cheap Travel 

    Some good websites for cheap travel deals:



    We got tickets from Sydney to Auckland for $108 each one way (Carry on baggage only)

    We got tickets from Auckland to Sydney for $76.35 each one way  (Carry on baggage only)


    So we also booked a couple of full cost seats with Air New Zealand and Jetstar with carry on luggage to go with the 5 cheap deals with no luggage.



    Hire Car:

    I got a hire car for 1 day in Sydney for $31.

    I booked a hire car in New Zealand (Auckland) for $16 per day. Man that is cheap.


    Hired a car for $36 per day in Queenstown, but this included one free ski lift pass per day at Treble Cone ($97 value!)

    So the car cost $267 for the week but we saved on 2 ski passes so the car really cost $71 for the week.



    If you are going to NZ and can be bothered filtering through junk emails, sign up here and you’ll find a good deal in amongst all the many not so good deals. Having said that, the good deals are VERY good!

  • Wayne 10:51 pm on August 19, 2013 Permalink | Reply  

    How to secure wordpress 

    1. Make sure you have most up to date wordpress
    2. change database prefix from wp_ to something else (WSD Security plugin will do this)
    3. change default admin username  from admin to something else (add new admin, log out, log in under new user, delete old admin, choose import posts option when u do it.)
    4. move config.php and files containing Passwords to MySQL to a secure directory outside of the public_html folder and then add this to to wp_config.php
      require(‘new path goes here…/yourconfigfile.php’);
    5. RESTRICT ADMIN TO YOUR IP so that no one else can login to your admin page:
      go to wp-admin directory and add to htaccess file:
      <LIMIT GET>
      order deny,allow
      deny from all
      allow from

      1. BEGIN WordPress
    6. install wp secure plugin and select most of the options!
    7. Store your PHP passwords to access your MySQL databases in a file with a .inc.php and  place this file in a directory which is above the server’s document root.
    8. Run WP Security Scan
    • Yuliya 8:08 am on October 9, 2013 Permalink | Reply

      Good day Wayne!
      Thank you very much for your theme slidingdoor.
      I have one problem about this and I just hope you can help me. Could you please tell me if there is the “use as featured image” option? I can’t find it anywhere. I really want use this theme for our website and will be very apset if there wasn’t any way to use it.
      Thank you in advanced.

  • Wayne 12:27 am on June 25, 2013 Permalink | Reply  

    Huge commentmeta file in wordpress database. 

    A surprising email:

    It has come to our attention that your site is using an excessive amount of MySQL resources on your Bluehost account.

    So some looking into it, the wordpress commentmeta SQL table for was 2.7 Gig. Yes 2.7 GB!!!!!

    More looking, it’s a bug with Akismet spam filter cleanup.


    These two queries fix it.

    select count(*) from dbname_commentmeta where meta_key=’akismet_as_submitted’ or meta_key=’akismet_history’ or meta_key=’akismet_rechecking’ or meta_key=’akismet_result’ or meta_key=’akismet_user’ or meta_key=’akismet_user_result’;

    delete from dbname_commentmeta where meta_key=’akismet_as_submitted’ or meta_key=’akismet_history’ or  meta_key=’akismet_rechecking’ or meta_key=’akismet_result’ or meta_key=’akismet_user’ or  meta_key=’akismet_user_result’;


    Then you need to repair and optimise.

    • Mary 6:52 am on December 15, 2013 Permalink | Reply

      Hi Wayne,

      I’m a graphic designer who happens to maintain my own WordPress website. I have used your Sliding Door theme for many years and love it for my watercolors. I updated my WP as they suggest in my dashboard, not thinking that it wouldn’t be compatible with your theme but it appears that my updates in the dashboard (local server) are not sticking when I log out and go to the public host view.

      I’ve scoured the Sliding Door Forum phpBB but cannot find anything in 2013 that relates to this. It looks like the theme has no updates since 12/2012. Please help…

      What do I need to do to make my updates work? Can I return to a former version of WordPress?

      Thanks and God bless,

    • Wayne 11:26 pm on March 2, 2014 Permalink | Reply

      new plugin called “wp clean up” now does this better.

  • Wayne 5:33 am on February 24, 2013 Permalink | Reply
    Tags: experiment   

    • Wayne 5:41 am on February 24, 2013 Permalink | Reply

      This is on telstra 4G – no better. Limit might be hangout resolution limit of 420pixels rather than upload bandwidth.

  • Wayne 10:20 am on February 6, 2013 Permalink | Reply  

    Virgin Mobile 

    In 2007 I had a problem with Virgin Mobile.

    Here is the first letter I sent:

    virgin complaint

    I didn’t hear back so I sent a second letter:

    virgin complaint 2

    I still didn’t hear back so I rang the Telecommunications Ombudsman who said I’d be better of taking it up with my Credit Card people. So I rang the credit card people, they were very very good. They rang me back and said they had given Virgin a set time to fix the problem.

    Since then you can now access your Virgin cap plan balance from the web.

    My only advice is write everything down. Make notes of every conversation you have with a phone company.

  • Wayne 7:02 am on December 27, 2012 Permalink | Reply  

    Extract camera information from a picture. 

    This webpage:

    allows you to extract information from a photo such as what camera took it, what time and so on.


  • Wayne 6:22 am on October 18, 2012 Permalink | Reply
    Tags: Electrolux   

    Electrolux woes 

    Well we’ve had our Electrolux oven for 4 weeks and have been waiting for a new door for 3 weeks! It doesn’t close so we need to prop it closed with a chair.

    Meanwhile we are still waiting almost 4 weeks for new glass for our Electrolux cooktop that smashed. Electrolux is hopeless for support!!! Should have gone Miele for the oven like we did with our Miele dishwasher (very happy with the Miele)..

    Here is the chair holding the oven shut and the missing cooktop.


    • Wayne 3:38 am on June 25, 2013 Permalink | Reply

      UPDATE: Door problem has happened again. This Oven is badly designed.

compose new post
next post/next comment
previous post/previous comment
show/hide comments
go to top
go to login
show/hide help
shift + esc