Attempting to upgrade from 2.65 to 2.70 SQL Syntax Errors.

Hi All,

I'm trying to upgrade my 2.65 version to 2.70, I've backed up the database, saved my settings.txt and installedplugins.txt, also backed up my custom theme.

I am trying to run the SQL upgrade script and I get:

Error: Incorrect syntax near ''.
SQLState:  42000
ErrorCode: 102

Curiously that is two single quotes in the xml declaration at the beginning of the script.

I am using MSSQL 2012 and have tried this with Squirrel SQL and HeidiSQL clients, but report the same error.

I searched the forums and didn't find anything relevent. Any ideas?

Thanks.

Graham

There should not be "two single quotes at beginning...."
It should look like:

--upgrade scripts from nopCommerce 2.65 to nopCommerce 2.70

--new locale resources
declare @resources xml
--a resource will be delete if its value is empty
set @resources='
<Language>
  <LocaleResource Name="GiftCardAttribute.For">
    <Value></Value>
  </LocaleResource>
...