I recently got a new host and I copied the files to the new host. Then I imported the data from the database. However, YAF now asks me to upgrade the database. (no clue why) However, my last host was MSSQL 2005 and this one is MSSQL 2008. It refuses to upgrade me (some tables conflict) and when I rename the tables and "upgrade" everything works great until I go to post a new topic or post. My forum is now readonly. Any suggestions?

Cannot insert the value NULL into column 'MessageID', table 'ftlc_.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated.