Issue: Upgrading to 4.0.6 error

Issue Tools
- View Changes

October 9, 2015 4:04 PM

rizwank

New Member

Upgrading to 4.0.6 error

had a

Code:

Updating data in table: xf_tag_content
An exception occurred: Database Error: SELECT routeid,tag FROM `vw_tagged` ORDER BY routeid ASC, tag ASC LIMIT 0,500 Mysqli prepare error: Table 'chat_xenforo.vw_tagged' doesn't exist in /var/www/html/forum/vault/core/controller/db/xf.php on line 171

refreshed, seemed fine

Code:

Updating data in table: xf_bb_code
An exception occurred: Database Error: UPDATE `xf_bb_code` `x` LEFT JOIN `vw_bbcode` `v` ON (`x`.`vw_varname` = `v`.`varname`) SET `x`.`vw_options` = `v`.`vw_options` WHERE `v`.`varname` IS NOT NULL Mysqli prepare error: Table 'chat_xenforo.vw_bbcode' doesn't exist in /var/www/html/forum/vault/core/controller/db/xf.php on line 171

cannot move past.

scanning the code, I can't find a good CREATE statement

1. What can I do to finish the upgrade?
2. Since we have a problem on literally every upgrade; is there a way of checking the schema for something out of date or sending you the schema for validation?

Issue Details

Issue Number 4396

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.6

Fixed Version 4.0.7

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)

October 10, 2015 12:55 AM

rizwank

New Member

Tried to skip step 5 to get my users back online.

failed again at step 7

Code:

Updating data in table: xf_tag_content
An exception occurred: Database Error: SELECT routeid,tag FROM `vw_tagged` ORDER BY routeid ASC, tag ASC LIMIT 0,500 Mysqli prepare error: Table 'chat_xenforo.vw_tagged' doesn't exist in /var/www/html/forum/vault/core/controller/db/xf.php on line 171

After that, seems to work.

so looks like vw_tagged and vw_bbcode are missing..?

what should I do now to clean up.

October 10, 2015 9:53 AM

pegasus

VaultWiki Team

vw_tagged and vw_bbcode are dropped after the upgrade to 4.0.6, and the point of these steps is just to copy the data from those tables somewhere else before that happens. So if they are already missing, then you have nothing to copy, and I suppose nothing to worry about.

It seems somehow you finished upgrading to 4.0.6 (maybe another day last week), but then went back today and tried to do it again. I am not even aware how that would be possible, since vw_upgradelog records what step you last completed and changes the step numbers so step 1 is always the next step that wasn't completed yet. Since you are the only user who has encountered this and otherwise 4.0.6 has been a smooth upgrade for people, I think the only thing we can really do is wrap these steps so they don't run if these tables are missing. This was something we noted about 4.0.4, so I'm surprised some steps in 4.0.6 were overlooked.

Otherwise, I see that it is possible to be missing vw_tagged on XenForo, but not vw_tagged and vw_bbcode at the same time unless the above is true (or they were manually removed). In order to be missing vw_tagged, you would have to have installed VaultWiki 4.0.0 Beta 3 or lower, and then have upgraded. It seems the step that creates vw_tagged in 4.0.0 Beta 4 was not successful in XenForo at the time.

I don't think you need to clean anything up, but check your XenForo BB-Codes, and make sure the VaultWiki-related ones have desirable "Wiki Options" settings.

Reply

+ Reply

All times are GMT -4. The time now is 7:38 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: Upgrading to 4.0.6 error

Issue Tools