1: The connection worked.
2: Upgrade from 2.40 to 2.50 completed.
3: Upgrade from 2.50 to 2.60 completed with Errors (shown below). What do I do now? Whew!
Then, I checked to see if the site was working and it was. Except when I click on a category. Then I get and error. "We're sorry, an internal error occurred that prevents the request to complete. Our supporting staff has been notified with this error and will address this issue shortly. We profusely apologize for the inconvenience and for any damage this may cause. You might want to try the same action at later time."
But, the most baffling part is: It says I'm on Version 2.65... But I only updated up to 2.60?????? and I double checked that. The upgrade was still up. --upgrade scripts from nopCommerce 2.50 to nopCommerce 2.60
The Error is below this;
Unclosed quotation mark after the character string '
<Language>
<LocaleResource Name="Admin.RecurringPayments.Fields.Customer">
<Value>Customer</Value>
</LocaleResource>
<LocaleResource Name="Admin.RecurringPayments.Fields.Customer.Hint">
<Value>Customer</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToCategories">
<Value>Assigned to categories</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToCategories.Hint">
<Value>A list of categories to which the discount is to be applied. You can assign this discount on a category details page.</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToCategories.NoRecords">
<Value>No categories selected</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToProductVariants">
<Value>Assigned to product variants</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToProductVariants.Hint">
<Value>A list of product variants to which the discount is to be applied. You can assign this discount on a product variant details page.</Value>
</LocaleResource>
<LocaleResource Name="Admin.Promotions.Discounts.Fields.AppliedToProductVariants.NoRecords">
<Value>No products selected</Value>
</LocaleResource>
<LocaleResource Name="Admin.System.Warnings.IncompatiblePlugin">
<Value>'{0}' plugin is incompatible with your nopCommerce version. Delete it or update to the latest version.</Value>
</LocaleResource>
<LocaleResource Name="Admin.ContentManagement.News.NewsItems.Fields.StartDate">
<Value>Start date</Value>
</LocaleResource>
<LocaleResource Name="Admin.ContentManagement.News.NewsItems.Fields.StartDate.Hint">
<Value>Set the news item start date or leave empty.</Value>
</LocaleResource>
<LocaleResource Name="Admin.ContentManagement.News.NewsItems.Fields.EndDate">
<Value>End ...
Incorrect syntax near '
<Language>
<LocaleResource Name="Admin.RecurringPayments.Fields.Customer">
<Value>Customer</Value>
</LocaleResource'.
Incorrect syntax near the keyword 'to'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Company'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Street'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Street'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Zip'.
An expression of non-boolean type specified in a context where a condition is expected, near 'City'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Phone'.
An expression of non-boolean type specified in a context where a condition is expected, near 'Fax'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near 'files'.
Incorrect syntax near 'cart'.
An expression of non-boolean type specified in a context where a condition is expected, near 'asterisk'.
Incorrect syntax near 'empty'.
Unclosed quotation mark after the character string ') AS R(nref)
--do it for each existing language
DECLARE @ExistingLanguageID int
DECLARE cur_existinglanguage CURSOR FOR
SELECT [ID]
FROM [Language]
OPEN cur_existinglanguage
FETCH NEXT FROM cur_existinglanguage INTO @ExistingLanguageID
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @ResourceName nvarchar(200)
DECLARE @ResourceValue nvarchar(MAX)
DECLARE cur_localeresource CURSOR FOR
SELECT ResourceName, ResourceValue
FROM #LocaleStringResourceTmp
OPEN cur_localeresource
FETCH NEXT FROM cur_localeresource INTO @ResourceName, @ResourceValue
WHILE @@FETCH_STATUS = 0
BEGIN
IF (EXISTS (SELECT 1 FROM [LocaleStringResource] WHERE LanguageID=@ExistingLanguageID AND ResourceName=@ResourceName))
BEGIN
UPDATE [LocaleStringResource]
SET [ResourceValue]=@ResourceValue
WHERE LanguageID=@ExistingLanguageID AND ResourceName=@ResourceName
END
ELSE
BEGIN
INSERT INTO [LocaleStringResource]
(
[LanguageId],
[ResourceName],
[ResourceValue]
)
VALUES
(
@ExistingLanguageID,
@ResourceName,
@ResourceValue
)
END
IF (@ResourceValue is null or @ResourceValue = ')
BEGIN
DELETE [LocaleStringResource]
WHERE LanguageID=@ExistingLanguageID AND ResourceName=@ResourceName
END
FETCH NEXT FROM cur_localeresource INTO @ResourceName, @ResourceValue
END
CLOSE cur_localeresource
DEALLOCATE cur_localeresource
--fetch next language identifier
FETCH NEXT FROM cur_existinglanguage INTO @ExistingLanguageID
END
CLOSE cur_existinglanguage
DEALLOCATE cur_existinglanguage
DROP TABLE #LocaleStringResourceTmp'.