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 '


New Member
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
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" :)