It was more comical than even that... Only the YES vote was considered valid. Subsequent attempts to revoke it were ignored... On the other hand, initial NO votes were allowed to be overturned.
Of course, you're bound to receive a blog or two on the will of the "American People" as though such an aggregate entity ever existed (prior to the war).
Of course such an entity never existed - James Madison clarified the issue to Mason in the Virginia ratification debates. In the federal debates the delegates refused to even second a motion to submit ratification to the people of the states en masse. Madison also stated in the Federalist Papers that each state would only be bound by it's own voluntary act.