/ Register

  1. April Fools Day Sale starting today through Sunday April 2nd.
    $15 discount on all licenses. $10 discount on 1 year support/downloads extensions.
  2. REGISTRATION REQUIREMENTS:

    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.
April Fools Day Sale Registration Information

Resolved Database errors on 2.2 Beta 2

Discussion in 'Sportsbook Support' started by HammerDown, Aug 26, 2020.

  1. Aug 26, 2020 #1
    HammerDown

    HammerDown New Member Pickem Sportsbook

    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'embed_metadata' in 'field list' in src/XF/Db/AbstractStatement.php at line 228
    1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
    3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
    4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
    6. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
    7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
    8. XF\Mvc\Entity\Entity->save() in src/addons/XenAddons/Sportsbook/Service/EventItem/Create.php at line 226
    9. XenAddons\Sportsbook\Service\EventItem\Create->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
    10. XenAddons\Sportsbook\Service\EventItem\Create->save() in src/addons/XenAddons/Sportsbook/Pub/Controller/Category.php at line 272
    11. XenAddons\Sportsbook\Pub\Controller\Category->actionAdd() in src/XF/Mvc/Dispatcher.php at line 350
    12. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    13. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2298
    16. XF\App->run() in src/XF.php at line 464
    17. XF::runApp() in index.php at line 20

     
  2. Aug 26, 2020 #2
    McAtze

    McAtze Member AMS Premium CAS Premium LD Premium RMS Premium SC Premium UBS Premium Pickem Power Rankings Sportsbook

    I have the same issue when trying create an event. I have a clean XF2.2 Beta4 and Sportsbook 2.2.0 Beta2 installation.

    Code:
    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'embed_metadata' in 'field list' in src/XF/Db/AbstractStatement.php at line 228

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
    XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
    XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
    XF\Mvc\Entity\Entity->save() in src/addons/XenAddons/Sportsbook/Service/EventItem/Create.php at line 226
    XenAddons\Sportsbook\Service\EventItem\Create->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
    XenAddons\Sportsbook\Service\EventItem\Create->save() in src/addons/XenAddons/Sportsbook/Pub/Controller/Category.php at line 272
    XenAddons\Sportsbook\Pub\Controller\Category->actionAdd() in src/XF/Mvc/Dispatcher.php at line 350
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2298
    XF\App->run() in src/XF.php at line 464
    XF::runApp() in index.php at line 20
     
  3. Aug 26, 2020 #3
    Bob

    Bob Developer Staff Member

    Run these 2 queries on your DB...

    Code:
    ALTER TABLE xf_xa_sb_event ADD embed_metadata blob NULL DEFAULT '';
    Code:
    ALTER TABLE xf_xa_sb_event ADD attach_count smallint(5) unsigned NOT NULL default '0' after comment_count;
     
    Last edited: Aug 26, 2020
    KyleK and McAtze like this.
  4. Aug 26, 2020 #4
    McAtze

    McAtze Member AMS Premium CAS Premium LD Premium RMS Premium SC Premium UBS Premium Pickem Power Rankings Sportsbook

    Yeah, that works fine now. Thanks..
     
    Bob likes this.
  5. Aug 26, 2020 #5
    Bob

    Bob Developer Staff Member

    Keep a keen eye out for any more issues so I can get them fixed ASAP.
     
  6. Aug 26, 2020 #6
    McAtze

    McAtze Member AMS Premium CAS Premium LD Premium RMS Premium SC Premium UBS Premium Pickem Power Rankings Sportsbook

    Yes Sir.. (y)
     
    Bob likes this.
  7. Aug 26, 2020 #7
    HammerDown

    HammerDown New Member Pickem Sportsbook

    THANK YOU, gentlemen! Next round's on me.
     
    Last edited by a moderator: Aug 26, 2020
    Bob and McAtze like this.
  8. Aug 26, 2020 #8
    Bob

    Bob Developer Staff Member

    Better make it a double for me as my KIDS are driving me NUTS!
     
    HammerDown, mouth and McAtze like this.
  9. Aug 29, 2020 #9
    Brad P

    Brad P New Member AMS Premium Sportsbook

    I was about to download this tonight to install on my site that is running 2.2.0 Beta 4 and then the latest sportsbook version, after reading the above is it worth holding fire in case it breaks site?
     
  10. Aug 29, 2020 #10
    McAtze

    McAtze Member AMS Premium CAS Premium LD Premium RMS Premium SC Premium UBS Premium Pickem Power Rankings Sportsbook

    It is an Beta, so it is not recommend to use it productive. ;)
     
    Brad P likes this.
  11. Sep 1, 2020 #11
    Bob

    Bob Developer Staff Member

    I've fixed the issues in the INSTALLER, so once I release SB 2.2.0 Beta 3, you should be fine as it was just a matter of 2 fields that were added to the UPDATE part of the installer, but not added to the INSTALL part of the installer, so it was only effecting NEW installs. Anyway... SB 2.2.0 Beta 3 will be released sometime today.
     
    HammerDown and Brad P like this.
  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.
    Accept Learn More...