Resolved LogicException: Unknown relation or alias Item accessed on xf_xa_sc_item src/XF/Mvc/Entity/Finder.php:768

[Ληδяέ]

LogicException: Unknown relation or alias Item accessed on xf_xa_sc_item src/XF/Mvc/Entity/Finder.php:768

Stack trace

#0 src/XF/Mvc/Entity/Finder.php(659): XF\Mvc\Entity\Finder->join('Item', true, false, false)

#1 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->with(Array)

#2 src/XF/App.php(2874): XF\Mvc\Entity\Manager->find('XenAddons\\Showc...', 9, Array)

#3 src/XF/Poll/AbstractHandler.php(40): XF\App->findByContentType('sc_item', 9, Array)

#4 src/XF/Entity/Poll.php(180): XF\Poll\AbstractHandler->getContent(9)

#5 src/addons/DBTech/Credits/EventTrigger/Poll.php(99): XF\Entity\Poll->getContent()

#6 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(856): DBTech\Credits\EventTrigger\Poll->rebuild(Object(DBTech\Credits\XF\Entity\Poll))

#7 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(804): DBTech\Credits\EventTrigger\AbstractHandler->rebuildEntities(Object(XF\Mvc\Entity\ArrayCollection))

#8 src/addons/DBTech/Credits/Job/TransactionRebuild.php(88): DBTech\Credits\EventTrigger\AbstractHandler->rebuildRange(0, 500)

#9 src/XF/Job/Manager.php(260): DBTech\Credits\Job\TransactionRebuild->run(8)

#10 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)

#11 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)

#12 src/XF/Admin/Controller/Tools.php(141): XF\Job\Manager->runQueue(true, 8)

#13 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))

#14 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XFCloud\XF\Admin\Controller\Tools), NULL)

#15 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFCloud\XF\Admin\Controller\Tools), NULL)

#16 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))

#17 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()

#18 src/XF.php(524): XF\App->run()

#19 admin.php(13): XF::runApp('XF\\Admin\\App')

#20 {main}

Request state
array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(40) "Administrator login | NZFSF.NZ"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(10) "/admin.php"
["_xfToken"] => string(8) "********"
["only_ids"] => string(0) ""
}
}

 

[Ληδяέ]

Any idea what this means?

 

[Bob]

Its code in DB Techs Credits addon that is looking for a relation in the xf_xa_sc_item Entity that does not exist.

Its almost acting as if there is an transaction in DB Tech Credits based on Showcase Item item_id 9 for having a poll and that poll in Showcase Item item_id 9 has since been removed, but the transaction record in DB Tech Credits remains and would fail when rebuilding transactions.

Does showcase item 9 have a poll?

 

[Ληδяέ]

Yeah item 9 did have a poll, so I've just deleted it, then continued the rebuild but now it's giving this error:

ErrorException: [E_WARNING] Attempt to read property "node_id" on null in src/addons/DBTech/Credits/EventTrigger/React.php at line 133

XF::handlePhpError() in src/addons/DBTech/Credits/EventTrigger/React.php at line 133

DBTech\Credits\EventTrigger\React->rebuild() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 856

DBTech\Credits\EventTrigger\AbstractHandler->rebuildEntities() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 804

DBTech\Credits\EventTrigger\AbstractHandler->rebuildRange() in src/addons/DBTech/Credits/Job/TransactionRebuild.php at line 88

DBTech\Credits\Job\TransactionRebuild->run() in src/XF/Job/Manager.php at line 260

XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202

XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 86

XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 141

XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352

XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259

XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115

XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57

XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487

XF\App->run() in src/XF.php at line 524

XF::runApp() in admin.php at line 13


And sorry, I do see that this most likely relates specifically to DBTech Credits.
(*they still haven't responded at all to my first support ticket)

 

[Ληδяέ]

Also, thank you

 

[Bob]

Yeah item 9 did have a poll, so I've just deleted it, then continued the rebuild but now it's giving this error:

ErrorException: [E_WARNING] Attempt to read property "node_id" on null in src/addons/DBTech/Credits/EventTrigger/React.php at line 133

That one has no connection with Showcase. That one isn't even related to the previous error. This one is has something to do with reactions and nodes.

And sorry, I do see that this most likely relates specifically to DBTech Credits.
(*they still haven't responded at all to my first support ticket)

No worries Ya, this one is definitely an issue that DB Tech would need to look into as its related to his addon and nodes.

 

[Ληδяέ]

Cheers mate, really appreciated.