Issue: [4.1 Alpha 3] XF1.5 to XF2.1 upgrade: vw_reactions table missing, database exception error

Issue Tools
- View Changes

April 4, 2019 1:29 PM

ACL

Regular Member

[4.1 Alpha 3] XF1.5 to XF2.1 upgrade: vw_reactions table missing, database exception error

I've performed a test upgrade from VaultWiki 4.1 Alpha 3 XF1.5 version to XF2.1 version. After upgrading the addon, at least one expected mysql table is missing:
[XF\Db\Exception] MySQL statement prepare error [1146]: Table 'vw_reactions' doesn't exist in src/XF/Db/AbstractStatement.php on line 217

Code:

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 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
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 148
vw_DB_Controller_XF2->query_read() in src/addons/vw/vw/_core/model/db/mysql/vw.php at line 25
vw_DB_MySQL_Model->select() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 333
vw_Fetch_Controller->get() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 643
vw_Fetch_Controller->get_index() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 464
vw_Fetch_Controller->return_the_index() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 236
vw_Fetch_Controller->get() in src/addons/vw/vw/_core/model/ui/tab/index/vw.php at line 30
vw_UI_Tab_Index_Model->can_main_tab() in src/addons/vw/vw/_core/model/ui/tab/vw.php at line 56
vw_UI_Tab_Model->check() in src/addons/vw/vw/_core/model/plugins/general/vw.php at line 329
vw_Plugins_General_Model->get_raw_links() in src/addons/vw/vw/_core/model/plugins/general/xf2.php at line 152
vw_Plugins_General_Model_XF2->get_raw_links() in src/addons/vw/vw/_core/model/plugins/general/vw.php at line 185
vw_Plugins_General_Model->get_nav_links() in src/addons/vw/vw/Helper/Model/Navigation.php at line 26
vw\vw\Helper\Model\Navigation::canViewNav() in internal_data/code_cache/navigation_cache.php at line 254
XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6625
XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

I see a vw_likes table ... so perhaps this part of the upgrade was meant for XF2.0?

Issue Details

Issue Number 5701

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 Alpha 3

Fixed Version 4.1.0 Alpha 3

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)

April 4, 2019 1:53 PM
pegasus

VaultWiki Team
Fixed in the next build. This occurred when upgrading directly to Alpha 3 for XF 2.1 from VW for XF not 2.1.

In src/addons/vw/vw/_core/model/install/version/list/xf2.php, find:

Code:

if (vw_Hard_Core::model('Version')->compare($platform, '2.1.0 Alpha 0') > -1)

Replace with:

Code:

if (vw_Compat::is('2.1.0 Alpha 0'))

You will need to trick XenForo into thinking you haven't upgraded yet. In MySQL:

Code:

UPDATE xf_addon SET version_id = version_id - 1, version_string = '4.1.0 Alpha 2', json_hash = '' WHERE addon_id = 'vw/vw'

Then upgrade again in the normal way.
Reply
April 4, 2019 2:09 PM

ACL

Regular Member

Thank you, that seems to be fine now. At this point in the upgrade process, having upgraded XenForo from XF1.5 to XF2.1 plus VaultWiki, is now the recommended time to uninstall "VaultWiki Routes" legacy add-on? Or is it better to do this before upgrading to XF2.x?

Reply
April 4, 2019 2:26 PM

pegasus

VaultWiki Team

I don't believe it matters. The VaultWiki Routes add-on is only used to provide the interface for the initial installation on XF 1.x; it is not needed for installation on XF 2.x. It is not used beyond the initial installation for 1.x and can be removed at any time.

Reply
April 4, 2019 2:41 PM

ACL

Regular Member

Oh, interesting, I wasn't aware until now that VW Routes is just for the initial install. Although, had I inspected the xml it would have been kind of obvious .. whoops :P.

Reply

+ Reply

All times are GMT -4. The time now is 7:09 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: [4.1 Alpha 3] XF1.5 to XF2.1 upgrade: vw_reactions table missing, database exception error

Issue Tools