When Software Attacks!

Workflow and SQL Error: Update

I posted last week about a couple of issues we were experiencing with SharePoint. I made some traction on the Workflow History issue at the end of last week and the revelation was pretty far-reaching, so I’m posting again. It turns out that the stuff I said about systemupdate was wrong… up to a point. There is a bug with systemupdate and triggering events, but it’s not the one we thought it was!

Posted by Rik Hepworth on Monday, July 14, 2008

Useful .Net Search and Replace tool

I need to update something like 300 web.config files today, with the same change in each. I turned to my old friend Google for his recommendations and up popped a magnificent free tool from Nodesoft. Why magnificent? It’s advanced mode allows you to specify start and end tags and update everything in between. That’s fantastic for dealing with big chunks of web.config files! Better yet, give it a file mask and a path and it will run through the entire folder tree if you like.

Posted by Rik Hepworth on Saturday, July 5, 2008

Problems with Site Policies and FBA in SharePoint 2007

If you are using Forms Based Authentication and try to access Site Policies you may well find that you get an Access Denied response. If you do, this post will help you! I’ve been meaning to post this for a while because I’m sure it may help somebody. As usual, it’s been pushed back and back until now I finally have some time. I also have another, workflow-related post on another problem which will follow shortly.

Posted by Rik Hepworth on Thursday, July 3, 2008

Workflow History and SQL Error

When trying to view an item in a list which has workflows run against it, you get an error: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries Problem Background Trying to explain the exact nature of our configuration in this case would break many people’s heads. This, therefore, is a bit of a simplification. We have a custom webpart which allows users to log an enquiry.

Posted by Rik Hepworth on Thursday, July 3, 2008

A great article on handy SharePoint controls

I don’t know about you, but I always mean to gather various bits of knowledge into one place, but just like tidying my filing at home, I never quite get around to it. Fortunately for me, Chris O’Brien is a bit more organised and in my ever expanding blogroll today I saw a great article about really useful SharePoint controls to use in custom pages for that handy bit of functionality.

Posted by Rik Hepworth on Monday, March 17, 2008