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

Posted: June 10, 2011 at 4:21 PM Quote #41405
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 10, 2011 at 5:45 PM Quote #41408
Does the table exist in the database? That would throw that message.

Andrew SQLDBA
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 10, 2011 at 11:35 PM Quote #41415
No but doesn't exist in a clean install on a site that works either.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 11, 2011 at 12:44 PM Quote #41424
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more