Issue: Undefined variable: db_alter

Issue Tools
- View Changes

January 31, 2015 9:08 PM

collapsible myth collapsible myth is offline

New Member

Undefined variable: db_alter

Trying to upgrade from Lite to full paid version. I have uploaded the full version files to the server and gone into Xenforo admin - wiki- and clicked on upgrade VW. The upgrader gets stuck on 1%.

Code:

Upgrading to 4.0.1
Step 1

Undefined variable: db_alter
vw_CP_Progress_View->handle_php_error() in vault/core/controller/install/upgradepath/steps/4/0/1/C/xf.php at line 48
{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 336
vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 301
vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 238
vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 59
vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 115
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 144
vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13

When I click in Manual mode I receive this error

Code:

Fatal error: Call to a member function fetch() on a non-object in /home/myscifio/public_html/thelowerworld.com/vault/core/controller/install/upgradepath/steps/4/0/1/C/xf.php on line 48

Issue Details

Issue Number 4166

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.1

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)

January 31, 2015 9:40 PM
pegasus

VaultWiki Team
Okay, in vault/core/controller/install/upgradepath/steps/4/0/1/C/xf.php, find:

Code:

$caller->open();

After it, add:

Code:

$db_alter = vw_Hard_Core::controller('DBalter')->get();

This occurred only if you are upgrading from Lite to the paid version on XenForo and your Lite version is less than 4.0.1 at the time, or if you are just upgrading the Lite version from 4.0.0 to 4.0.1 on XenForo.

I will post the updated script in the resource at xenforo.com.
Reply

January 31, 2015 9:48 PM

collapsible myth collapsible myth is offline

New Member

Got a bit further but hit another bump

Code:

Step 7

Updating data in table: vw_route
An exception occurred: Database Error: TRUNCATE TABLE `vw_path` Mysqli statement execute error : Table 'myscifio_lowertsw.vw_path' doesn't exist in /home/myscifio/public_html/thelowerworld.com/vault/core/controller/db/xf.php on line 146
vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 132
vw_DB_Controller_XF->query_write() in vault/core/model/db/mysql/vw.php at line 907
vw_DB_MySQL_Model->shutdown_or_run() in vault/core/model/db/mysql/vw.php at line 306
vw_DB_MySQL_Model->delete() in vault/core/controller/install/upgradepath/steps/4/0/1/base/vw.php at line 605
{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 336
vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 301
vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 238
vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 59
vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 115
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 144
vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13

January 31, 2015 9:54 PM
pegasus

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

Code:

vw_DB::get()->query()->delete(array( 'table' => 'vw_path' ));

I'm not sure but I think you might still get a database error unless you manually skip to the next step (manual mode).
Reply

January 31, 2015 10:05 PM

collapsible myth collapsible myth is offline

New Member

Yeah, still get an error on step 7 and no way to skip it.

Code:

Step 7

Updating data in table: vw_route
An exception occurred: Database Error: SELECT * FROM `vw_prefix` ORDER BY prefixkey ASC Mysqli prepare error: Table 'myscifio_lowertsw.vw_prefix' doesn't exist in /home/myscifio/public_html/thelowerworld.com/vault/core/controller/db/xf.php on line 146
vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 181
vw_DB_Controller_XF->query_read_slave() in vault/core/model/db/mysql/vw.php at line 29
vw_DB_MySQL_Model->select() in vault/core/model/cache/vw.php at line 212
vw_Cache_Model->get() in vault/core/controller/route/vw.php at line 1066
vw_Route_Controller->get_key_map() in vault/core/controller/route/vw.php at line 682
vw_Route_Controller->get_page_list() in vault/core/controller/route/vw.php at line 631
vw_Route_Controller->resolve_title() in vault/core/controller/route/vw.php at line 570
vw_Route_Controller->resolve_titlevar() in vault/core/model/url/vw.php at line 336
vw_URL_Model->find_itemkey() in vault/core/model/url/vw.php at line 412
vw_URL_Model->create_from_title() in vault/core/controller/dm/base/routable/vw.php at line 253
vw_DM_Base_Routable_Controller->get_path() in vault/core/controller/dm/page/vw.php at line 435
vw_DM_Page_Controller->pre_save() in library/vw/XenForo/DataWriter.php at line 431
vw_XenForo_DataWriter->_preSave() in library/XenForo/DataWriter.php at line 1446
XenForo_DataWriter->preSave() in library/vw/XenForo/DataWriter.php at line 154
vw_XenForo_DataWriter->preSaveWithReturn() in vault/core/controller/dm/xf.php at line 367
vw_DM_Controller_XF->pre_save() in library/vw/XenForo/DataWriter.php at line 149
vw_XenForo_DataWriter->preSave() in library/XenForo/DataWriter.php at line 1385
XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 400
vw_DM_Controller_XF->save() in vault/core/controller/install/upgradepath/steps/4/0/1/base/vw.php at line 659
{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 336
vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 301
vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 238
vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 59
vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 115
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 144
vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13

January 31, 2015 10:07 PM

pegasus

VaultWiki Team

Add &step=1 to the URL in your browser (then increase the 1 to whatever number gets you past the error).

Reply
January 31, 2015 10:18 PM

collapsible myth

New Member

Okay, that's seeming to work. Finalizing and on step 10 and things have gone smoothly. Had to jump to step 8 after getting the error

Reply

+ Reply

All times are GMT -4. The time now is 11:48 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: Undefined variable: db_alter

Issue Tools