Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Fixed Error selling stock through AdminCP

Discussion in 'Stock Trader Resolved Bug Reports' started by andrewkm, Mar 31, 2015.

  1. andrewkm

    andrewkm Member

    After clicking on the "sell" button beside the users stock in AdminCP I get:

    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: 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 'WHERE user_id = 2' at line 3 - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: andrewkm, 30 minutes ago
    Stack Trace
    #0 /home/ecocitycraft/public_html/forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tUPDATE xf_...')
    #1 /home/ecocitycraft/public_html/forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tUPDATE xf_...')
    #2 /home/ecocitycraft/public_html/forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tUPDATE xf_...')
    #3 /home/ecocitycraft/public_html/forum/library/NFLJ/StockTrader/Model/Cash.php(112): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tUPDATE xf_...')
    #4 /home/ecocitycraft/public_html/forum/library/NFLJ/StockTrader/DataWriter/Stock.php(119): NFLJ_StockTrader_Model_Cash->addToCash(NULL, 2)
    #5 /home/ecocitycraft/public_html/forum/library/XenForo/DataWriter.php(1409): NFLJ_StockTrader_DataWriter_Stock->_postSave()
    #6 /home/ecocitycraft/public_html/forum/library/NFLJ/StockTrader/ControllerAdmin/Stock.php(45): XenForo_DataWriter->save()
    #7 /home/ecocitycraft/public_html/forum/library/XenForo/FrontController.php(347): NFLJ_StockTrader_ControllerAdmin_Stock->actionSell()
    #8 /home/ecocitycraft/public_html/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/ecocitycraft/public_html/forum/admin.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(80) "http://www.ecocitycraft.com/forum/admin.php?stocktrader-stock/apple-inc.201/sell"
    ["_GET"] => array(1) {
    ["stocktrader-stock/apple-inc_201/sell"] => string(0) ""
    ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    Last edited: Mar 31, 2015
  2. Bob

    Bob Developer Staff Member

  3. andrewkm

    andrewkm Member

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.