Issue: Table 'website.vw_disambigitem' doesn't exist

Issue Tools
- View Changes

June 7, 2020 5:59 PM

xH3LLRAIZ3Rx xH3LLRAIZ3Rx is offline

New Member

Table 'website.vw_disambigitem' doesn't exist

When Installing VaultWiki on Xenforo 2.1 Getting Table not exist error

The Full Error:

Code:

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'website.vw_disambigitem' 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 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 405
    vw_Fetch_Controller->get() in src/addons/vw/vw/_core/controller/fetch/index/vw.php at line 78
    vw_Fetch_Index_Controller->cached() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 285
    vw_Fetch_Controller->cached() in src/addons/vw/vw/_core/model/customfield/vw.php at line 33
    vw_CustomField_Model->relevant() in src/addons/vw/vw/_core/controller/dm/base/vw.php at line 783
    vw_DM_Base_Controller->get_relevant_custom_fields() in src/addons/vw/vw/_core/controller/dm/base/vw.php at line 641
    vw_DM_Base_Controller->process_custom_fields() in src/addons/vw/vw/_core/controller/dm/revision/vw.php at line 1019
    vw_DM_Revision_Controller->process_custom_fields() in src/addons/vw/vw/_core/controller/dm/revision/vw.php at line 1639
    vw_DM_Revision_Controller->pre_save() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 490
    vw\vw\XF\Entity\EntityBase->_preSave() in src/XF/Mvc/Entity/Entity.php at line 1308
    XF\Mvc\Entity\Entity->preSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 481
    vw\vw\XF\Entity\EntityBase->vwPreSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 348
    vw_DM_Controller_XF2->pre_save() in src/addons/vw/vw/_core/controller/dm/base/vw.php at line 877
    vw_DM_Base_Controller->internal_pre_save() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 1076
    vw_DM_Page_Controller->process_revision() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 811
    vw_DM_Page_Controller->pre_save() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 490
    vw\vw\XF\Entity\EntityBase->_preSave() in src/XF/Mvc/Entity/Entity.php at line 1308
    XF\Mvc\Entity\Entity->preSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 481
    vw\vw\XF\Entity\EntityBase->vwPreSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 348
    vw_DM_Controller_XF2->pre_save() in src/addons/vw/vw/_core/controller/dm/index/vw.php at line 363
    vw_DM_Index_Controller->internal_pre_save() in src/addons/vw/vw/_core/controller/dm/index/vw.php at line 347
    vw_DM_Index_Controller->pre_save() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 490
    vw\vw\XF\Entity\EntityBase->_preSave() in src/XF/Mvc/Entity/Entity.php at line 1308
    XF\Mvc\Entity\Entity->preSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 481
    vw\vw\XF\Entity\EntityBase->vwPreSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 536
    vw\vw\XF\Entity\EntityBase->vwSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 382
    vw_DM_Controller_XF2->save() in src/addons/vw/vw/_install/lib/db/insert/vw.php at line 309
    vw_Install_DB_Insert_Controller->execute_dm() in src/addons/vw/vw/_install/lib/full/steps/vw.php at line 140
    vw_Install_Full_Steps_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 300
    vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 218
    vw\vw\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
    XF\Admin\Controller\AddOn->actionInstall() 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 2190
    XF\App->run() in src/XF.php at line 391
    XF::runApp() in admin.php at line 13

Issue Details

Issue Number 6054

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 RC 3

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 1

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 7, 2020 7:54 PM

pegasus

VaultWiki Team

Fixed the earlier install step that failed to create this table, in the next release. This occurs when attempting a fresh install using the RC3 installer. Upgrades from earlier versions are not affected.

Before you can proceed in the installation, you must now run the following MySQL query (has scrollbar):

Code:

CREATE TABLE vw_disambigitem (
disambigitemid INT UNSIGNED NOT NULL AUTO_INCREMENT,
contentid INT UNSIGNED NOT NULL DEFAULT '0',
contenttypeid INT UNSIGNED NOT NULL DEFAULT '0',
itemdisambiguationid INT UNSIGNED NOT NULL DEFAULT '0',
disambig_section INT UNSIGNED NOT NULL DEFAULT '0',
disambig_order INT UNSIGNED NOT NULL DEFAULT '10',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
disambig_short VARCHAR(50) NOT NULL DEFAULT '',
disambig_desc VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (disambigitemid),
UNIQUE INDEX content (contenttypeid, contentid),
INDEX dateline (dateline),
INDEX itemdisambiguationid (itemdisambiguationid),
INDEX section_order (disambig_section, disambig_order),
INDEX userid (userid)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

This will make it possible to finish the installation of RC3. However, if you end up not completing the installation now, and try to with a later (fixed) release, you will still need to run this query first because your database already encountered the issue.

June 7, 2020 8:04 PM

xH3LLRAIZ3Rx xH3LLRAIZ3Rx is offline

New Member

Getting this error now after doing that:

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 src/XF/Db/AbstractStatement.php:228

Code:

Stack trace

SELECT `f`.* FROM `vw_area_field` `a`  LEFT JOIN `vw_field_definition` `f` ON (`f`.`fieldid` = `a`.`fieldid`)   WHERE `a`.`areaid` = 
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#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(148): XF\Db\AbstractAdapter->query('SELECT `f`.* FR...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read('SELECT `f`.* FR...')
#6 src/addons/vw/vw/_core/model/customfield/vw.php(652): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/model/customfield/vw.php(38): vw_CustomField_Model->definition(-1, NULL)
#8 src/addons/vw/vw/_core/controller/dm/base/vw.php(783): vw_CustomField_Model->relevant(Array)
#9 src/addons/vw/vw/_core/controller/dm/base/vw.php(641): vw_DM_Base_Controller->get_relevant_custom_fields()
#10 src/addons/vw/vw/_core/controller/dm/revision/vw.php(1019): vw_DM_Base_Controller->process_custom_fields()
#11 src/addons/vw/vw/_core/controller/dm/revision/vw.php(1639): vw_DM_Revision_Controller->process_custom_fields()
#12 src/addons/vw/vw/XF/Entity/EntityBase.php(490): vw_DM_Revision_Controller->pre_save(true)
#13 src/XF/Mvc/Entity/Entity.php(1308): vw\vw\XF\Entity\EntityBase->_preSave()
#14 src/addons/vw/vw/XF/Entity/EntityBase.php(481): XF\Mvc\Entity\Entity->preSave()
#15 src/addons/vw/vw/_core/controller/dm/xf2.php(348): vw\vw\XF\Entity\EntityBase->vwPreSave()
#16 src/addons/vw/vw/_core/controller/dm/base/vw.php(877): vw_DM_Controller_XF2->pre_save(NULL)
#17 src/addons/vw/vw/_core/controller/dm/page/vw.php(1076): vw_DM_Base_Controller->internal_pre_save(Object(vw_DM_Controller_XF2), NULL)
#18 src/addons/vw/vw/_core/controller/dm/page/vw.php(811): vw_DM_Page_Controller->process_revision()
#19 src/addons/vw/vw/XF/Entity/EntityBase.php(490): vw_DM_Page_Controller->pre_save(true)
#20 src/XF/Mvc/Entity/Entity.php(1308): vw\vw\XF\Entity\EntityBase->_preSave()
#21 src/addons/vw/vw/XF/Entity/EntityBase.php(481): XF\Mvc\Entity\Entity->preSave()
#22 src/addons/vw/vw/_core/controller/dm/xf2.php(348): vw\vw\XF\Entity\EntityBase->vwPreSave()
#23 src/addons/vw/vw/_core/controller/dm/index/vw.php(363): vw_DM_Controller_XF2->pre_save()
#24 src/addons/vw/vw/_core/controller/dm/index/vw.php(347): vw_DM_Index_Controller->internal_pre_save(Object(vw_DM_Controller_XF2), true)
#25 src/addons/vw/vw/XF/Entity/EntityBase.php(490): vw_DM_Index_Controller->pre_save(true)
#26 src/XF/Mvc/Entity/Entity.php(1308): vw\vw\XF\Entity\EntityBase->_preSave()
#27 src/addons/vw/vw/XF/Entity/EntityBase.php(481): XF\Mvc\Entity\Entity->preSave()
#28 src/addons/vw/vw/XF/Entity/EntityBase.php(536): vw\vw\XF\Entity\EntityBase->vwPreSave()
#29 src/addons/vw/vw/_core/controller/dm/xf2.php(382): vw\vw\XF\Entity\EntityBase->vwSave()
#30 src/addons/vw/vw/_install/lib/db/insert/vw.php(309): vw_DM_Controller_XF2->save()
#31 src/addons/vw/vw/_install/lib/full/steps/vw.php(140): vw_Install_DB_Insert_Controller->execute_dm(Object(vw\vw\Setup\Caller\Install))
#32 src/addons/vw/vw/Setup.php(300): vw_Install_Full_Steps_Controller->{closure}(Object(vw\vw\Setup\Caller\Install), false)
#33 src/addons/vw/vw/Setup.php(218): vw\vw\Setup->vwRunStep('install', Object(vw_Install_Full_Steps_Controller_XF2), Array, 8)
#34 src/XF/Admin/Controller/AddOn.php(398): vw\vw\Setup->install(Array)
#35 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\AddOn->actionInstall(Object(XF\Mvc\ParameterBag))
#36 src/XF/Mvc/Dispatcher.php(261): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Install', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#37 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#38 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#39 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#40 src/XF.php(391): XF\App->run()
#41 admin.php(13): XF::runApp('XF\\Admin\\App')
#42 {main}

June 7, 2020 8:13 PM

xH3LLRAIZ3Rx

New Member

I will create a new ticket for that one ^

Reply
June 8, 2020 9:52 AM

JulianD

New Member

I have the exact same problem. I ran the CREATE TABLE query and I got the same error as xH3LLRAIZ3Rx. Any ideas about what to do in order to complete the installation?

Edit: I was able to fix it using the instructions here https://www.vaultwiki.org/issues/6055/

Reply

+ Reply

All times are GMT -4. The time now is 4:12 PM.

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: Table 'website.vw_disambigitem' doesn't exist

Issue Tools