Issue: Upgrade from beta3 to beta 4 fails

Issue Tools
- View Changes

July 30, 2013 12:59 PM

rizwank

New Member

Upgrade from beta3 to beta 4 fails

Code:

Parse error: syntax error, unexpected T_VARIABLE in /var/www/html/forum/vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/base/vw.php on line 46

Fixed by placing a semicolon right above this after the curly.

Code:

Altering table: vw_report
An exception occurred: Mysqli statement execute error : Incorrect index name '' in /var/www/html/forum/library/Zend/Db/Statement/Mysqli.php on line 214
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 /var/www/html/forum/vault/core/controller/db/xf.php at line 121
vw_DB_Controller_XF->query_write() in /var/www/html/forum/vault/core/controller/dbalter/vw.php at line 273
vw_DBalter_Instance->execute_query() in /var/www/html/forum/vault/core/controller/dbalter/mysql/vw.php at line 508
vw_DBalter_MySQL_Controller->add_index() in /var/www/html/forum/vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/base/vw.php at line 40
{closure}() in /var/www/html/forum/vault/core/controller/install/upgradepath/vw.php at line 57
vw_Install_UpgradePath_Controller->call() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 264
vw_CP_Install_Controller->exec_step() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 224
vw_CP_Install_Controller->upgrade_type() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 161
vw_CP_Install_Controller->upgrade() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 69
vw_CP_Install_Controller->execute() in /var/www/html/forum/vault/cp/global.php at line 72
require_once() in /var/www/html/forum/vault/install/index.php at line 40

Issue Details

Issue Number 3262

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 4

Fixed Version 4.0.0 Beta 4

Milestone VaultWiki 4 Beta X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 30, 2013 1:42 PM

pegasus

VaultWiki Team

Same file, find:

Code:

				$db_alter->add_index(array(
					'type' => 'PRIMARY',
					'field' => 'reportid'
				));

Replace with:

Code:

				$db_alter->add_index(array(
					'type' => 'PRIMARY',
					'field' => 'reportid'
				), '', 'PRIMARY');

July 30, 2013 1:46 PM

rizwank

New Member

Commented out

Code:

#                               $db_alter->add_index(array(
#                                       'type' => 'PRIMARY',
#                                       'field' => 'reportid'
#                               ));

in the interest of saving my users trouble. A manual SQL alter statement would be appreciated assuming it's something more complex than the syntax would suggest.

EDIT : undid this patch, used the patch above, and commented out something for step 3 to re-complete. now stuck below.

then

Code:

Updating data in table: vw_counter
An exception occurred: Mysqli prepare error: Unknown column 'counter.pageid' in 'where clause' in /var/www/html/forum/library/Zend/Db/Statement/Mysqli.php on line 77
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in /var/www/html/forum/vault/core/controller/db/xf.php at line 121
vw_DB_Controller_XF->query_write() in /var/www/html/forum/vault/core/model/db/mysql/vw.php at line 807
vw_DB_MySQL_Model->shutdown_or_run() in /var/www/html/forum/vault/core/model/db/mysql/vw.php at line 576
vw_DB_MySQL_Model->update() in /var/www/html/forum/vault/core/controller/install/upgradepath/steps/4/0/0/beta/4/base/vw.php at line 185
{closure}() in /var/www/html/forum/vault/core/controller/install/upgradepath/vw.php at line 57
vw_Install_UpgradePath_Controller->call() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 264
vw_CP_Install_Controller->exec_step() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 224
vw_CP_Install_Controller->upgrade_type() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 161
vw_CP_Install_Controller->upgrade() in /var/www/html/forum/vault/core/controller/cp/install/vw.php at line 69
vw_CP_Install_Controller->execute() in /var/www/html/forum/vault/cp/global.php at line 72
require_once() in /var/www/html/forum/vault/install/index.php at line 40

le sigh.

July 30, 2013 2:03 PM

pegasus

VaultWiki Team

In vault/core/model/db/mysql/vw.php, find:

Code:

		$input['table'] = reset($table);

		$changes = $this->construct_update_string($input['set']);

Replace with:

Code:

		$table = reset($table);

		$changes = $this->construct_update_string($input['set']);

Find:

Code:

$query = "UPDATE " . $this->wrap($this->prefix($input['table'])) . " SET " . $changes;

Replace with:

Code:

$query = "UPDATE " . $this->construct_table($table, $input['table']["$table"]) . " SET " . $changes;

July 30, 2013 2:19 PM

rizwank

New Member

Proceeded well through upgrade setps; then went to another series of steps --- after phrase import.

An unexpected error occurred. Please try again later.
I figured it might have timed out for permissions reasons, as when I revisited the installer, it required a re-login.

Running again now -- phrase import seems slower than ever.

Anyhow, completed fine now! Installed!

Reply
July 30, 2013 2:34 PM

pegasus

VaultWiki Team

I'm here all day if you have any other issues. I'll be working on the other things we wanted to be in Beta 4, but we had to rush because of the security bug.

Reply
July 31, 2013 1:12 AM

rizwank

New Member

Thanks.

Reply

+ Reply

All times are GMT -4. The time now is 10:39 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: Upgrade from beta3 to beta 4 fails

Issue Tools