Posted by JmsCrk on December 10, 2007 at 12:04am
When I visit the completed orders page at admin/store/transaction?workflow=6 I get the following messages:
* user warning: 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 ''6'' at line 1 query: SELECT COUNT(DISTINCT st.txnid) FROM ec_transaction st LEFT JOIN ec_receipt_allocation era ON era.type = 'transaction' AND st.txnid = era.etid WHERE st.workflow '6' in filesystem/includes/database.mysql.inc on line 172.
* user warning: 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 ''6' GROUP BY st.txnid ORDER BY st.txnid DESC LIMIT 0, 50' at line 1 query: SELECT DISTINCT st.txnid,st.*,IFNULL((st.gross - SUM(era.amount)), st.gross) AS balance FROM ec_transaction st LEFT JOIN ec_receipt_allocation era ON era.type = 'transaction' AND st.txnid = era.etid WHERE st.workflow '6' GROUP BY st.txnid ORDER BY st.txnid DESC LIMIT 0, 50 in filesystem/includes/database.mysql.inc on line 172.Has anyone struck this before or know what I might need to do to fix it? I can view pending and action orders no problems...
Comments
This area is not for posting
This area is not for posting issues, Please post these issues to http://drupal.org/project/issues/ecommerce
I think this has been fixed in the next alpha for v4
--
Gordon Heydon
Sure thing, thanks Gordon.
Sure thing, thanks Gordon. In the future I'll check there - I thought it might have been something I've done because I've been making the commweb payment gateway integration.
No, Just sometimes I and the
No, Just sometimes I and the other e-Commerce guys are just too busy to get to the support requests every day.
--
Gordon Heydon