Resolved Incompatibility with Ozzy's badges addon

[Nik]

I've just reported this to Ozzy here as I think the issue is with his addon: [OzzModz] Badges

But Showcase won't install cleanly with Badges installed, at least for me.

Thought I should flag it whilst it gets looked at.

Will update thread when/if something comes of this.

 

[Bob]

Did you disable that addon and then try again?

 

[Nik]

Did you disable that addon and then try again?

Yep, first thing I did. Unfortunately the pending job still stalls at the same step.

Wondering if I can roll back/uninstall Showcase with a job pending.

 

[Bob]

Can you disable ALL addons? I see several of Xon's, which also requires his framework. Disabling all of those might let you continue with the install. Just guessing as it's definitely not a Showcase issue, otherwise nobody would be able to do a fresh install of Showcase and I just did one this AM for an XF Cloud Customer (and XF cloud verifies all addons before they are even installable). Can't hurt to at least TRY disabling all addons.

 

[Nik]

Can you disable ALL addons? I see several of Xon's, which also requires his framework. Disabling all of those might let you continue with the install. Just guessing as it's definitely not a Showcase issue, otherwise nobody would be able to do a fresh install of Showcase and I just did one this AM for an XF Cloud Customer (and XF cloud verifies all addons before they are even installable). Can't hurt to at least TRY disabling all addons.

For sure don't think it's SC, I'll work through the addons list starting with Xon's and see if it'll at least complete.

 

[Nik]

So small update. Disabled all XON addons and Ozzmods badges, was able to resume install (I even did a rebuild of SC). All good here.

Now issue comes when adding an item via the front end. Looks like Ozzy's Content Badges is inserting itself in there like a rather tipsy uncle at the end of a dinner party.

Receiving the below so looks like not out of the woods there with Ozzy's stuff. FYI for anyone hitting this.

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'ozzmodz_cb_cache' in 'field list'
 
src/XF/Db/AbstractStatement.php:230
Generated by: Nik
 
Nov 10, 2023 at 6:29 PM
Stack trace
INSERT  INTO `xf_xa_sc_item` (`category_id`, `user_id`, `username`, `item_state`, `title`, `message`, `embed_metadata`, `message_s2`, `message_s3`, `message_s4`, `message_s5`, `message_s6`, `author_rating`, `location`, `location_data`, `og_title`, `meta_title`, `description`, `meta_description`, `comments_open`, `ratings_open`, `rating_weighted`, `rating_avg`, `item_id`, `contributor_user_ids`, `sticky`, `create_date`, `last_update`, `last_feature_date`, `edit_date`, `attach_count`, `view_count`, `watch_count`, `update_count`, `page_count`, `rating_count`, `rating_sum`, `review_count`, `cover_image_id`, `discussion_thread_id`, `custom_fields`, `prefix_id`, `last_review_date`, `tags`, `has_poll`, `last_edit_date`, `last_edit_user_id`, `edit_count`, `business_hours`, `series_part_id`, `warning_id`, `warning_message`, `ip_id`, `last_comment_date`, `last_comment_id`, `last_comment_user_id`, `last_comment_username`, `reaction_score`, `reactions`, `reaction_users`, `ozzmodz_cb_cache`, `ozzmodz_cb_count`, `ozzmodz_cb_last_award_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1521): XF\Db\AbstractAdapter->insert('xf_xa_sc_item', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/XenAddons/Showcase/Service/Item/Create.php(441): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/ValidateAndSavableTrait.php(42): XenAddons\Showcase\Service\Item\Create->_save()
#9 src/addons/XenAddons/Showcase/Pub/Controller/Category.php(422): XenAddons\Showcase\Service\Item\Create->save()
#10 src/XF/Mvc/Dispatcher.php(352): XenAddons\Showcase\Pub\Controller\Category->actionAdd(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XenAddons\\Showc...', 'Add', Object(XF\Mvc\RouteMatch), Object(XenAddons\Showcase\Pub\Controller\Category), NULL)
#12 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenAddons\Showcase\Pub\Controller\Category), NULL)
#13 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#15 src/XF.php(524): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}
Request state
array(4) {
  ["url"] => string(44) "/showcase/categories/corvette-showcase.4/add"
  ["referrer"] => string(78) "https://mysite.com/showcase/categories/corvette-showcase.4/add"
  ["_GET"] => array(1) {
   ["/showcase/categories/corvette-showcase_4/add"] => string(0) ""
  }
  ["_POST"] => array(19) {
   ["_xfToken"] => string(8) "********"
   ["title"] => string(4) "test"
   ["tags"] => string(0) ""
   ["description"] => string(4) "test"
   ["author_rating"] => string(1) "5"
   ["message_html"] => string(11) "<p>test</p>"
   ["attachment_hash"] => string(32) "14ea60cda36cfb0cd726e44b21755f7c"
   ["attachment_hash_combined"] => string(88) "{"type":"sc_item","context":{"category_id":4},"hash":"14ea60cda36cfb0cd726e44b21755f7c"}"
   ["location"] => string(0) ""
   ["comments_open"] => string(1) "1"
   ["ratings_open"] => string(1) "1"
   ["poll"] => array(5) {
     ["question"] => string(0) ""
     ["new_responses"] => array(1) {
       [0] => string(0) ""
     }
     ["max_votes_type"] => string(6) "single"
     ["change_vote"] => string(1) "1"
     ["view_results_unvoted"] => string(1) "1"
   }
   ["og_title"] => string(0) ""
   ["meta_title"] => string(0) ""
   ["meta_description"] => string(0) ""
   ["save_type"] => string(11) "publish_now"
   ["_xfRequestUri"] => string(44) "/showcase/categories/corvette-showcase.4/add"
   ["_xfWithData"] => string(1) "1"
   ["_xfResponseType"] => string(4) "json"
  }
}

 

[Bob]

Unknown column 'ozzmodz_cb_cache' in 'field list'

When you see that error for XF2, that means one of two things... the field(s) is/are not physically added to the database table OR the field(s) have not been properly added to the $structure->columns = [] of the Content Type Entity.

The first one is easy to check if you have access to your database. Look at the table 'xf_xa_sc_item' and see if these fields have been added. If NOT, then that is PART of the problem.

`ozzmodz_cb_cache`, `ozzmodz_cb_count`, `ozzmodz_cb_last_award_date`

The other one is not as easy as it require dumping the Entity Object to see if the Entity Structure lists those fields along with default values.

Has the Badges Addon be re-enabled? If not, re-enable it so that any extensions to Showcase by the Badges addon (like extending the Showcase Item Entity) is happening.

 

[Nik]

When you see that error for XF2, that means one of two things... the field(s) is/are not physically added to the database table OR the field(s) have not been properly added to the $structure->columns = [] of the Content Type Entity.

The first one is easy to check if you have access to your database. Look at the table 'xf_xa_sc_item' and see if these fields have been added. If NOT, then that is PART of the problem.

`ozzmodz_cb_cache`, `ozzmodz_cb_count`, `ozzmodz_cb_last_award_date`

The other one is not as easy as it require dumping the Entity Object to see if the Entity Structure lists those fields along with default values.

Has the Badges Addon be re-enabled? If not, re-enable it so that any extensions to Showcase by the Badges addon (like extending the Showcase Item Entity) is happening.

Thanks Bob, yes I checked the table schema and those fields are indeed not there. I did reach out to Painbaker and he's already provided a patch to add them back in. If anyone is wondering fix is on Snog's site.

 

[Bob]

Thanks Bob, yes I checked the table schema and those fields are indeed not there. I did reach out to Painbaker and he's already provided a patch to add them back in. If anyone is wondering fix is on Snog's site.

Outstanding Can I mark this as resolved then?

 

[Nik]

Indeed you can. Appreciate your help.

This was more of an informal PSA for others.