Fixed InvalidArgumentException: Unknown column title on XenAddons\AMS:ArticleRating src/XF/Mvc/Entity/Finder.php:1821

[MrWorldWide]

AMS Version

2.3.3

XenForo Version

2.3.3

PHP Version

8.3.11

Database & Version

10.4.30 (10.4.30-MariaDB)

Are there any errors being throw?

Yes

Click this link:

https://demos.xenaddons.com/articles/authors/craigles700.23/reviews?term=test&order=rating&direction=desc

You'll get an error:
Oops! We ran into some problems.
A server error occurred. Please try again later.

InvalidArgumentException: Unknown column title on XenAddons\AMS:ArticleRating src/XF/Mvc/Entity/Finder.php:1821
Generated by: admin Oct 16, 2024 at 10:13 AM

Stack trace
#0 src/XF/Mvc/Entity/Finder.php(623): XF\Mvc\Entity\Finder->resolveFieldToTableAndColumn('title', true)
#1 src/XF/Mvc/Entity/FinderExpression.php(36): XF\Mvc\Entity\Finder->columnSqlName('title', true)
#2 src/XF/Mvc/Entity/Finder.php(283): XF\Mvc\Entity\FinderExpression->renderSql(Object(XenAddons\AMS\Finder\ArticleRating), true)
#3 src/XF/Mvc/Entity/Finder.php(422): XF\Mvc\Entity\Finder->buildCondition(Object(XF\Mvc\Entity\FinderExpression), 'LIKE', '%@@xxx%')
#4 src/XF/Mvc/Entity/Finder.php(187): XF\Mvc\Entity\Finder->buildConditionFromArray(Array)
#5 src/addons/XenAddons/AMS/ControllerPlugin/AuthorReviewList.php(132): XF\Mvc\Entity\Finder->whereOr(Array, Array, Array, Array)
#6 src/addons/XenAddons/AMS/ControllerPlugin/AuthorReviewList.php(30): XenAddons\AMS\ControllerPlugin\AuthorReviewList->applyReviewFilters(Object(XenAddons\AMS\Finder\ArticleRating), Array)
#7 src/addons/XenAddons/AMS/Pub/Controller/Author.php(252): XenAddons\AMS\ControllerPlugin\AuthorReviewList->getAuthorReviewListData(Array, Object(SV\DailyStatistics\XF\Entity\User))
#8 src/XF/Mvc/Dispatcher.php(362): XenAddons\AMS\Pub\Controller\Author->actionReviews(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenAddons\\AMS:A...', 'Reviews', Object(XF\Mvc\RouteMatch), Object(XenAddons\AMS\Pub\Controller\Author), NULL)
#10 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenAddons\AMS\Pub\Controller\Author), NULL)
#11 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state
array(4) {
  ["url"] => string(51) "/ams/authors/xxx.xxxxxx/reviews?term=%40%40xxx"
  ["referrer"] => bool(false)
  ["_GET"] => array(1) {
    ["term"] => string(7) "@@xxx"
  }
  ["_POST"] => array(0) {
  }
}

 

[Bob]

Article Reviews do not have a title, but other add-ons of mine do, so it could be a minor issue with the review filters function.

Update: The issue is with the "Reviews that mention" filter.

I'll probably update all my add-ons that have reviews, to add the optional review title feature so that it's standardized across all XenAddons products.

 

[Bob]

This has been resolved in AMS 2.3.4