Resolved Database errors on 2.2 Beta 2

[HammerDown]

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
    
    

 

[McAtze]

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

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

 

[Bob]

Run these 2 queries on your DB...

ALTER TABLE xf_xa_sb_event ADD embed_metadata blob NULL DEFAULT '';

ALTER TABLE xf_xa_sb_event ADD attach_count smallint(5) unsigned NOT NULL default '0' after comment_count;

 

[McAtze]

Yeah, that works fine now. Thanks..

 

[Bob]

Yeah, that works fine now. Thanks..

Keep a keen eye out for any more issues so I can get them fixed ASAP.

 

[McAtze]

Yes Sir..

 

[HammerDown]

Run these 2 queries on your DB...

ALTER TABLE xf_xa_sb_event ADD embed_metadata blob NULL DEFAULT '';

ALTER TABLE xf_xa_sb_event ADD attach_count smallint(5) unsigned NOT NULL default '0' after comment_count;

THANK YOU, gentlemen! Next round's on me.

 

[Bob]

THANK YOU, gentlemen! Next round's on me.

Better make it a double for me as my KIDS are driving me NUTS!

 

[Brad P]

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?

 

[McAtze]

It is an Beta, so it is not recommend to use it productive.

 

[Bob]

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?

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.