Store Moved to New Host - Invalid object name 'dbo.Nop_Setting'

I've just moved a store to a new host, restored the database and set the connection string but cannot get the site to load. To ensure it was not the host I did a clean install of 1.90 using the Web PI and the site ran fine so I restored the database and once again got the "Invalid object name 'dbo.Nop_Setting'" exception.

Can anyone offer any advice on how to overcome this please?

TIA, Simon

Does the table exist in the database? That would throw that message.

Andrew SQLDBA

No but doesn't exist in a clean install on a site that works either.

Not sure what version that you are using. But that table is in my database. I am using 1.9  That table stores all the site configuration info.

Did you install that version locally? This is rather odd, but it sounds like you have two different versions trying to run.

Andrew SQLDBA