Discussion Thread Enhancements for Bob's Showcase [Deleted]

Which function? There are no public functions used in this except when overriding "XenAddons\Showcase\ThreadType\Item".
 
I'll enable the add-ons again and check, but when I was testing the addon that caused the errors it happened with Showcase as well.

EDIT: Apparently it wasn't erroring, just confused the Prefix add-on.
 
Last edited:
Would be nice to inform in description that people will need Bob's Showcase add-on.
Thanks.
 
Got this error @benFF

Server error log
Code:
 XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'discussion_post_id' in 'field list' src/XF/Db/AbstractStatement.php:230

    Generated by: eL_ Oct 22, 2022 at 2:32 AM

Stack trace
Code:
INSERT  INTO `xf_xa_sc_item_rating` (`item_id`, `user_id`, `username`, `rating_state`, `message`, `embed_metadata`, `rating`, `pros`, `cons`, `title`, `is_review`, `rating_id`, `rating_date`, `author_response_contributor_user_id`, `author_response_contributor_username`, `author_response`, `custom_fields`, `warning_id`, `warning_message`, `ip_id`, `is_anonymous`, `attach_count`, `last_edit_date`, `last_edit_user_id`, `edit_count`, `reply_count`, `first_reply_date`, `last_reply_date`, `latest_reply_ids`, `reaction_score`, `reactions`, `reaction_users`, `vote_score`, `vote_count`, `discussion_post_id`) 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(1516): XF\Db\AbstractAdapter->insert('xf_xa_sc_item_r...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1248): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/XenAddons/Showcase/Service/Item/Rate.php(298): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/ValidateAndSavableTrait.php(42): XenAddons\Showcase\Service\Item\Rate->_save()
#9 src/addons/XenAddons/Showcase/Pub/Controller/Item.php(1100): XenAddons\Showcase\Service\Item\Rate->save()
#10 src/XF/Mvc/Dispatcher.php(352): XenAddons\Showcase\Pub\Controller\Item->actionRate(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XenAddons\\Showc...', 'Rate', Object(XF\Mvc\RouteMatch), Object(XenAddons\Showcase\Pub\Controller\Item), NULL)
#12 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenAddons\Showcase\Pub\Controller\Item), NULL)
#13 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2353): 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
Code:
array(4) {
  ["url"] => string(59) "/WE-PLAY/assassins-creed-valhalla-dawn-of-ragnaroek.10/rate"
  ["referrer"] => string(74) "https://we-play.pro/WE-PLAY/assassins-creed-valhalla-dawn-of-ragnaroek.10/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(11) {
    ["_xfToken"] => string(8) "********"
    ["rating"] => string(1) "5"
    ["title"] => string(98) "Assassin's Creed Valhalla: Dawn of Ragnarök, most ambitious expansion in the history of the games"
    ["pros"] => string(25) "A beautiful game to play!"
    ["cons"] => string(22) "I didn't find any yet!"
    ["message_html"] => string(32) "<p>Well, you have to try it!</p>"
    ["attachment_hash"] => string(32) "a92d664be66fbc2b962e7186d2633e1e"
    ["attachment_hash_combined"] => string(90) "{"type":"sc_rating","context":{"category_id":4},"hash":"a92d664be66fbc2b962e7186d2633e1e"}"
    ["_xfRequestUri"] => string(55) "/WE-PLAY/assassins-creed-valhalla-dawn-of-ragnaroek.10/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Got this error @benFF
I was baffled by this until I realised I hadn't updated the install routine to add the new database fields (only the update routine)

1.0.10 now has this - but I think you will need to uninstall and re-install (rather than just update over the top) to pick them up :)
 
  • Like
Reactions: eL_
Top Bottom