Sorry I skimmed through the first post quickly. To fix this problem there is no need to resource, just save this file to your bin folder and source this:
doorupdate-03-15-04.sql
By sourceing that you are adding two newly added door columns from March 15th, 2003. The new database by TC'sMyWorld should include that when it comes out, so this wont be needed much longer. Also if you followed that guide you mentioned it does mention that file.