Language pack error on install SOLUTION

Several people are having problems when adding languages getting an error of

INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.

The solution for me (hosted on Godaddy not that I think it matters) was to edit the stored procedure of

Nop_languagePackImport

and change QUOTED_IDENTIFIER to ON

So....

You likely have access to your database through some sort of Web admin panel at your hosting provider.

The database that was setup for Nopcommerce has your tables, schemas, user defined functions, stored procedures, etc

The list of stored procedures is long so go down to nop_languagepackimport and open for editing.

The set quoted_identifier is close to the top.

Change it to ON

Save the file and exit out of the data base admin.

Cheers

YOU ARE DA MAN!!

This was killing me!! Now it works great!!!

THANK YOU!!!!!!!!!!!

SAIBR.com wrote:

Thanks.

I'm curious though.  Where are you hosted at?

I'd like to know if this is another Godaddy problem.

I left GoDaddy with this as a top reason, plus no path to 1.70 anytime soon. Arvixe had the same issue. If I had known about this earlier I may have stayed with them as I have had to download SQL 2008 onto my lapto to get Studio Express runnig in orde to edit the stored proc, Goaddy has a web base tool for this.. Now I am trying to determine the best way to upgrade to 1.70. Arvice wants to charge 160.00 USD to do it for me, ouch! It should be easy enough with the limited cusomizations that I have done so far. Because I was planning on going to 1.70 we were holding off on major customizations until we can complete the upgrade.

Daniel

Although the error is differant the solution is the same in nC 1.70

Error:
An error occurred while executing the command definition. See the inner exception for details.

Solution:
Same as above

Tangopdx nailed this one!

Eres mi ídolo.
Funciona perfectamente tu consejo.