error
Permalink Browser Info Environment
Hi, i got this error coming back from sagepay in test mode
An unexpected error occurred.
mysqli error: [1064: 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 '?' at line 1] in EXECUTE("select * from DatasouthSagepayTransactionLog WHERE coreOrderID = ?")
LOG:
Today at 6:02:32 PM exceptions Guest Exception Occurred: /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqli error: [1064: 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 '?' at line 1] in EXECUTE("select * from DatasouthSagepayTransactionLog WHERE coreOrderID = ?")
(1064)
#0 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqli', 'EXECUTE', 1064, 'You have an err...', 'select * from D...', false, Object(ADODB_mysqli))
#1 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('select * from D...', false)
#2 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1643): ADOConnection->Execute('select * from D...', NULL)
#3 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(704): ADOConnection->GetRow('select * from D...', NULL)
#4 /home/zyecbtfj/marzipanmedia.com/packages/sagepay_form/models/core_commerce/payment/methods/sagepay_form/controller.php(338): ADODB_Active_Record->Load('coreOrderID = ?', NULL)
#5 /home/zyecbtfj/marzipanmedia.com/packages/sagepay_form/models/core_commerce/payment/methods/sagepay_form/controller.php(309): CoreCommerceSagepayFormPaymentMethodController->_updateSagepayOrderStatus(NULL, Object(CoreCommerceOrder), Array)
#6 [internal function]: CoreCommerceSagepayFormPaymentMethodController->action_notify_success()
#7 /home/zyecbtfj/marzipanmedia.com/packages/core_commerce/tools/payment_method_action.php(10): call_user_func_array(Array, Array)
#8 /home/zyecbtfj/marzipanmedia.com/concrete/startup/tools.php(29): include('/home/zyecbtfj/...')
#9 /home/zyecbtfj/marzipanmedia.com/concrete/dispatcher.php(146): require('/home/zyecbtfj/...')
#10 /home/zyecbtfj/marzipanmedia.com/index.php(2): require('/home/zyecbtfj/...')
#11 {main}
Today at 6:02:32 PM debug Guest Sage Pay unable to set status. Status received: :
Any thoughts on this ?
thanks
An unexpected error occurred.
mysqli error: [1064: 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 '?' at line 1] in EXECUTE("select * from DatasouthSagepayTransactionLog WHERE coreOrderID = ?")
LOG:
Today at 6:02:32 PM exceptions Guest Exception Occurred: /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqli error: [1064: 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 '?' at line 1] in EXECUTE("select * from DatasouthSagepayTransactionLog WHERE coreOrderID = ?")
(1064)
#0 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqli', 'EXECUTE', 1064, 'You have an err...', 'select * from D...', false, Object(ADODB_mysqli))
#1 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('select * from D...', false)
#2 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1643): ADOConnection->Execute('select * from D...', NULL)
#3 /home/zyecbtfj/marzipanmedia.com/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(704): ADOConnection->GetRow('select * from D...', NULL)
#4 /home/zyecbtfj/marzipanmedia.com/packages/sagepay_form/models/core_commerce/payment/methods/sagepay_form/controller.php(338): ADODB_Active_Record->Load('coreOrderID = ?', NULL)
#5 /home/zyecbtfj/marzipanmedia.com/packages/sagepay_form/models/core_commerce/payment/methods/sagepay_form/controller.php(309): CoreCommerceSagepayFormPaymentMethodController->_updateSagepayOrderStatus(NULL, Object(CoreCommerceOrder), Array)
#6 [internal function]: CoreCommerceSagepayFormPaymentMethodController->action_notify_success()
#7 /home/zyecbtfj/marzipanmedia.com/packages/core_commerce/tools/payment_method_action.php(10): call_user_func_array(Array, Array)
#8 /home/zyecbtfj/marzipanmedia.com/concrete/startup/tools.php(29): include('/home/zyecbtfj/...')
#9 /home/zyecbtfj/marzipanmedia.com/concrete/dispatcher.php(146): require('/home/zyecbtfj/...')
#10 /home/zyecbtfj/marzipanmedia.com/index.php(2): require('/home/zyecbtfj/...')
#11 {main}
Today at 6:02:32 PM debug Guest Sage Pay unable to set status. Status received: :
Any thoughts on this ?
thanks
| Type: | Pre-Sale |
|---|---|
| Status: | New |
