Issue: Mysqli prepare error: Unknown column 'l.userid' in 'field list'

Issue Tools
- View Changes

September 5, 2013 7:28 AM

Alfa1

Distinguished Member

Mysqli prepare error: Unknown column 'l.userid' in 'field list'

When accessing the /vault/install/ folder this crashes the site and the following error occurs:

Code:

An exception occurred: Mysqli prepare error: Unknown column 'l.userid' in 'field list' in /library/Zend/Db/Statement/Mysqli.php on line 77

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in /vault/core/controller/db/xf.php at line 115
    vw_DB_Controller_XF->query_read() in /vault/core/model/db/mysql/vw.php at line 29
    vw_DB_MySQL_Model->select() in /vault/core/controller/fetch/vw.php at line 144
    vw_Fetch_Controller->get() in /vault/core/controller/fetch/vw.php at line 353
    vw_Fetch_Controller->get_index() in /vault/core/controller/fetch/vw.php at line 55
    vw_Fetch_Controller->get() in /vault/core/model/ui/tab/index/vw.php at line 34
    vw_UI_Tab_Index_Model->can_main_tab() in /vault/core/model/ui/tab/vw.php at line 58
    vw_UI_Tab_Model->check() in vw/XenForo/CodeEventListener/Public.php at line 41
    vw_XenForo_CodeEventListener_Public::navigation_tabs()
    call_user_func_array() in XenForo/CodeEvent.php at line 90
    XenForo_CodeEvent::fire() in XenForo/Dependencies/Public.php at line 491
    XenForo_Dependencies_Public->_getNavigationContainerParams() in XenForo/Dependencies/Public.php at line 371
    XenForo_Dependencies_Public->getEffectiveContainerParams() in XenForo/FrontController.php at line 602
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /index.php at line 13

The error remains and the site is down.

Issue Details

Issue Number 3314

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Not a Bug

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 5

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

September 5, 2013 10:23 AM

pegasus

VaultWiki Team

You must always disable VaultWiki before uploading new files for an upgrade. If the new files expect database changes, not disabling the addon beforehand can cause errors like this.

Once VaultWiki is disabled, you must follow the new upgrade process for XenForo, which I see you have already found: https://www.vaultwiki.org/manual/vau...ns-for-XenForo

The /vault/install path does not exist in Beta 5. Attempting to access that folder if it's leftover from Beta 4 will just show error messages.

Reply
September 10, 2013 1:51 PM

pegasus

VaultWiki Team

Added this feature for Beta 6 so that the site is more forgiving if users forget to disable VaultWiki before uploading new files: https://www.vaultwiki.org/issues/3323/

Reply

+ Reply

All times are GMT -4. The time now is 12:42 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: Mysqli prepare error: Unknown column 'l.userid' in 'field list'

Issue Tools