Issue: [4.1 Alpha 1] Unable to save page: MySQL query error [1264]: Out of range value for column 'textsize' at row 1

Issue Tools
- View Changes

January 3, 2019 5:11 AM

ACL

Regular Member

[4.1 Alpha 1] Unable to save page: MySQL query error [1264]: Out of range value for column 'textsize' at row 1

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'textsize' at row 1 in src/XF/Db/AbstractStatement.php at line 212

Assuming this relates to vw_revision, I can see that textsize in VW 4.1 Alpha 1 for XF2 is type tinyint(3), which is different to WW4.0 for XF1 where this column was type int(10). I've adjusted the textsize column back to VW 4.0 specification, int(10), and now I can save the wiki page.

Stack trace:

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 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 160
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1409
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1141
XF\Mvc\Entity\Entity->save() in src/addons/vw/vw/XF/Entity/Entity.php at line 492
vw\vw\XF\Entity\Entity->vwSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 362
vw_DM_Controller_XF2->save() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 1945
vw_DM_Page_Controller->save_revision() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 1555
vw_DM_Page_Controller->post_save_each() in src/addons/vw/vw/XF/Entity/Entity.php at line 565
vw\vw\XF\Entity\Entity->_postSave() in src/XF/Mvc/Entity/Entity.php at line 1165
XF\Mvc\Entity\Entity->save() in src/addons/vw/vw/XF/Entity/Entity.php at line 492
vw\vw\XF\Entity\Entity->vwSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 362
vw_DM_Controller_XF2->save() in src/addons/vw/vw/_core/controller/ui/edit/vw.php at line 222
vw_UI_Edit_Controller->save() in src/addons/vw/vw/_core/controller/ui/page/vw.php at line 431
vw_UI_Page_Controller->save() in src/addons/vw/vw/_core/controller/ui/page/vw.php at line 166
vw_UI_Page_Controller->execute() in src/addons/vw/vw/_core/controller/ui/stack/vw.php at line 246
vw_UI_Stack_Controller->execute() in src/addons/vw/vw/Pub/Controller/Wiki/Wiki.php at line 80
vw\vw\Pub\Controller\Wiki\Wiki->_actionIndex() in src/addons/vw/vw/Mvc/Dispatcher.php at line 30
vw\vw\Mvc\Dispatcher::dispatch() in src/addons/vw/vw/Pub/Controller/Wiki/AbstractController.php at line 25
vw\vw\Pub\Controller\Wiki\AbstractController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
XF\App->run() in src/XF.php at line 333
XF::runApp() in index.php at line 13

Issue Details

Issue Number 5567

Issue Type Bug

Project VaultWiki 4.x Series

Category Editing Pages

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.24

Fixed Version 4.0.25

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

January 3, 2019 4:19 PM

pegasus

VaultWiki Team

This bug first appeared in new installations of 4.0.24. It will be fixed in 4.0.25 on the stable branch.

In the 4.1.x branch, the wrong specification will be corrected for new installations of the next build. For existing installations, the database field vw_revision.textsize will be changed back to int when upgrading to Alpha 2.

This will mark the first occasion where both branches need to perform the same task. Thus, starting with the next 4.1.x build, it will maintain a separate record of the stable upgrade scripts that were run before upgrading to 4.1.x versions (people who upgraded to 4.1.x from 4.0.24 would not have run the upgrade steps for 4.0.27), so that we can make sure that steps needed by both branches are still run but are not run more than once by the upgrade from 4.0.x -> 4.1.x, even as 4.0.x and 4.1.x diverge in future versions.

Reply

+ Reply

All times are GMT -4. The time now is 8:29 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 1] Unable to save page: MySQL query error [1264]: Out of range value for column 'textsize' at row 1

Issue Tools