I have had a problem where when editing seemingly large wordpress pages I am served up a blank page instead of the editor. This seems to happen soley on large pages, but there was no common limit.

Digging abit further I managed to fix it by looking at the database that ran the wordpress install. The blog had around 300 posts, but the WP_POSTS had roughly 3000 posts in it!

What happens is while editing pages various ‘autosaves’ are created, which is great for backups and revisions. A problem arises when the pages are massive, as multiple copies are created and not always cleared. When the wordpress editor loads up, it must attempt to load all these extra versions, which combined means wordpress/server/the world craps out and stops working.

To solve this, you need to view the raw database, and take these steps, please backup your database before doing so!

• find out the post id number by hovering over the ‘edit’ link in your wordpress admin area.
• open phpmyadmin and view the WP_POSTS table
• Use the ’search’ function in phpMyAdmin to find the ‘post title’ of the entry you want (use the %%Like%% option)
• A page of results will come up
• Click ‘id’ to sort by ID
• The page will rejig, the lowest post number will probably be the ‘live’ post, you can tell by looking at the ‘post name’ field, and if it says ‘autosave’ then its one of the ones taking up room!
• I then delete all but the real post, obviously, and the latest autosave post.
• Voila, wordpress now only has the normal post and one autosave to load.
• Job done.

I hope this helps others as I can see alot of queries in google over this!

Yet again I fail to blog for a while, so resort to ‘here are some nice pictures’ going by the theory that they speak a thousand words. Thus this post may seem low on content, but it really is about 20,000 words long!

I ended up helping Wrex The Dragon

I am now living up in Edinburgh…

… which is close to St Andrews.

Bought another car, third one inside the year which is abit odd. This one even has the poncey plate (finally)!

Anyway, this is sunny Edinburgh around where we are living. Loving it…

…and they brew Deuchars IPA here so even better!

Hopefully an update before Feb 2009 – however whenever I do online stuff it seems to be work related. Fingers crossed the No1 project will be live and kicking fully in 2009 which ought to mean more fun blog stuff over there…!

Usual story, not alot of updating so a fair bit to blitz through since Feb so here is 3 months in pictures…

I was leaving Australia for a while so it made sense to sell ‘Jeremy’ the car. Due to exchange rates I even managed to make a profit…!

So goodbye to nice proper beaches for abit!

A few days later I was back to sunny UK weather:

Luckily we had a trip to Italy sorted so I ended up in a nice warm Rome:

From there we went down to the Amalfi coast area / Capri / Naples etc.

Whilst down there we visited Pompei, which had not changed since I had been last, nor the last 2000 years as far as I could tell.

The logical thing after that is to go up the closest active volcano, where I was snapped being a geek checking GPS on my phone to work out what I was looking at.

The weather picked up when we went down to Capri so here is the obligatory Brit-In-Med shot:

We took a ferry from Capri to Positano which took about an hour more than it ought to due to bad sea fog. If you take a photo in fog this is what it comes out like:

After abit more travelling about down the coast we went back to Rome, where Amy captured this cracking shot

and I had some tasty Thrush

On return to the UK the coldness was cemented with a roadtrip up to Edinburgh (where I will be based for abit) through the BRRRR highlands:

then back down to beautiful North Wales. Bish Bash Bosh thats the last couple of months

There have been a few more trips up to Edinburgh / London etc but I think thats enough procrastination for now…

After the ease of the last post I thought I would hook up the phone and upload a few quickie pictures of what has happened over the last week. The ‘new’ (2 month old) gadget is a Nokia N95 8gig version which has a great camera (5mp) inbuilt which is all very funky.

This is some home brewing, just look at this beast:

Co-brewer Nick has just returned from Thailand / Cambodia / Other such places, and it seems some of the local brews take a ‘NOB’ approach to their ABV %ages. We know the one pictured above is around 10-13% abv, however what exactly we do not no. We brewed this beast a few months back and it has certainly matured into a decent moreish beer, however in 750ml bottles it is a fair amount so one for the night is the reccomended dose.

This is a baby tree frog, taken while clinging to someones t-shirt so the fibres give some scale to it. It still makes you stop and think sometimes when you hear what appears to be jurassic park outside, hear tales of brown snakes (super venomous ones) or the local 12 foot python that has just eaten a neighbours cat in full view of the owners.

This place is quite wild compared to Europe, but I am slowly coming around to the auzzy way of getting on with it rather than worrying about what is about to leap out at you. I did see what could have been a snake tail slithering outside the other day, however I was told it was more likely to be a blue tounge lizard. I must admit I was tempted for a split second to investigate further, then then decided it was quite nippy so gave it a miss.

We were out having a great meal that night and then cocktails later on at the wonderful Bowery Bar , and bumped into these guys above kicking off the Chinese New Year celebrations plus a load of kids juggling knives / axes and banging drums. All good fun , and certainly at 29C and humid in the evening, a fair bit warmer than back in China!
Australia are playing Qatar tomorrow, the Roar v Sydney on Friday so a footballing feast to come plus the prospect of my big project actually going live for the first time means a busy yet fun week ahead.