Issue: B6 upgrade error: Truncated incorrect INTEGER value: 'XenForo'

Issue Tools
- View Changes

October 1, 2013 8:54 PM

Alfa1

Distinguished Member

B6 upgrade error: Truncated incorrect INTEGER value: 'XenForo'

Step 2

Updating data in table: xf_route_prefix

Server Error

Code:

Mysqli statement execute error : Truncated incorrect INTEGER value: 'XenForo'

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in /vault/core/controller/db/xf.php at line 107
    vw_DB_Controller_XF->query_write() in /vault/core/model/db/mysql/vw.php at line 829
    vw_DB_MySQL_Model->shutdown_or_run() in //vault/core/model/db/mysql/vw.php at line 598
    vw_DB_MySQL_Model->update() in /vault/core/controller/install/upgradepath/steps/4/0/0/beta/6/C/xf.php at line 75
    {closure}() in /vault/core/controller/install/upgradepath/vw.php at line 71
    vw_Install_UpgradePath_Controller->call() in /vault/core/controller/cp/install/vw.php at line 270
    vw_CP_Install_Controller->exec_step() in /vault/core/controller/cp/install/vw.php at line 230
    vw_CP_Install_Controller->upgrade_type() in /vault/core/controller/cp/install/vw.php at line 167
    vw_CP_Install_Controller->upgrade() in /vault/core/controller/cp/install/vw.php at line 69
    vw_CP_Install_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 94
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in vw/XenForo/ControllerAdmin/Wiki.php at line 123
    vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in XenForo/FrontController.php at line 337
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /admin.php at line 13

Issue Details

Issue Number 3359

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 4.0.0 Beta 6

Fixed Version 4.0.0 Beta 7

Milestone VaultWiki 4 Beta X

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)

October 1, 2013 10:18 PM
pegasus

VaultWiki Team
I don't know how this was in the package. The bug fix was applied before the release according to the timestamps. Anyway, I updated the package.

In vault/core/controller/install/upgradepath/4/0/0/beta/6/C/xf.php, find:

Code:

'where' => vw_DB::get()->func()->escape_string('addon_id', "'vaultwiki_stub'"),

Replace with:

Code:

'where' => vw_DB::get()->query()->eq('addon_id', "'vaultwiki_stub'"),
Reply

+ Reply

All times are GMT -4. The time now is 11:57 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: B6 upgrade error: Truncated incorrect INTEGER value: 'XenForo'

Issue Tools