I'll need to check that one out..
Seems to be in conflict with XFA Tournaments addon?
Got this error in server log today. I haven't tried to install the tag addon since the initial error posted above, but seems like it is trying to run the complete job.
Server error log
- XF\Db\Exception: Job MaZ\PotentialTagHelper:RebuildPotentialThreadTags: MySQL statement prepare error [1052]: Column 'title' in where clause is ambiguous
- src/XF/Db/AbstractStatement.php:230
- Generated by: Unknown account
- May 1, 2023 at 5:20 PM
Stack trace
SELECT
xf_thread
.
thread_id
,
xf_thread
.
title
FROM
xf_thread
LEFT JOIN
xf_xfa_tourn_tournament
AS
xf_xfa_tourn_tournament_Tournament_1
ON (
xf_xfa_tourn_tournament_Tournament_1
.
discussion_thread_id
=
xf_thread
.
thread_id
)
WHERE (
xf_thread
.
thread_id
NOT IN (136)) AND (LOWER(title) LIKE '%mythic games%') AND (
xf_thread
.
discussion_state
= 'visible') AND (
xf_thread
.
discussion_type
!= 'redirect')
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1052, '23000')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1052, '23000')
#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/Mvc/Entity/Finder.php(1474): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/XF/Mvc/Entity/Finder.php(1489): XF\Mvc\Entity\Finder->fetchRaw(Array)
#6 src/addons/MaZ/PotentialTagHelper/Repository/PotentialTags.php(104): XF\Mvc\Entity\Finder->fetchColumns('thread_id', 'title')
#7 src/addons/MaZ/PotentialTagHelper/Repository/PotentialTags.php(79): MaZ\PotentialTagHelper\Repository\PotentialTags->collectThreadIdsForWord('mythic games', Array)
#8 src/addons/MaZ/PotentialTagHelper/Job/RebuildPotentialThreadTags.php(39): MaZ\PotentialTagHelper\Repository\PotentialTags->collectThreadIdsForTag(Object(MaZ\PotentialTagHelper\XF\Entity\Tag), Array)
#9 src/XF/Job/AbstractRebuildJob.php(42): MaZ\PotentialTagHelper\Job\RebuildPotentialThreadTags->rebuildById(106)
#10 src/XF/Job/Manager.php(260): XF\Job\AbstractRebuildJob->run(8)
#11 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#12 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)
#13 job.php(43): XF\Job\Manager->runQueue(false, 8)
#14 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(73) "
https://www.boardgamedungeon.net/threads/mythic-games-latest-blunder.136/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}