Re: Object reference not set to an instance of an object.
Hmm, there seems to be a bug there but I'm very surprised it hasn't come up before. It did work on your local dev machine after all.
The bug is that the actual param in the stored proc is @DefaultFriendlyUrlPatternEnum not @DefaultFriendlyUrlPattern
I think if you rename it in the proc to @DefaultFriendlyUrlPattern that will fix it for you but you may need to clean out the data again.
Probably this bug only happens if you have <add key="CachePostgreSQLParameters" value="False" /> in your web.config. If its set to true then params are not declared by name, the are retrieved from the db so the name is always correct. Also should get better performance with it set to true.
So either set that to true or modify the proc to fix the name and it will probably fix things, though you may need to clean out the data again.
As a side note I should mention that we are planning to release version 2.1 which has a lot of new features this weekend. If you are still having issues by then with 2.0.1 maybe you will have better luck with the new version.
Hope it helps,