Issue: Upgrade namespace issue error

Issue Tools
- View Changes

May 21, 2010 2:22 PM

Jella

Regular Member

Upgrade namespace issue error

Upgrade stopped right before completed with a database error

I was having this same error prior to upgrade where the Special page Protected Pages would lead to this error. It seemed to have disappeared, so I thought the upgrade would fix it, wrong... Did this have something to do with vbet premium language mod?

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT thread.threadid, thread.title, thread.forumid, prot.protectid
, thread.prefixid
, art.languageid
FROM thread AS thread
LEFT JOIN vault_protect AS prot ON (prot.targetid = thread.threadid)
INNER JOIN vault_article AS art ON (art.threadid = thread.threadid)
WHERE forumid IN (25)
ORDER BY thread.threadid ASC
LIMIT 0,200;

MySQL Error : Unknown column 'art.languageid' in 'field list'
Error Number : 1054
Request Date : Friday, May 21st 2010 @ 10:32:39 AM
Error Date : Friday, May 21st 2010 @ 10:32:39 AM
Script : http://tvlampforum.com/vault/install...0b6.php?step=2
Referrer : http://tvlampforum.com/vault/install...0b6.php?step=1
IP Address : xx.xxx.xxx.xx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.90-community

Issue Details

Issue Number 1588

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0 RC 3

Fixed Version 3.0.0

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 1

Assigned Users (none)

Tags (none)

May 21, 2010 5:10 PM
pegasus

VaultWiki Team
This occurs if the user was not already upgraded to VaultWiki 3 Beta 5 when they decided to upgrade to a version after Beta 5.

This has been fixed for the next build by making sure the upgrader upgrades evenly. That is, the previous behavior was:

Upgrade VaultWiki Standard all the way to the current version.
Upgrade VaultWiki Premium elements all the way to the current version.
Upgrade VaultWiki Standard vB4 elements all the way to the current version.
Upgrade VaultWiki Premium vB4 elements all the way to the current version.

The new, correct behavior will be:

Upgrade VaultWiki Standard only to the next version.
Upgrade VaultWiki Premium elements only to the next version.
Upgrade VaultWiki Standard vB4 elements only to the next version.
Upgrade VaultWiki Premium vB4 elements only to the next version.
Repeat from step 1 until the current version is reached.

If you need to perform a pre-Beta 5 upgrade before the next release, download the Beta 5 ZIP first, upgrade, then download the newest ZIP, and upgrade again.
Reply
This petition for a change to Awaiting Feedback was rejected
May 21, 2010 5:27 PM
Jella

Regular Member
Did you get my PM? I reverted the templates and now there are errors such as if you go to any wiki page this is showing at the top of evey wiki pages
 
example http://tvlampforum.com/showwiki.php?...=Special:Books

Island Special page error http://tvlampforum.com/showwiki.php?...al:Islandpages

Code:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/tvlamp/public_html/vault/factory/special/islandpages.php on line 45

ShortPages

Code:

Fatal error: Call to undefined method vB_SpecialFactory::filter_namespace_by_permission() in /home/tvlamp/public_html/vault/factory/special/lengthpages.php on line 62

UncategorizedCategories

Code:

Fatal error: Call to a member function filter_namespace_by_permission() on a non-object in /home/tvlamp/public_html/vault/factory/special/uncategorized.php on line 83

Many pages are showing these errors

HELP
May 22, 2010 1:30 AM

pegasus

VaultWiki Team

I am not seeing the IE comments issue on your site. It looks to be correct as far as I'm seeing. If you're still having problems let me know what browser to check, but it may be due to malformed comments in another mod you're using.

As far as the Special page errors, these have been filed under a separate report here: http://www.vaultwiki.org/issues/1590/

Reply
May 22, 2010 10:48 AM

Jella

Regular Member

IE error shows at top when logged into CLOSED board. See image.. only shows at top, yuck.

Reply
May 22, 2010 2:19 PM

pegasus

VaultWiki Team

I can see this issue only when visiting your site in Internet Explorer. I cannot duplicate this on my vB 3.8.4 test board.

When checking the W3C HTML validator, I noticed that your site has quite a lot of broken HTML and other errors. You'll have to fix these issues before it will be possible to diagnose the problem. Please open a new report if the issue persists after making these changes.

Reply
May 22, 2010 2:24 PM

Jella

Regular Member

Its coming from vault_article_main no where else. There is nowhere else that has those tags.

Reply
May 22, 2010 2:32 PM

pegasus

VaultWiki Team

Those are HTML comments and they are validating correctly. Because Internet Explorer has a faulty HTML parser, it is entirely possible that the broken HTML on the rest of the page can be affecting other tags around it and causing them not to work properly. There was a lot of malformed CSS and Javascript from other mods you are using that I attempted to fix, but there's also quite a bit of broken HTML.

Reply
May 22, 2010 2:34 PM

Jella

Regular Member

I see, it wasn't there until I screwed up you upgrade fix by reverting all the templates

Reply
May 22, 2010 3:14 PM

pegasus

VaultWiki Team

Figured it out. Yes, the code is incorrect, but I'm surprised it's appearing as text on the page, as it's still a comment... I apologize for the frustration. However, I still highly recommend addressing the validation issues throughout your site, as this can have a negative effect on search engine rankings.

This issue is fixed here: http://www.vaultwiki.org/issues/1593/

Reply
May 23, 2010 9:33 AM

Jella

Regular Member

Thanks so much.. I will get to fixing it.

Reply

+ Reply

All times are GMT -4. The time now is 11:40 PM.

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 namespace issue error

Issue Tools