|
Orphaned Users in SQLServer |
|
Software Development
|
By Dave Amphlett on
Thursday, October 22, 2009
|
|
|
|
I come across this problem about once a year, especially when backing up and restoring DNN databases to move between hosting companies. I always end up looking up the answer on google each time. So to help me find the answer quickly 12 months from now - here's how to fix Orphaned Users in SQLServer...
|
 |
|
Comments (0)
|
More...
|
|
|
Tweaks to Mitchel Sellers DotNetNuke Module Programming Part 1 |
|
|
By Dave Amphlett on
Fri, 22 May 2009 03:41:25 GMT
|
|
|
|
This is the first part of several posts in which I'm writing whilst working through Mitchel Sellers DotNetNuke Module Programming book.
First I'll sumarise my setup - I'm working on Windows XP Pro (SP2) on a Dell Latitude D420 (Intel U2500 @1.25GHz 1.49GB RAM). I'm running Visual Studio 2008 Version 9.0.21022.8 RTM, IIS 5.1 and the SQL Server 2005 express stuff that comes with Visual Studio 2008 (at least I think that's where I got it from - I forget now). Oh - and I'm a C# guy so I'm taking the C# branches of the book not the VB branches. Also I'm in the UK, so I guess there's a slight chance there may be regional differences to the book.
So I'll reiterate before I get stuck in, that so far I really like the style and content of the book. However I was disappointed to start to hit problems when working through it. Here are the details of the first problem I encountered and how to get past it...
& ...
|
|
|
|
Comments (0)
|
More...
|
|
|
Working through Mitchel Sellers DotNetNuke Module Programming |
|
Software Development
|
By Dave Amphlett on
Thursday, May 21, 2009
|
|
|
|
I've been doing DotNetNuke module development for several years now, but still find the experience messy, bitty, fragmented and generally dissatisfactory.
Coming from a professional software development background I don't feel comfortable unless a given project is in a state such that I can come back to it 6 months later and carry straight on working.
Every module development setup I've used for DNN has been different, and it seems to me that with each new DNN release, the previous setups break.
So I brought the Mitchel Sellers book in the hope of finding a satisfactory, repeatable process for creating and working with visual studio and a DNN module project.
Generally the book has exactly the style I was looking for. Detailed explanation with some high-level context without being patronising to a professional developer.
The first thing that annoyed me about the book was that ...
|
|
|
|
Comments (0)
|
More...
|
|
|
DNN Store Template tweaks for Firefox - part 1 |
|
|
By Dave Amphlett on
Thu, 27 Nov 2008 02:25:56 GMT
|
|
|
The standard install of the DNN Store Module (2.01.00) looks terrible on Firefox 3.0. I've been hacking away on the templates to try to get some improvement. I'm a CSS amateur so I'm not claiming this is a particularly great solution, but it does at least help the problems I was seeing. If anyone has any better ideas or links to better solutions I'd really appreciate it if you'd leave a comment saying so :)
Firstly DesktopModules\Store\Templates\ProductList.htm. Generally I prefer to use CSS for layout and positioning where possible, so I've simplified ProductList.htm significantly:
<div class="NewProduct-Entity">
<div class="NewProduct-Title">[MANUFACTURER]</div>
<div class="NewProduct-Title">[MODELNAME]</div>
<div class="N ...
|
|
|
|
Comments (0)
|
More...
|
|
|
DotNetNuke Store - MicroCart code |
|
|
By Dave Amphlett on
Thu, 13 Nov 2008 20:40:56 GMT
|
|
|
A quick blog for anyone playing with the DNN Store module code - here's a zip of a few files that I'm using for a MicroCart Module.
It's a really small simple little module that can show a tiny cart summary based upon a new template file: MicroCart.htm which can expand the following tokens:
- [CARTPRODUCTCOUNT]
- the number of different products in the cart
- [CARTITEMCOUNT]
- the total number of items in the cart
- [CARTTOTALCOST]
- the total cost (excluding tax) of all items in the cart
- [CARTTOTALTAX]
- the total tax cost of all items in the cart (simple calculation on the same basis as the VATPRICE token)
- [CARTTOTALCOSTINCTAX]
- the total tax cost of all items in the cart (simple calculation on the same basis ...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
|
|
Debugging and SMTP |
|
|
By Dave Amphlett on
Sun, 02 Nov 2008 03:55:26 GMT
|
|
|
Had wierd problems debugging the parts of the DNN store module that sends emails whilst accessing the internet from the Wifi at a hotel. In the end I think it could only be down to various SMTP ports being blocked.
I wasted a couple of hours trying to figure out where the problem was and finally gave up and downloaded DevNullSMTP - a java based 'dummy' SMTP server. It has a very simple gui and logs the emails it receives. It very quickly allowed me to establish that the code I was running was sending emails as I expected.
It could do with a few more features to be the perfect tool:
- Basic authentication - at least accept them - ideally show the uid & pwd used
- Decode base64 encoded messages to show the text real text of the email and subject
- Accept SSL connections
but at least I can see that emails are being sent.
DevNullSMTP can be downloaded at: & ...
|
|
|
|
Comments (0)
|
More...
|
|
|
Getting a DotNetNuke store working in an acceptable way, asap |
|
|
By Dave Amphlett on
Wed, 29 Oct 2008 05:59:10 GMT
|
|
|
|
I'm gob-smacked that the DNN Store module
has such fundamental bugs as sending customers order confirmation
emails that show their address as just being Afghanistan. How can
anyone ship that as a finished product?
So I decide to do something about it rather than sitting on my arse
and moaning, or shelling out good money for a 'commercial store' chosen
from what appears to be a pretty poor selection.
Download DNN 4.9.0 src and spend 3 train journeys (30 mins each) to get that working:
- Problem: no web.config file
A: copy development.config to web.config
- Problem: isn't using VS2008 internal webserver like it used to - don't know if this is something I've changed in VS or not.
A: establish it's using IIS - get that started
& ...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
Finally I'm back in the zone. |
|
|
By Dave Amphlett on
Sun, 12 Oct 2008 11:03:38 GMT
|
|
|
|
It must have been at least 6 months since I last felt properly 'in the zone' whilst coding. And it hadn't even conciously occured to me during that period. Read on.....
|
|
|
|
Comments (0)
|
More...
|
|
|
MXER tether sounds interesting |
|
|
By Dave Amphlett on
Tue, 23 Sep 2008 17:47:38 GMT
|
|
|
|
Recently happened across information about the proposed MXER tether system for boosting payloads from Low Earth Orbit to Geosynchronous Transfer Orbit and Geosynchronous Earth Orbit. I get most of how it's supposed to work except for it's own propellantless electrodynamic reboost. need to find out more about that...
|
|
|
|
Comments (0)
|
More...
|
|
|
Barcamp Brighton 3 This coming weekend |
|
|
By Dave Amphlett on
Mon, 01 Sep 2008 14:42:39 GMT
|
|
|
|
It's been 21 years since I was last at the SU bar at Brighton University and I fully intend to avoid Ruddles Bitter this time! No, it isn't a Physics Summer School reunion, it's the barcampbrighton3 unconference...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
|
|
Accepting the consequence of choice |
|
|
By Dave Amphlett on
Wed, 30 Apr 2008 04:36:05 GMT
|
|
|
|
Or how learning to enjoy my fathers driving helped me succeed in exams. This was prompted by Sean Dickinsons blog: Make a decision, then make it right (http://tinyurl.com/6l5k7l). Read more...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
|
|
|
|
|
|
|
Top 10% Folding@Home Contributor within 12 months |
|
|
By Dave Amphlett on
Wed, 06 Feb 2008 16:33:12 GMT
|
|
|
|
I started running Folding@Home on the 10th Feb 2007. I've been waiting for ages to become one of the top 10% of contributors, and today I managed it. Donor rank 88790 of 910319 => ranked in top 9.76% :) read on for more info...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
The dip is sinking in |
|
|
By Dave Amphlett on
Tue, 26 Jun 2007 10:21:42 GMT
|
|
|
|
I read (well listened to) "The Dip" recently, a book by Seth Godin. It's sinking in more and more every day. It's an interesting way to view an element of my life I've been uncomfortable with for some time. Read More...
|
|
|
|
Comments (0)
|
More...
|
|
|
Manipulate your Brain Chemistry using an electronic device - a remote control for your own Brain! |
|
|
By Dave Amphlett on
Wed, 28 Mar 2007 11:22:44 GMT
|
|
|
|
For the last few weeks I've been (not very scientifically) experimenting to determine if I can affect my own productivity using an electronic 'gismo' I brought. First let me say I'm not particularly good at 'context switching' - changing from one task to another. I work best if I've got a 1 or 2 hour block I can dedicate to a task. However recently I've been working on a Project that I have to fit in around the rest of my life. 50 min slots at lunch time, and 30 min slots on the train represent a significant portion of the time I have available for this project. So back to the experiment. I already had this piece of kit which I believed could mess with my brain chemistry and wanted to see if I could use it to help me get into the right frame of mind to focus on a coding task and get as much value out of a 30-50 minute block as possible. Well I've certainly proved to my own satisfaction that it works. Read more...
|
|
|
|
Comments (1)
|
More...
|
|
|
A personal appearance on YouTube |
|
|
By Dave Amphlett on
Sun, 25 Mar 2007 08:59:25 GMT
|
|
|
|
Very weird to accidentally come across video of me on YouTube. I remember chatting with these guys at PodcastConUk2006, but it seemed much more like at chat and much less like a mini interview at the time! At least you can't quite see how much I was overheating in that thick sweatshirt. see from about 02:25 onward: http://youtube.com/watch?v=p4bI0oQIxf8
|
|
|
|
Comments (0)
|
More...
|
|
|
You teach people how to treat you |
|
|
By Dave Amphlett on
Tue, 06 Mar 2007 14:00:00 GMT
|
|
|
|
I found this blog by Christine Kane very moving. It really hit home with me. It folds two things that I struggle with together into one strand. a) drawing a line and taking responsibility for how you allow others to treat you. b) Learn how to take risks.
http://christinekane.com/blog/2007/03/02/you-teach-people-how-to-treat-you/
|
|
|
|
Comments (0)
|
More...
|
|
|
Lunar Eclipse photos |
|
|
By Dave Amphlett on
Sun, 04 Mar 2007 21:43:05 GMT
|
|
|
|
I spent an hour stood outside the front of our house on Saturday Night photographing the lunar eclipse. I really enjoyed it but now find myself wishing I had a much higher power telescopic lense. This is something I could easily spend a fortune on, but in reality I'd hardly ever use. Anyway - fruits of my labour at http://www.flickr.com/photos/damphlett
|
|
|
|
Comments (0)
|
More...
|
|
|
How is Co-working different from teleworking centre's? |
|
|
By Dave Amphlett on
Wed, 28 Feb 2007 08:13:56 GMT
|
|
|
|
I'm guessing it's the same thing - just a new name for it. I remember teleworking centre's being the first sort of internet cafe's in rural areas. Personally I love working from home, but I've got a wife and kids around to keep it interesting, and a room dedicated to home working which enables me to keep it professional. However many people I chat to have issues working from home...
|
|
|
|
Comments (0)
|
More...
|
|
|
The pleasure of getting a new Notebook |
|
|
By Dave Amphlett on
Tue, 27 Feb 2007 09:55:06 GMT
|
|
|
|
It's been almost 2 years since I gave myself a "proper" technology treat, (basically since I listened to the T Harv Eker tapes). But a diet-coke + notebook incident gave me a need for a new techlust object of desire...
|
|
|
|
Comments (0)
|
More...
|
|
|
Morning or Evening person? |
|
|
By Dave Amphlett on
Thu, 22 Feb 2007 03:34:06 GMT
|
|
|
|
The sabbatical has ended and I'm back to working again... but I'm finding the switch to 5.30am starts and 10pm in bed to be rather difficult.
|
|
|
|
Comments (0)
|
More...
|
|
|
Discover Tenerife |
|
|
By Dave Amphlett on
Thu, 04 Jan 2007 06:00:00 GMT
|
|
|
|
I'm very proud that my parents have launched their first commercial website, Discover Tenerife. The best source of information about holidaying in Tenerife...
|
|
|
|
Comments (0)
|
More...
|
|
|
|
|