Issue: Mysqli prepare error: BLOB/TEXT column 'defaultsort' can't have a default value

Issue Tools
- View Changes

January 13, 2014 11:51 PM

Alfa1

Distinguished Member

Mysqli prepare error: BLOB/TEXT column 'defaultsort' can't have a default value

Upgrading to 4.0.0 Gamma 1
Step 2

Creating table: vw_import

Altering table: vw_area

Code:

Server Error
Mysqli prepare error: BLOB/TEXT column 'defaultsort' can't have a default value
1.	Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2.	Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3.	Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4.	Zend_Db_Adapter_Abstract->query() in /vault/core/controller/db/xf.php at line 107
5.	vw_DB_Controller_XF->query_write() in /vault/core/controller/dbalter/vw.php at line 291
6.	vw_DBalter_Instance->execute_query() in /vault/core/controller/dbalter/mysql/vw.php at line 386
7.	vw_DBalter_MySQL_Controller->add_field() in /vault/core/controller/install/upgradepath/steps/4/0/0/gamma/1/base/vw.php at line 85
8.	{closure}() in /vault/core/controller/install/upgradepath/vw.php at line 57
9.	vw_Install_UpgradePath_Controller->call() in /vault/core/controller/cp/install/vw.php at line 270
10.	vw_CP_Install_Controller->exec_step() in /vault/core/controller/cp/install/vw.php at line 230
11.	vw_CP_Install_Controller->upgrade_type() in /vault/core/controller/cp/install/vw.php at line 167
12.	vw_CP_Install_Controller->upgrade() in /vault/core/controller/cp/install/vw.php at line 69
13.	vw_CP_Install_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 94
14.	vw_XenForo_ControllerAdmin_Wiki->actionIndex() in vw/XenForo/ControllerAdmin/Wiki.php at line 123
15.	vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in XenForo/FrontController.php at line 347
16.	XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
17.	XenForo_FrontController->run() in /admin.php at line 13

Issue Details

Issue Number 3516

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 1

Fixed Version 4.0.0 Gamma 1

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)

January 14, 2014 12:00 AM
pegasus

VaultWiki Team
In vault/core/controller/install/upgradepath/4/0/0/gamma/1/base/vw.php, find and remove:

Code:

'default' => "'a:0:{}'"

XenForo uses MySQL strict mode which doesn't allow this.
Reply

+ Reply

All times are GMT -4. The time now is 10:23 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: BLOB/TEXT column 'defaultsort' can't have a default value

Issue Tools