Order Step SQL problem

[GoogleCodeExporter]

eCommerce version affected: 1.0 r3103
SilverStripe version: 2.4.7
Browser/Operating System used:13.0.1

What steps will reproduce the problem?
1. CMS
2. Shop Tab
3. Search for: Order Step
4. Click in search button

See screenshot

Result:

Error: "Couldn't run query: SELECT "OrderStep"."ClassName", 
"OrderStep"."Created", "OrderStep"."LastEdited", "OrderStep"."Name", 
"OrderStep"."Code", "OrderStep"."Description", "OrderStep"."EmailSubject", 
"OrderStep"."CustomerMessage", "OrderStep"."CustomerCanEdit", 
"OrderStep"."CustomerCanCancel", "OrderStep"."CustomerCanPay", 
"OrderStep"."ShowAsUncompletedOrder", "OrderStep"."ShowAsInProcessOrder", 
"OrderStep"."ShowAsCompletedOrder", "OrderStep"."HideStepFromCustomer", 
"OrderStep"."Sort", "OrderStep_Submitted"."SaveOrderAsHTML", 
"OrderStep_Submitted"."SaveOrderAsSerializedObject", 
"OrderStep_Submitted"."SaveOrderAsJSON", 
"OrderStep_SentInvoice"."SendInvoiceToCustomer", 
"OrderStep_SentReceipt"."SendReceiptToCustomer", 
"OrderStep_Sent"."SendDetailsToCustomer", 
"ElectronicDelivery_OrderStep"."NumberOfHoursBeforeDownloadGetsDeleted", 
"ElectronicDelivery_OrderStep"."AdditionalFile1ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile2ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile3ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile4ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile5ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile6ID", 
"ElectronicDelivery_OrderStep"."AdditionalFile7ID", "OrderStep"."ID", CASE WHEN 
"OrderStep"."ClassName" IS NOT NULL THEN "OrderStep"."ClassName" ELSE 
'OrderStep' END AS "RecordClassName" FROM "OrderStep" LEFT JOIN 
"OrderStep_Submitted" ON "OrderStep_Submitted"."ID" = "OrderStep"."ID" LEFT 
JOIN "OrderStep_SentInvoice" ON "OrderStep_SentInvoice"."ID" = "OrderStep"."ID" 
LEFT JOIN "OrderStep_SentReceipt" ON "OrderStep_SentReceipt"."ID" = 
"OrderStep"."ID" LEFT JOIN "OrderStep_Sent" ON "OrderStep_Sent"."ID" = 
"OrderStep"."ID" LEFT JOIN "ElectronicDelivery_OrderStep" ON 
"ElectronicDelivery_OrderStep"."ID" = "OrderStep"."ID" WHERE ("Sort" > ) ORDER 
BY "Sort" ASC LIMIT 1 You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to use near 
') ORDER BY "Sort" ASC LIMIT 1' at line 1" at line 525 of 
C:\wamp\www\sapphire\core\model\MySQLDatabase.php

Regards Nicolaas!

Jose

Original issue reported on code.google.com by supp...@sendasoft.com on 24 Jul 2012 at 12:05

Attachments:

• sc0066.png

[GoogleCodeExporter]

fixed, please try

Original comment by nfranc...@gmail.com on 24 Jul 2012 at 2:35

• Changed state: PeerReview
• Added labels: Milestone-Release1.0, Priority-Critical
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Now it works perfectly.
Thanks Nicolaas.

Regards,
Jose

Original comment by supp...@sendasoft.com on 25 Jul 2012 at 2:37

[GoogleCodeExporter]

Original comment by nfranc...@gmail.com on 26 Jul 2012 at 3:30

• Changed state: Fixed