Warning appears when downloading order

[henryp]

When downloading an order for a particular item from our online store a warning appears as shown below.

We are able to continue and action the order but does anybody know how to correct the warning and why is it happening?


WARNING!

There was a problem with the database

Operation: Executing the query 'UPDATE [orderdetail] SET sReportKey = 'Children''s Party Bag(Type Ordered - Product ID: 3010: Children'c825064526af12de74a5c3d6b9b8a45e' WHERE [nComponentParentID] = 2821 OR [OrderDetailID] = 2821'

Database name: C:\Program Files\Actinic ecommerce v5\Sites\Site1\ActinicCatalo

Syntax error (missing operator) in query expression ''Children''s Party Bag(Type Ordered - Product ID: 3010: Children'c825064526af12de74a5c3d6b9b8a45e' WHERE [nComponentParentID] = 2821 OR [OrderDetailID] = 2821'.

Action: Contact Technical support

*************************************************

[cdicken]

The string it seems to have a problem with is

Children''s Party Bag

Are those two apostrophes in your product description? If so, maybe these are causing the error. Try correcting these and placing a test order.

[Jan]

Are those two apostrophes

It's not two apostrophes, it is a double quote, it needs to be replaced in the string with a single quote.

Regards,

[henryp]

Thanks a bunch to cdicken and jan.

Removing the apostrophe in the product(')s description has cured the problem.

So can we not use apostrophes like this?

Many Thanks

[cdicken]

Did you have two apostrophes in the short description or just 1? Just having one should be OK.

[henryp]

Hi Chris

We only had 1 apostrophe in the description not 2 (eg Childern's Party Bag). I removed it and got rid of the error.

You can the description at http://www.papertrace.co.uk an click on Page 12.

Many Thanks.

[Jan]

Chris,

This is a bug in the code that builds the report key as the orders are downloaded, the apostrophe is doubled up in the first part (which is correct) but there is also a bit of code that builds the unique id from the name and the description (that bit is encoded so it is the numbers bit), the apostrophe is not doubled up there and it should be -

Children'c825064526af12de74a5c3d6b9b8a45e'
*

access thinks the string ends at that point and so rejects the statement as invalid SQL.

Cheers,