All my settings are gone!

Posted: May 14, 2018 at 3:22 PM Quote #204296
I accidentally ran the Install script on an existing store database. It created a new store. I deleted the store in Admin. All of my settings are now gone (orders, catalog, etc. are fine). I looked at the DB and the Id for the (original) store is 1, but the Setting table shows storeId of 0. That looks wrong, but I believe that's what it looks like in a working store. Is there some mapping between a store and settings that I'm missing? I cleared the cache and restarted the application (twice), but that didn't do it. Thanks for any help!!
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: May 14, 2018 at 7:07 PM Quote #204299
Is there no way to mark a post as "resolved" or even for the author to delete it? Anyway, I now see that a storeId of 0 in the Setting table means "All Stores". What seems to have happened is that the Install process overwrote the settings with default values. This wasn't my production DB, so no worries.
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: May 16, 2018 at 7:14 AM Quote #204374
To prevent loss of data in future, you should make use of backup feature in nopcommerce and back up your database time to time.

See - Administration > System > Maintenance

Database backups
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)
A2Hosting Liaison
Posted: May 16, 2018 at 3:43 PM Quote #204411
A2Hosting_Liaison wrote:
To prevent loss of data in future, you should make use of backup feature in nopcommerce and back up your database time to time.

See - Administration > System > Maintenance

Database backups


That is EXCELLENT advice! My app is hosted on Azure, which has "db restore to point in time" capability, so that's exactly what I did to recover from this problem. Thanks for replying!
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: May 29, 2018 at 6:56 AM Quote #204977
RonSul wrote:
To prevent loss of data in future, you should make use of backup feature in nopcommerce and back up your database time to time.

See - Administration > System > Maintenance

Database backups


That is EXCELLENT advice! My app is hosted on Azure, which has "db restore to point in time" capability, so that's exactly what I did to recover from this problem. Thanks for replying!


You are welcome!
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)
A2Hosting Liaison
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 2018
Learn more