Martyn

I like to run up hills and surprise the view. I lookup things I don’t understand. I go on long walks. I like hills, trees, open spaces. I enjoy natural navigation. I prefer books to kindles and I read carefully. I always have a pen knife and string.

Search and replace words and text throughout your entire WordPress blog

MySQL, On The Front Line, Programming, Tech No Responses »

Dec 282011

I recently changed the layout and the column resize effected the display of images and Picasa galleries. To overcome these issues I used the MySQL REPLACE command which made changing embedded HTML a breeze.

If you do not know how to run SQL statements against your database it is probably better that you do not try this as it may lead to serious damage to your blog, it may even destroy all your work so take care.

Start by taking a full backup of your database. Then take a copy of the wp_posts table so should disaster happen recovery will be simple and fast.

UPDATE wp_posts
SET post_content =
REPLACE(
	post_content,
	'width="800" height="533"',	
	'width="650" height="432"'
)

In the above example I wanted to replace all entries with a width of 800, height of 533 with 650 and 432 respectively. The entire database updates when this SQL statement runs. As a precaution consider making another copy of the table to test the SQL statement first.

Foxhall to the Nacton River Orwell Shoreline Circular Walk

On The Front Line, River Bank, Sport, Suffolk, Walking Hiking Navigating No Responses »

Dec 262011

12.9° C by mid morning, if it wasn’t for bare trees it would be difficult to distinguish from an early summer morning. This walk took me from Foxhall to Nacton, directly past my sons old School Orwell Park and to the river bank shoreline in Nacton, a popular place with walkers, runners and twitchers. Nacton shoreline is the River Orwellian equivalent of Piccadilly Circus on bank holidays, not even the mud was keeping people from enjoying the mild weather.

More photos

If you don’t like walking in mud then avoid this walk when wet. Even dry hot sunny days there will be muddy areas around the creeks and streams. Avoid the mud by walking on the high ground. My advice would be if you see the deep holes created by cattle full of water then turn back and use the road for that part of the walk.

Alternatively if you are the kind of person who takes string with you on a walk you will find plenty of old wood to strap to your boots to over the tough parts.

Distance: 12 Miles
Elevation Range: 0 to 120 feet
Weather Check: Bucklesham, Suffolk
Map: Click here and once loaded select “Leisure” map
Route Card: Foxhall to the Nacton River Orwell Shoreline Circular Walk
Download the Walkers Route Card Template for Word 2010

Perihelion: The northern hemisphere is closer to the sun in winter

On The Front Line, Travel, Walking Hiking Navigating No Responses »

Dec 232011

winter solstice pivato Perihelion: The northern hemisphere is closer to the sun in winter

Winter Solstice Northern Hemisphere

In the early 70′s I went to Belmont School near Abinger Hammer, Surrey. Major Irwin took us for history, geography and for those of us with parents abroad took us orienteering on weekends while others went home. On one trip he explained Earth was closer to the sun during the winter solstice for the northern hemisphere.

Over the years I lost the detail in his explanation (that lesson took place more than 40 years ago) and each time we reach the winter solstice I berate myself for not looking up the facts and reacquainting myself with the magical story of how nature balances life with seasons.

Today, Tristan Gooley posted The Cloud Compass on his blog which includes a brief explanation of Perihelion (the closest point) and Aphelion (the furthest point). These words triggered the missing details from Major Irwin’s explanation so now I have something to search for in Wikipedia.

Major Irwin did not go in to detail, I was 10, but I do remember on a freezing cold morning doubting we could actually be closer to the sun than in summer. The following abridged text from Wikipedia explains Apsis.

An apsis, plural apsides, is the point of greatest or least distance of a body from one of the foci of its elliptical orbit. In modern celestial mechanics this focus is also the center of attraction, which is usually the center of mass of the system. Historically, in geocentric systems, apsides were measured from the center of the Earth.

The point of closest approach (the point at which two bodies are the closest) is called the periapsis or pericentre, peri, around, and kentron. The point of farthest excursion is called the apoapsis, apocentre or apapsis (the latter term, although etymologically more correct, is much less used). A straight line drawn through the periapsis and apoapsis is the line of apsides. This is the major axis of the ellipse, the line through the longest part of the ellipse.

How to batch render and stretch in Sony Vegas 11 Pro

On The Front Line, Sony, Sony Vegas Scripting, Vegas Pro, Video, Video Editing, Visual Studio No Responses »

Dec 212011

batch render 300x195 How to batch render and stretch in Sony Vegas 11 Pro

Selecting batch render in Sony Vegas Pro

If you have prepared regions in a video which you wish to output as individual files Sony Vegas Pro has a simple script called “Batch Render” that will do the dirty work for you. However it won’t stretch to fill video for you and if this is a requirement then you need to change the script.

Research reveals Vegas Pro versions before 9 would handle stretching to avoid letterboxing too. However the default installation no longer does. This is how you do it:-

Locate the script directory (usually C:\Program Files\Sony\Vegas Pro 11.0\Script Menu)
Make a copy of “Batch Render.cs” and call it “Batch Render Stretch.cs”
Open the new file in a text editor and find the two lines that begin “args.OutputFile =”. You will find them around line 97 and 106.
Create a new line below them and add “args.StretchToFill = true;” (without the quotes (see below)
Save your changes, refresh the script listing in Vegas and use the new script to render files as before but use this new script instead

After your changes the code should look something like this:-

if (RenderMode.Regions == renderMode) {
	int regionIndex = 0;
	foreach (Sony.Vegas.Region region in myVegas.Project.Regions) {
		String regionFilename = String.Format("{0}[{1}]{2}",
				filename,
				regionIndex.ToString(),
				renderItem.Extension);
		RenderArgs args = new RenderArgs();
		args.OutputFile = regionFilename;
		args.StretchToFill = true;  // <------------ Add this line
		args.RenderTemplate = renderItem.Template;
		args.Start = region.Position;
		args.Length = region.Length;
		renders.Add(args);
		regionIndex++;
	}
} else {
	filename += renderItem.Extension;
	RenderArgs args = new RenderArgs();
	args.OutputFile = filename;
	args.StretchToFill = true;  // <------------ Add this line
	args.RenderTemplate = renderItem.Template;
	args.UseSelection = (renderMode == RenderMode.Selection);
	renders.Add(args);
}

If programming’s not your thing you can download a copy of the script ready-made by clicking here.

If you’re interested in programming Vegas this is a good starter video:

A hike from Brookhill Woods Foxhall to the Maybush Pub Waldringfield, Suffolk

On The Front Line, River Bank, Suffolk, Walking Hiking Navigating No Responses »

Dec 112011

The weather report said ice so I decided to start my walk from my front door. Fortunately I live in the suburbs and less than two minutes away from a Footpath sign. I have walked this path many times but because of its location, beside the largest municipal tip in Europe, I’ve not been encouraged to do more than a couple of miles.

SDC12767a 300x225 A hike from Brookhill Woods Foxhall to the Maybush Pub Waldringfield, Suffolk

Saltmarsh on The Deben

Today I decided to walk past the tip, cross the dual carriageway, and beyond. All the way to Waldringfield where I would stop for lunch and then back along part of the Deben I have not yet walked.

That was the plan and it all worked up to the pub. A couple of miles down the river from the pub a signed warned that anyone continuing on the path would have to return the way they came because land erosion had claimed the path.

As I walked along the small country lanes around the lost river-paths I considered why the paths have suffered from erosion. The Deben moves fast and shifts a lot of sand at its mouth but inland its muddy and tidal. By the time the tide reaches Waldringfield there is little energy and the river flow itself is not fast. It is natural for a river to change course as it seeks the shortest route to sea but as it changes can we not walk around it? Perhaps that’s Naïve.

Suffolk Coast and Heaths are restoring the saltmarsh which will reduce energy from waves and help protect the remaining paths.

Distance: 12 Miles
Elevation Range: 0 to 120 feet
Weather Check: Bucklesham, Suffolk
Map: Click here and once loaded select “Leisure” map
Route Card: Brookhill Woods Foxhall to the Maybush Pub Waldringfield
Download the Walkers Route Card Template for Word 2010

Bromeswell to Gobblecock Cottage a Circular Walk Through Rendlesham Forest

Forest, On The Front Line, Sport, Suffolk, Walking Hiking Navigating No Responses »

Dec 042011

I didn’t see a UFO, or indeed the lighthouse beams from Orford Ness lighthouse, and the only attraction in the forest is Gobblecock Cottage.

gobblecock hall Bromeswell to Gobblecock Cottage a Circular Walk Through Rendlesham Forest

Beyond the name Gobblecock there is little of interest (the cottage owners have chosen not to display the name, but the hall next door fortunately obliges should you be using it for a waypoint).

I would have liked to add this post to the Ancient Woodlands category but the area I walked was plantation all, but for a few scraps along the way. In woodland terms there is little to learn except for any natural event that collides with unnatural which in my case was to step aside to let a Land Rover Discovery pass.

A few vehicles were collecting north of the airfield where preparations for a motorcycle rally had begun. As this is a plantation I whole-heartedly approve and see no reason they do not open the entire forest to free vehicle access. Nothing within its boundaries bares any resemblance to ancient Britain and is a haven for non-indigenous creatures that have already replaced what was once here. Not a red squirrel to be seen. Why preserve something meaningless?

Dog walkers fill this forest, along with dog-shit, which is more damaging than motorbike and off-road vehicle tracks which at least do more to cut disease than spread it.

Other parts of this public area are reserved for activities such as shooting and archery. As these are not fenced off a different set of warning signs are used to scare off would be passers-by, although the chance of being hit by a bullet or arrow are enough to keep me away and I think they should allow them to be fenced.

“Smart Water” is used to protect against theft but theft of what? Wood? Surely hunters and archers take their kills and targets home with them? A Smart Water sign only proves there must be something worth nicking then, and I think I would admire any thief who tries to strip a hunter of his gun!

On one public footpath a “Members Only” sign is displayed but members of what is not clear. I suspect it’s an old sign as following through the path revealed nothing but a path through woods.

I detect an air of greed in plantations. Yes we need wood for practically everything we do (the chair and desk I use to write this for example), but do we need “KEEP OUT” signs, barbed wire and electric fences to protect them? These are tools used to define ownership and a desire for exclusive use. Without these delineations few would venture onto the land anyway, the plantation having destroyed the lands value for ordinary people already.

Distance: 14 Miles
Elevation Range: 3 to 100 feet
Weather Check: Rendlesham, Suffolk
Map: Click here and once loaded select “Leisure” map
Route Card: Bromeswell to Gobblecock Cottage a Circular Walk in Rendlesham Forest
Download the Walkers Route Card Template for Word 2010

How to disable the annoying audio warning to clear cache

Annoyances, Google Software, Google Toolbar, Software, Utilities 2 Responses »

Nov 292011

1951881 blog 300x219 How to disable the annoying audio warning to clear cache Do you keep hearing a voice message warning you to clear your cache and cookies? I don’t, but my father experiences it and when he described it I could not believe it. Why would such a pointless and stupid message be played every time you opened the browser?

At first I thought it was something wrong with Internet Explorer but removing the Google Toolbar solves the problem. Further investigation results in problem with Google’s data gathering process (surprise surprise).

If you wish to keep the Google Toolbar this is what you need to do:-

1. Click the Toolbar’s wrench OR the dropdown arrow beside the search .
2. Click Manage.
3. Click Privacy.
4. Then select Turn off features that send information

However this has not worked for everyone – with some claiming they disable it and it automatically enables itself again later.

On the subject of People have said….

Some think this is a ploy by Microsoft to stop people using or supplying information to Google. No one has suggested that it might be Google trying to get people to switch from IE to Chrome which is a more likely result (Google Toolbar does not work in Chrome!).

I think it is more likely a programming error and the issue, apart from being extremely annoying, Google are taking so long to fix it.

As for whether this is a Microsoft or Google problem IMO it is Google at fault, if they want to offer their Toolbar on IE then its up to them to get it to work properly.

Roudham Heath to Thorpe Woodlands Circular Walk

Norfolk, On The Front Line, River Bank, Sport, Suffolk, Walking Hiking Navigating No Responses »

Nov 272011

Ironically to reach the unbeaten track you sometimes need to get close to fast roads. Last week crossing the M25 and Mll over bridges and through tunnels ensured my path was a lonely one. This week the A11 through Bridgham Heath provided a barrier between occasional walkers and ardent hiker. A little patience is needed to get across safely.

The footpath also crosses the railway at Roudham Heath (Or Anfield Road, L4 Liverpool, according to a sign beside the Union Jack). I took extra care after reading a tragic report of yet more life lost. Fortunately there is a good view in both directions so felt little danger as I walked across.

There was some confusion after crossing the bridge at Thorpe Woodlands into Suffolk. I met some people trying to find their way back to their camp site. A sign warning them away from the land between them and the site meant they were going to have to return the way they came. They saw I had a map and asked if it was possible to compare and find out where they had gone wrong. Their map was part of a brochure but did seem clear enough for the walk they were taking.

The land is (at least in part) a nature reserve and access land. This I confirmed with my OS map and I offered to guide them to the footpath back to their campsite as I was going in the same direction. They showed me the sign and I think it might be incorrectly placed. Its grid reference is TL 945 841 beside the stand of trees and after the track.

As the entire area is free access anyone with an OS map can easily negotiate around the area the sign protects however a good path with footpath posts appears just after the sign. If the sign was moved about 5 metres people using the nature reserve map would not have to worry where they walk. Alternatively OS and the nature reserve should adjust their maps accordingly.

View Larger Map Get Directions View Bird's Eye

Distance: 12 Miles
Elevation Range: 45 to 140 feet
Weather Check: Thetford, Norfolk
Map: Click here and once loaded select “Leisure” map
Route Card: Roudham Heath to Thorpe Woodlands Circular Walk
Download the Walkers Route Card Template for Word 2010

Epping Forest Circular Walk Via Toot Hill & The Moletrap

Essex, Forest, On The Front Line, Walking Hiking Navigating 1 Response »

Nov 202011

I didn’t take my Camera on this walk so these are from my phone. Not Pulitzer material but it was a bright day, bright enough to produce good pictures under the circumstances.

I have wanted to visit Epping for a while and the chance arose without warning or time for proper planning. I want to walk the tunnels and bridges across the M25/M11 motorways. I decided to leave them to the end of the walk knowing it would be dark by the time I arrived. This may seem foolhardy however there are two attractions to the dark. The first is the tunnels will be creepy and secondly the land around motorways offers interesting navigation. If the dark freaks you out and you are considering this walk in the winter then I suggest you do the walk in reverse, and bring torches.

The sun is winter-low but bright enough to keep the air warm enough for me to walk wearing a T-Shirt and shorts (changing to longs before walking through brambles – and for decency’s sake before Lunch in the Moletrap pub).

Distance: 12½ Miles
Elevation Range: 85 to 365 feet
Weather Check: Epping, Essex
Map: Click here and once loaded select “Leisure” map
Route Card: Epping Forest Circular Walk Via Toot Hill & The Moletrap
Download the Walkers Route Card Template for Word 2010

Circular Walk of Culver Down on the Isle of Wight

Coastal Walks, Isle of Wight, On The Front Line, Sport, Walking Hiking Navigating No Responses »

Nov 172011

A hot sunny day in mid November, a reminder we are closer to the sun in winter and the low angle of the sun the only clue it’s not summer, made this an extraordinary walk.

Trees and plants not fooled continue preparations for cold weather yet gleam in momentary stasis. A red squirrel sat on a bench in the woods eating, carefully I backed away to avoid disturbing it planning to take a photo but alas the boot-up on my camera produces an unnatural *ping* and in the same second the squirrel disappeared.

A short two-hour walk. It begins from the public car park at the top of Culver Down and ends in the Pub next door.

Take care on paths in Whitecliff Bay where land erosion has left them damaged or missing. In one place car tracks fall over the edge but careful examination from a safe position proved these were old and unlikely recent misfortune.

Distance: 5¼ Miles
Elevation Range: 10 to 322 feet
Weather Check: Bembridge, Isle of Wight.
Map: Click here and once loaded select “Leisure” map
Route Card: A Circular Walk of Culver Down on the Isle of Wight
Download the Walkers Route Card Template for Word 2010

Older Entries Newer Entries