Hello everyone,

I'm hoping someone may be able to assist me with a weird bug I've encountered with the Merchello when attempting to create a shipment. The error reads as follows:

"There was an error parsing the query. [ Token line number = 1,Token line offset = 518,Token in error = UPDATE ]"

I've pinpointed the exception to being thrown in the function SaveDetachedContents(IEnumerabel

I've pulled the sqlStatement to see what could be causing the issue and it reads as follows:

sqlStatement = " UPDATE [merchProductVariantDetachedContent] SET [merchProductVariantDetachedContent].[detachedContentTypeKey] = @0, [merchProductVariantDetachedContent].[templateId] = @1, [merchProductVariantDetachedContent].[slug] = @2, [merchProductVariantDetachedContent].[values] = @3, [merchProductVariantDetachedContent].[canBeRendered] = @4, [merchProductVariantDetachedContent].[updateDate] = @5 WHERE [merchProductVariantDetachedContent].[cultureName] = @6 AND [merchProductVariantDetachedContent].[productVariantKey] = @7 UPDATE [merchProductVariantDetachedContent] SET [merchProductVariantDetachedContent].[detachedContentTypeKey] = @8, [merchProductVariantDetachedContent].[templateId] = @9, [merchProductVariantDetachedContent].[slug] = @10, [merchProductVariantDetachedContent].[values] = @11, [merchProductVariantDetachedContent].[canBeRendered] = @12, [merchProductVariantDetachedContent].[updateDate] = @13 WHERE [merchProductVariantDetachedContent].[cultureName] = @14 AND [merchProductVariantDetachedContent].[productVariantKey] = @15"

Using the debugger I've removed the second update statement and executed the code with just everything up to @7 and the shipment gets created, but I'm assuming that it's not updating the inventory or something of the sort? I tried pulling merchello head of github and issue persists there.

Can anyone advise me on this one?

Note that I am using SQLCE for this case

Thanks!

Michael Griffith