Even better than good error messages is a careful design which prevents a problem from occuring in the first place. Either eliminate error-prone conditions or check for them and present users with a confirmation option before they commit to the action.
Computer Science Field Guide:
9. Help Users with Errors)