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.

Error when installing new version - Mysqli prepare error: Unknown column 'sportsbook_bet_count' in '

Discussion in 'Sportsbook Support' started by doemasters, Aug 18, 2016.

  1. doemasters

    doemasters New Member Pickem Sportsbook

    I just tried to upgrade to the latest version and have errors coming up so i deleted everything in the sportsbook directories and tried a fresh install but I am still getting this error below. Any idea what is wrong?

    Mysqli prepare error: Unknown column 'sportsbook_bet_count' in 'field list'

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in NFLJ/Sportsbook/Model/Bet.php at line 714
    5. NFLJ_Sportsbook_Model_Bet->rebuildSportsbookBetCounts() in NFLJ/Sportsbook/Deferred/BetUser.php at line 29
    6. NFLJ_Sportsbook_Deferred_BetUser->execute() in XenForo/Model/Deferred.php at line 295
    7. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    8. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    9. XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
    10. XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 347
    11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    12. XenForo_FrontController->run() in /home/rolltide/public_html/forum/admin.php at line 13
  2. Bob

    Bob Developer Staff Member

    You DO NOT manually delete stuff, you use the UNINSTALLER to remove it. The Uninstall process PROPERLY removes all Database related stuff. Sounds like the DB in still in tact

    Send me an inbox with phpMyAdmin access so that I can check the DB to see where you are at and what needs to be done. I'll also need FTP access and Admin CP access. I'll get you "fixed" :)
  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.