Upgrade from 2.50 to 2.60 completed with errors problem.

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'.

Well the error is saying you don't have a single quote mark closing the xml string at the start of the script.

Looking at the 2.60 upgrade script that should be on line 861.

Looks like a bug in QueryExpress.  It works fine in SSMS.  I tried a few things and finally found a workaround.  Seems like it chokes when it see the words "Go to".  QueryExpress does not have a "Find" command, so edit the file in Notepad:

In file explorer, Right click the upgrade.sql file and click Edit. Notepad should open. Search for 'Go to cart' (without quotes).  Remove the spaces so that it looks like Gotocart.  Save the file.

Open QueryExpress and run the script.

Later when you are in nopC you can restore the text: go to Admin > Configuration > Languages > View string resources.  Filter the Value column (click the funnel) - Is Equal to:  Gotocart.  Click Filter.  Click Edit.  Change to 'Go to cart'. Click Update.


(Alternately, you can to try another tool.  I've used Toad before, but not this free version:
http://www.toadworld.com/Downloads/ToadforSQLServerFreeware/tabid/562/Default.aspx)