Issue: Mysqli statement execute error : Data truncated for column 'vw_lastactivity' at row 1

Issue Tools
- View Changes

September 7, 2013 7:58 PM

Alfa1

Distinguished Member

Mysqli statement execute error : Data truncated for column 'vw_lastactivity' at row 1

The beta4 to beta5 upgrade script gives this error:

Code:

Mysqli statement execute error : Data truncated for column 'vw_lastactivity' at row 1


    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/controller/dbalter/vw.php at line 273
    vw_DBalter_Instance->execute_query() in /vault/core/controller/dbalter/mysql/vw.php at line 430
    vw_DBalter_MySQL_Controller->change_field() in /vault/core/controller/install/upgradepath/steps/4/0/0/beta/5/base/vw.php at line 219
    {closure}() in /vault/core/controller/install/upgradepath/vw.php at line 57
    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 106
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in vw/XenForo/ControllerAdmin/Wiki.php at line 120
    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 3319

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

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 7, 2013 8:29 PM

pegasus

VaultWiki Team

Fixed in build 004. Kinda glad this error appeared. Since vB doesn't use MySQL Strict mode, it didn't complain that a TEXT column suddenly became an UNSIGNED INT column. It's supposed to stay a TEXT column. The only change to lastactivity is that it should be named vw_lastactivity.

Reply

+ Reply

All times are GMT -4. The time now is 9:03 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: Mysqli statement execute error : Data truncated for column 'vw_lastactivity' at row 1

Issue Tools