I installed nopCommerce 1.60 and added a new language, deleted the default (langaugeId=7).
When I tried to update to version 1.80, i received an error message.
Looking at the 1.80 updatescript (Install\Scripts\1.80\nopCommerce_upgrade.sql) I noticed that the script starts with a LanguageId setting
--new locale resources
declare @resources xml
set @resources='
<Language LanguageID="7">
So I figured that changing this would be sufficient, but it appeared that further on in the
script the languageId is used hard coded:
BEGIN
INSERT [dbo].[Nop_MessageTemplateLocalized] ([MessageTemplateID], [LanguageID], [BCCEmailAddresses], [Subject], [Body])
VALUES (@MessageTemplateID, 7, N'', N'New VAT number is submitted.', N'<p><a href="%Store.URL%">%Store.Name%</a> <br />
<br />
%Customer.FullName% (%Customer.Email%) has just submitted a new VAT number (%Customer.VatNumber%).
</p>')
END
This value must also be replaced with a valid LanguageId