Issue: Cannot merge threads

Issue Tools
- View Changes

September 27, 2019 8:25 PM

beernuts

Junior Member

Cannot merge threads

Moderators receiving an error when trying to merge threads. I assume it's Vaultwiki related due to the dump:

Code:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'userid' in 'where clause' src/XF/Db/AbstractStatement.php:217

DELETE FROM `vw_report` WHERE userid = 111653 AND itemtypeid = 0 AND itemid = 574442 LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(117): XF\Db\AbstractAdapter->query('DELETE FROM `vw...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(1330): vw_DB_Controller_XF2->query_write('DELETE FROM `vw...')
#6 src/addons/vw/vw/_core/model/db/mysql/vw.php(366): vw_DB_MySQL_Model->shutdown_or_run('DELETE FROM `vw...', false)
#7 src/addons/vw/vw/XF/Entity/Thread.php(51): vw_DB_MySQL_Model->delete(Array)
#8 src/XF/Mvc/Entity/Entity.php(1584): vw\vw\XF\Entity\Thread->_postDelete()
#9 src/XF/Service/Thread/Merger.php(123): XF\Mvc\Entity\Entity->delete()
#10 src/XF/InlineMod/Thread/Merge.php(78): XF\Service\Thread\Merger->merge(Array)
#11 src/XF/InlineMod/AbstractAction.php(80): XF\InlineMod\Thread\Merge->applyInternal(Object(XF\Mvc\Entity\ArrayCollection), Array)
#12 src/XF/Pub/Controller/InlineMod.php(131): XF\InlineMod\AbstractAction->apply(Object(XF\Mvc\Entity\ArrayCollection), Array)
#13 src/addons/vw/vw/XF/Pub/Controller/InlineMod.php(41): XF\Pub\Controller\InlineMod->actionPerform()
#14 src/addons/Siropu/AdsManager/XF/Pub/Controller/InlineMod.php(54): vw\vw\XF\Pub\Controller\InlineMod->actionPerform()
#15 src/XF/Mvc/Dispatcher.php(321): Siropu\AdsManager\XF\Pub\Controller\InlineMod->actionPerform(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:InlineMod', 'Perform', Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\XF\Pub\Controller\InlineMod), Object(XF\Mvc\Reply\Reroute))
#17 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\XF\Pub\Controller\InlineMod), Object(XF\Mvc\Reply\Reroute))
#18 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#20 src/XF.php(390): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}

Issue Details

Issue Number 5878

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 Beta 3

Fixed Version 4.1.0 Beta 4

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

September 28, 2019 9:28 AM
pegasus

VaultWiki Team
Fixed in the next release. This occurs when the thread that will no longer exist after the merge exists in the forum where reports go. So you should be able to merge threads that are not in this forum, or reverse the order of the merge if only one thread exists in the forum.

What follows is not a fix, but a workaround -- the additional data does not need to be removed due to this error, because the same error would have prevented the data from being created in the first place. In the next release, creation and deletion are fixed by adding the missing columns back onto the database table.

In src/addons/vw/vw/XF/Entity/Thread.php, find:

Code:

// delete old XF1 dummy report

BEFORE it, add:

Code:

return $retval;
Reply

+ Reply

All times are GMT -4. The time now is 1:21 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Cannot merge threads

Issue Tools