Help! I have installed and configured new version of nopCommerce. Tried to import old customers through SQL, suddenly deleted dbo.Customer.. What to d

Posted: July 17, 2017 at 5:47 PM Quote #190170
Hello.

I have installed nopCommerce 3.90. Imported all products and categories...

Then wanted to import customers from old site (3.5 version)...

Found an article about how to import through SQL Export & Import Wizard... Couldn't do it, because there was error.

Then suddenly I have deleted dbo.Customer I went to my VPS server opene MSSQL Studio, connected to the database...

Site doesn't work now... Please help me... What to do!???(((

Please, contact me by [email protected] or Skype id: zaf.su
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: July 17, 2017 at 9:05 PM Quote #190172
RE: "deleted dbo.Customer"
Where, in the 3.50 system, or the 3.90 system?

You cannot just Export/Import customers using SQL from older versions to 3.90...  The 3.90 Customer table structure has changed (there is a new/additional CustomerPassword table)
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)
www.noptools.com
Posted: July 18, 2017 at 2:08 AM Quote #190180
check your vps provider, if they have a backup daily or weekly. if yes, you are lucky.

good luck!
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)
https://www.nopGap.com   E-Commerce & ERP Matter
Posted: July 18, 2017 at 2:44 AM Quote #190182
New York wrote:
RE: "deleted dbo.Customer"
Where, in the 3.50 system, or the 3.90 system?

You cannot just Export/Import customers using SQL from older versions to 3.90...  The 3.90 Customer table structure has changed (there is a new/additional CustomerPassword table)


I have deleted dbo.Customer in new version, I didn't touch DB of the old site. Old site is alive and working now.

It is just new site (3.90) and there were just 3 customers and Admin.

How can I restore it? I don't have DB backup of new site.

Maybe I should create new site 3.90 and then export/import dbo.Customer? I am afraid to break smth else...(

If someone has some free time, please, let's talk by Skype, please help!)

Thanks.
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: July 18, 2017 at 4:33 AM Quote #190186
Hello Zaf,

Do one thing,

make your db backup of your old site and restore it in your development environment. then follow  

http://docs.nopcommerce.com/display/en/Upgrading+nopCommerce

I think it would be better if you upgrade your db from older version to newer version rather than then import/export customer table.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thanks & Kind Regards
Pratik Manek
SuperNop Solutions

Visit out Official site for Plugins or Customization,
PM me if you want to hire us, or you can visit us at
http://www.supernopcommerce.com/
Email:  [email protected]
Skype: supernopcommerce

Please +1 if this post help
Posted: July 18, 2017 at 5:05 AM Quote #190187
Now, the problem is how to make new site work again? How to restore or create a new dbo.Customer table??? Please, 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: July 18, 2017 at 8:47 PM Quote #190210
Are you sure the dbo.Customer table does not exist (vs. it's there but just has no rows)?  Because I'd think that the SQL Import wizard should not have been able delete the table due to the foreign keys (references from other tables).
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)
www.noptools.com
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.