Issue: Can't uninstall VaultWiki 4.1.0 Beta 1 on XF 2.1.5

Issue Tools
- View Changes

November 30, 2019 2:10 PM

Daniel Nenni Daniel Nenni is offline

New Member

Can't uninstall VaultWiki 4.1.0 Beta 1 on XF 2.1.5

Code:

XF\Db\Exception: MySQL query error [1146]: Table 'semiwiki_xf2.vw_parsed' doesn't exist in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/addons/vw/vw/_core/controller/db/xf2.php at line 117
vw_DB_Controller_XF2->query_write() in src/addons/vw/vw/_core/model/db/mysql/vw.php at line 1330
vw_DB_MySQL_Model->shutdown_or_run() in src/addons/vw/vw/_core/model/db/mysql/vw.php at line 366
vw_DB_MySQL_Model->delete() in src/addons/vw/vw/_core/model/rebuild/vw.php at line 33
vw_Rebuild_Model->parsed() in src/addons/vw/vw/_core/model/rebuild/xf2.php at line 36
vw_Rebuild_Model_XF2->parsed() in src/addons/vw/vw/_core/model/rebuild/vw.php at line 27
vw_Rebuild_Model->bbcode() in src/addons/vw/vw/_core/model/rebuild/xf2.php at line 30
vw_Rebuild_Model_XF2->bbcode() in src/addons/vw/vw/_core/controller/uninstall/xf2.php at line 49
vw_UnInstall_Controller_XF2->remove_insertions() in src/addons/vw/vw/_core/controller/uninstall/vw.php at line 46
vw_UnInstall_Controller->insertions() in src/addons/vw/vw/Setup.php at line 1028
vw\vw\Setup->uninstallStep1() in src/XF/AddOn/StepRunnerUninstallTrait.php at line 59
vw\vw\Setup->uninstallStepRunner() in src/XF/AddOn/StepRunnerUninstallTrait.php at line 26
vw\vw\Setup->uninstall() in src/XF/Admin/Controller/AddOn.php at line 636
XF\Admin\Controller\AddOn->actionUninstall() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
XF\App->run() in src/XF.php at line 391
XF::runApp() in admin.php at line 13

Code:

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'semiwiki_xf2.xf_liked_content' doesn't exist src/XF/Db/AbstractStatement.php:228
Generated by: admin Nov 30, 2019 at 7:03 PM
Stack trace
DELETE FROM `xf_liked_content` WHERE  `content_type` IN ('vwattachedit','vwcomment','vwfakelike','vwfeed','vwfeeditem','vwpage','vwredirect','vwrevision','vwspecial') 
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#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 `xf...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(1330): vw_DB_Controller_XF2->query_write('DELETE FROM `xf...')
#6 src/addons/vw/vw/_core/model/db/mysql/vw.php(366): vw_DB_MySQL_Model->shutdown_or_run('DELETE FROM `xf...', false)
#7 src/addons/vw/vw/_core/controller/uninstall/xf2.php(109): vw_DB_MySQL_Model->delete(Array)
#8 src/addons/vw/vw/Setup.php(1068): vw_UnInstall_Controller_XF2->unified()
#9 src/XF/AddOn/StepRunnerUninstallTrait.php(59): vw\vw\Setup->uninstallStep5(Array)
#10 src/XF/AddOn/StepRunnerUninstallTrait.php(26): vw\vw\Setup->uninstallStepRunner(5, Array)
#11 src/XF/Admin/Controller/AddOn.php(636): vw\vw\Setup->uninstall(Array)
#12 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\AddOn->actionUninstall(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(261): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Uninstall', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#14 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#15 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#17 src/XF.php(391): XF\App->run()
#18 admin.php(13): XF::runApp('XF\\Admin\\App')
#19 {main}
Request state
array(4) {
  ["url"] => string(40) "/forum/admin.php?add-ons/vw-vw/uninstall"
  ["referrer"] => string(60) "https://semiwiki.com/forum/admin.php?add-ons/vw-vw/uninstall"
  ["_GET"] => array(1) {
    ["add-ons/vw-vw/uninstall"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(10) "{"step":5}"
    ["count"] => string(1) "5"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

Issue Details

Issue Number 5932

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Duplicate

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 Beta 1

Fixed Version (none)

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)

December 1, 2019 7:11 PM
pegasus

VaultWiki Team
The first error listed would occur if you already attempted to uninstall and completed steps 1-3. When attempting to re-perform step 1 later this error would occur. This was fixed in Beta 3.

The second error would occur due to the uninstall process not being updated for XenForo 2.1 database changes, causing step 5 to fail. This issue was also fixed in Beta 3.

You can resolve the issues by uploading Beta 3 over your Beta 1 installation and proceeding to Uninstall as before. If you do not have access to Beta 3, you can make the following changes to src/addons/vw/vw/_core/controller/uninstall/xf2.php. Find and remove:

Code:

vw_Hard_Core::model('Rebuild')->bbcode();

Find:

Code:

'table' => 'xf_liked_content',

Replace with:

Code:

'table' => 'xf_reaction_content',

Marking as a duplicate.
Reply
December 5, 2019 1:25 PM

Daniel Nenni

New Member

This worked fine in a testing environment but when I did it on the server which already encountered the error the entire site crashed and has an unexpected database error. I have had to restore the site from yesterday's backup. Please give me a safer way to get this off my website.

Reply
December 6, 2019 6:37 PM

Daniel Nenni

New Member

Nevermind I managed to get it uninstalled and reinstalled as the latest version.

Reply

+ Reply

All times are GMT -4. The time now is 10:53 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: Can't uninstall VaultWiki 4.1.0 Beta 1 on XF 2.1.5

Issue Tools