Issue: Error Upgrade VaultWiki 4.0.6 to 4.0.7

Issue Tools
- View Changes

November 1, 2015 3:48 AM

AlexL777

Junior Member

Error Upgrade VaultWiki 4.0.6 to 4.0.7

Unfortunately, the upgrade does not work and there are errors generated - XenForo 1.5.2

Dear developers,

I would like today to VaultWiki upgrade from 4.0.6 to version 4.0.7, but I receive error when upgrading.

I've tried and uptograden manually as well as the upgrade script. Both does not work out.

These errors are displayed: And I use XenForo the latest version!

Step 6

Importing BB codes

PHP Code:

An exception occurred: mysqli prepare error: Unknown column 'vw_extra' in 'field list' in xxxxxxxxxxxxx / XenForo / library / Zend / Db / Statement / Mysqli.php on line 77 Zend_Db_Statement_Mysqli -> _ prepare () in library / Zend / Db / Statement.php at line 115 Zend_Db_Statement -> __ construct () in library / Zend / Db / adapter / Mysqli.php at line 381 Zend_Db_Adapter_Mysqli-> prepare () in library / Zend / Db / adapter / Abstract.php at line 478 Zend_Db_Adapter_Abstract-> query () in library / Zend / Db / adapter / Abstract.php at line 574 Zend_Db_Adapter_Abstract-> insert () in Library / XenForo / DataWriter.php at line 1624 XenForo_DataWriter -> _ insert () in Library / XenForo / DataWriter.php at line 1613 XenForo_DataWriter -> _ save () in Library / XenForo / DataWriter.php at line 1405 XenForo_DataWriter-> save () in vault / core / Controller / install / common / xf.php at line 584 vw_Install_Common_Controller_XF-> update_bbcodes () in vault / core / Controller / install / common / vw.php at line 239 vw_Install_Common_Controller-> do_bbcode () in vault / core / Controller / install / UpgradePath / steps / final / xf.php at line 94 vw_Install_UpgradePath_Steps_Final_Controller_XF -> {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 361 vw_CP_Install_Controller-> exec_step () in vault / core / Controller / cp / install / vw.php at line 292 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 / Controller Admin / Wiki.php at line 113 vw_XenForo_ControllerAdmin_Wiki-> action index () in Library / vw / XenForo / Controller Admin / Wiki.php at line 170 vw_XenForo_ControllerAdmin_Wiki-> Action upgrade () in Library / XenForo / FrontController.php at line 351 XenForo_FrontController-> dispatch () in Library / XenForo / FrontController.php at line 134 XenForo_FrontController-> run () in line 13 at admin.php

About a speedy assistance I am very pleased.

Thanks in advance.

Issue Details

Issue Number 4407

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.7

Fixed Version 4.0.7

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags error, Server Errors, upgrade

November 1, 2015 9:20 AM
pegasus

VaultWiki Team
It sounds like it skipped the step that makes xf_bb_code.vw_extra. I'm not sure why it would do that. Try running this query:

Code:

ALTER TABLE xf_bb_code ADD vw_extra TEXT NULL CHARACTER SET utf8 COLLATE utf8_general_ci
Reply
November 1, 2015 10:47 AM
AlexL777

Junior Member
Hello,

when I run this SQL command to the database, I get this error appears:

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

How can you do better? I have on the server PHP 5.4 / 5.5 and the latest version of MySQL. Thank You!
Reply
November 1, 2015 11:12 AM
pegasus

VaultWiki Team
Okay, it wants them in a different order for some undocumented reason. Use this:

Code:

ALTER TABLE xf_bb_code ADD vw_extra TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL

I am updating the ZIP now.
Reply
November 1, 2015 11:28 AM

AlexL777

Junior Member

OK, this has helped, thank you very much. I still have A Question and although I see behind this URL /admin.php?wiki/ right only a white page and in the left column shows the settings from VaultWiki.

Does it have to be the right way or is missing something? I'll show you here again in the screenshot, and perhaps you can answer me. Many thanks.

Reply
November 1, 2015 11:47 AM

AlexL777

Junior Member

Has done and I again performed the upgrade. Now it's complete. Thank you.

Reply

+ Reply

All times are GMT -4. The time now is 7: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: Error Upgrade VaultWiki 4.0.6 to 4.0.7

Issue Tools