Issue: Upgrade to 4.0.22 fails (on Xenforo) - undefined index

Issue Tools
- View Changes

May 25, 2018 11:48 AM

wolven

New Member

Upgrade to 4.0.22 fails (on Xenforo) - undefined index

update fails

Upgrading to 4.0.21
Step 5

Updating data in table: vw_counter
Undefined index: lastupdate
#0: vw_CP_Progress_View->handle_php_error() in [path]/vault/install/lib/upgradepath/steps/4/0/21/base/vw.php at line 588
#1: vw_Install_UpgradePath_Steps_4021_base_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#2: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#3: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/upgradepath/vw.php at line 69
#4: vw_Install_UpgradePath_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#5: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#6: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 436
#7: vw_CP_Install_Controller->upgrade() in [path]/vault/core/controller/cp/install/vw.php at line 56
#8: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 125
#9: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 182
#10: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 369
#11: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 152
#12: XenForo_FrontController->run() in [path]/admin.php at line 13

Issue Details

Issue Number 5409

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.22

Fixed Version 4.0.23

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)

May 25, 2018 12:21 PM

pegasus

VaultWiki Team

I think this is happening because your database table vw_route is missing a UNIQUE index 'itemid' on columns itemtypeid+itemid, which I see is possible if you once upgraded from earlier than 4.0.7, and it would make it possible to generate duplicate vw_route records in some situations like accidentally double-clicking the submit button to create a new page. When we do a reverse lookup in the 4.0.21 upgrade step and then the forward lookup, the records do not match, and some of the fields are missing as a result.

This error message is a minor E_NOTICE so you should be able to complete the upgrade if you disable XenForo's debug mode while you upgrade. The message will still appear in your logs, but it is safe to ignore.

We will add a step to the 4.0.23 upgrade to cleanup the situation in your database.

Reply

+ Reply

All times are GMT -4. The time now is 11:37 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 to 4.0.22 fails (on Xenforo) - undefined index

Issue Tools