Issue: Won't Install - vaultwiki_410b4b2_xf21

Issue Tools
- View Changes

October 13, 2019 11:47 PM

HateMailPersonified

New Member

Won't Install - vaultwiki_410b4b2_xf21

Using the installer, we get a error saying it can not create the vw_route.

Hi,

Using version vaultwiki_410b4b2_xf21 of VaultWiki, we ran into the issue using the installer with the following error -

We did try older versions, and used the built in XenForo installer.

Issue Details

Issue Number 5895

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 4.1.0 Beta 4

Fixed Version 4.1.0 Beta 4

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags install, xenforo

October 14, 2019 10:11 AM
pegasus

VaultWiki Team
We will need to find out why vw_route wasn't created. In src/addons/vw/vw/_core/instance/dbalter/vw.php, find:

Code:

protected function execute_query($query) { vw_DB::get($this->key)->func()->hide_errors();

Replace with:

Code:

protected function execute_query($query) { //vw_DB::get($this->key)->func()->hide_errors();

In MySQL, run the following query:

Code:

TRUNCATE TABLE vw_upgradelog

Then attempt to install again. I will expect a database error to occur when trying to create the vw_route table. Please provide the text of the error message.
Reply

October 14, 2019 8:45 PM

HateMailPersonified HateMailPersonified is offline

New Member

Originally Posted by pegasus

We will need to find out why vw_route wasn't created. In src/addons/vw/vw/_core/instance/dbalter/vw.php, find:

Code:

	protected function execute_query($query)
	{
		vw_DB::get($this->key)->func()->hide_errors();

Replace with:

Code:

	protected function execute_query($query)
	{
		//vw_DB::get($this->key)->func()->hide_errors();

In MySQL, run the following query:

Code:

TRUNCATE TABLE vw_upgradelog

Then attempt to install again. I will expect a database error to occur when trying to create the vw_route table. Please provide the text of the error message.

Code:

XF\Db\InvalidQueryException: MySQL query error [1071]: Specified key was too long; max key length is 767 bytes in src/XF/Db/AbstractStatement.php at line 217
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 94
XF\Db\AbstractAdapter->query() in src/addons/vw/vw/_core/controller/db/xf2.php at line 117
vw_DB_Controller_XF2->query_write() in src/addons/vw/vw/_core/instance/dbalter/vw.php at line 344
vw_DBalter_Instance->execute_query() in src/addons/vw/vw/_core/instance/dbalter/mysql/vw.php at line 171
vw_DBalter_MySQL_Instance->create_table() in src/addons/vw/vw/_install/lib/db/create/vw.php at line 158
vw_Install_DB_Create_Controller->execute() in src/addons/vw/vw/_install/lib/full/steps/vw.php at line 32
vw_Install_Full_Steps_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 217
vw\vw\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

Is this what you were asking for?

October 15, 2019 10:03 AM

pegasus

VaultWiki Team

This occurs when using full-unicode support in XenForo 2 while also using a MySQL version 5.6.x or lower.

In src/addons/vw/vw/_install/lib/db/create/route/vw.php and src/addons/vw/vw/_install/lib/db/create/link/vw.php, find:

Code:

'field' => 'sortkey'

Replace with:

Code:

'field' => 'sortkey', 'length' => 185

In src/addons/vw/vw/_install/lib/db/create/redirect/vw.php, find:

Code:

					array(
						'name' => 'targetkey',
						'length' => 125
					),
					array(
						'name' => 'sectionkey',
						'length' => 125
					)

Replace with:

Code:

					array(
						'name' => 'targetkey',
						'length' => 125
					),
					array(
						'name' => 'sectionkey',
						'length' => 50
					)

In src/addons/vw/vw/_install/lib/db/create/301/vw.php, find:

Code:

				'type' => 'UNIQUE',
				'name' => 'sourcecontent',
				'fields' => array(
					'oldgroup',
					'value'
				)

Replace with:

Code:

				'name' => 'sourcecontent',
				'fields' => array(
					'oldgroup',
					array(
						'name' => 'value',
						'length' => 150
					)
				)

October 15, 2019 7:17 PM

HateMailPersonified HateMailPersonified is offline

New Member

Code:

XF\Db\InvalidQueryException: MySQL query error [1071]: Specified key was too long; max key length is 767 bytes in src/XF/Db/AbstractStatement.php at line 217
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 94
XF\Db\AbstractAdapter->query() in src/addons/vw/vw/_core/controller/db/xf2.php at line 117
vw_DB_Controller_XF2->query_write() in src/addons/vw/vw/_core/instance/dbalter/vw.php at line 344
vw_DBalter_Instance->execute_query() in src/addons/vw/vw/_core/instance/dbalter/mysql/vw.php at line 171
vw_DBalter_MySQL_Instance->create_table() in src/addons/vw/vw/_install/lib/db/create/vw.php at line 158
vw_Install_DB_Create_Controller->execute() in src/addons/vw/vw/_install/lib/full/steps/vw.php at line 32
vw_Install_Full_Steps_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 217
vw\vw\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

We changed the specific code mentioned, but we seem to be getting the same error message.

October 16, 2019 8:21 AM

pegasus

VaultWiki Team

Please send the contents of your most recent install log file to me in a PM.
The log file is located in /internal_data/vw_logs/install/

Reply
October 22, 2019 9:18 AM

pegasus

VaultWiki Team

Followed up via ticket. The relevant issues are resolved for other users in the next build (today or tomorrow).

Reply

+ Reply

All times are GMT -4. The time now is 12:34 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: Won't Install - vaultwiki_410b4b2_xf21

Issue Tools