ok, got the product pictures back. Looks like this was a cascading failure. Once the initial picture records failed all subsequent record moves failed to copy. I manually copied these records over from a restored copy of the original 1.9 database.
normally I've see this when a subquery is failing due to some issue that is a permanent failure. If you understand the scripting then you can usually isolate it but you need to be able to isolate the issue in the script itself.
Try commenting out the inserts and just leave the select statements so you can see what the results are that it is returning.
comment "--" at the beginning of the line for each "insert" line
I am trying to upgrade from v1.9 to v2.2, everything went fine until I got to 2.2 and ran it, at the install I got this error:
•Setup failed: System.InvalidOperationException: Sequence contains more than one element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source) at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable`1 sequence) at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot) at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.Single[TSource](IQueryable`1 source) at Nop.Services.Installation.InstallationService.InstallSettings() in C:\Users\Tesh\Downloads\nopCommerce_2.20_Source\Libraries\Nop.Services\Installation\InstallationService.cs:line 4510 at Nop.Services.Installation.InstallationService.InstallData(String defaultUserEmail, String defaultUserPassword, Boolean installSampleData) in C:\Users\Tesh\Downloads\nopCommerce_2.20_Source\Libraries\Nop.Services\Installation\InstallationService.cs:line 9233 at Nop.Web.Controllers.InstallController.Index(InstallModel model) in C:\Users\Tesh\Downloads\nopCommerce_2.20_Source\Presentation\Nop.Web\Controllers\InstallController.cs:line 435