I’ve been really busy climbing. So whats been happening, did I just sum it up in 1 sentence?
Yes I think I did, been climbing loads, Fairhead was awesome with some very interesting company… Really good climbing for 2 days should really have climbed on the 3rd day as well but hey ho… Other things to note that Pex Hill is the new Brownstones!!! Or rather Pex Hill is really good, although we’ve known this for a little time… New traverses at Brownstones have been keeping me busy as well though…
Not alot else really just been doing the normal crag hopping that happens during summer… However I have this to note, with relation to two spots I’ve recently visited namely being Hobson Moor and Witches… I know this is going to end up being, well they can choose what they do etc… But I have to say I am slightly concerned at the continuing trend towards top roping and general “wall” behaviour at crags…
For example at Witches I saw someone belaying about 10 metres away from the wall, they obviously do not know that this would rip nearly all the gear because of the different force that is being placed on it… Solution?
Hobson Moor just seemed to be a top rope feast, however, I kinda understand the reasons for this. Although the erosion at the top of the crag should always be considered otherwise the issues at Anglezark might arise at other quarries too!!!
Anyhow, thats about it, will post the links to some pictures when I’ve uploaded them…
Well not really the whole summary, but hey just some pics… Well in fact only these mmm 4 pics… Will write a full report once I’ve slept… Oh and more pictures as soon as myspace decide to let me upload anymore… Wow look I even posted “Devon” not “Cornwall” am such a dumbass…
Well this is strange, I’ve just been looking at the stats for this very website, and I kinda guessed that quite a few people would be from the UK, so amazingly 76% of the share is UK visitors… However, I kinda thought that US might be the second, but hold on, nope Poland by 6% – 13% of the visitors share… This is so geeky I know but waiting for CRM 3.0 to configure on the Server and thought I would have a look at the stats… So anyhow, thats it, just wondering thats all!!!
Oh yes CRM configuration am going to put this here as well if you are upgrading from 1.2 to 3.0 and get the following error: “The foreign key constraints in the CRM database are not consistent with CRM 1.2 foreign key constraints.”
Do the following: 1, Look at the CRMV3setup.log found in “C:Documents and SettingsApplication DataMicrosoftMSCRMLogs” 2, Example of the error logging is: 23:14:25| Info| The following foreign key constraint(s) are not consistent with Microsoft CRM 1.2 foreign key constraints: 23:14:25| Error| remark: deleted foreign key 23:14:25| Error| tablename: leadaddressbase 23:14:25| Error| columnname: parentid 23:14:25| Error| referencedtablename: leadbase 23:14:25| Error| referencedcolumnname: leadid 23:14:25| Error| foreignkeyname: lead_addresses 3, Now I had a different error, so I reinstalled CRM 1.2 on a test machine and then checked the databases like this. Through the GUI, it is usually in the tablename: that the problem is. 4, Alternatively you can run/modify this (I didn’t have much joy doing this such is why I suggest reinstalling 1.2 on a different machine. 4, a, First drop the constraint on the table. 4, b, Then:
ALTER TABLE [dbo].[LeadAddressBase] ADD CONSTRAINT [PK_LeadAddressBase] PRIMARY KEY NONCLUSTERED ( [LeadAddressId] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[LeadAddressBase] ADD CONSTRAINT [lead_addresses] FOREIGN KEY ( [ParentId] ) REFERENCES [dbo].[LeadBase] ( [LeadId] ) NOT FOR REPLICATION GO
Well I wanted to post some pictures of climbing on Saturday, and potentially me with the medal on Sunday but alas I can’t upload photos to my blog currently. This is rather annoying, and well this is with Google, so sort it please Google…
I’ll just surmise, we (Will and me/I (for all you grammar freaks)) had a good day on Saturday at Robin Proctor Scar (formerly known as Norber Scar). We did 6 routes with the sun actually appearing for selected moments of the day, but in the end the wind prevailed and we were too cold to carry on climbing… Alas it was a nice way to carry on introducing myself back to the World of real rock!!!
Then on Sunday we went out for a nice orienteer around White Coppice, the competition was laid down, although it ended up not being very competitive. I still beat you Johnboy, Will and Vicky. Someone moved the first marker so I spent 10 mins looking for it, decided it disappeared and carried on… Yes I did run some of it/most of it, and yes did go over on my ankle because of it, but still ended up winning.
Thanx to Pete and Jenny for organising it, was good fun to have a run about after some flags… I will post some pictures soon, or decide whether to put them on another site and link this to there…
Somewhere 1 day I was convinced there was an Ashcroft thing that I did after the gig, alas its not here now, about why I enjoyed his music etc soo much… Found the gig review, wow, I thought there had been 2 posts in a month about him… Erm, I really want to know where it went though, I’m convinced it was on here for a couple of days now its vanished…
There will be an ice climbing report coming soon, probably tomorrow since I’m gonna try and finish the first series of 24 tonight…
Oh yes, remember “Life is just a ride” – Hicks (why this fascination?)… If you know then, you wouldn’t ask, but on the 26th you’ll find out…
