Issue: StyleVar on vBulletin Missing After Install

Issue Tools
- View Changes

January 11, 2013 12:51 PM

Skylab

Junior Member

StyleVar on vBulletin Missing After Install

StyleVar Editor options missing

Shortly after installing VaultWiki, my StyleVar options have disappeared. This comes at a pretty bad time (as it usually does) and need to get this resolved ASAP.

Uninstalled VaultWiki causes a database error.

Here's a screen shot: http://cl.ly/image/2e2F2I0X0e3q

Issue Details

Issue Number 2920

Issue Type Bug

Project VaultWiki 3.x Lite

Category Unknown

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version Unknown

Fixed Version (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

January 11, 2013 1:10 PM

Skylab

Junior Member

Not sure what happened there or whether it was VaultWiki at all. I put in tools.php file from vBulletin and rebuilt the Master Style. Works now.

Reply
January 11, 2013 1:25 PM

pegasus

VaultWiki Team

Is this for VaultWiki or VaultWiki Lite? You are not showing as licensed here, and the two products are very different coding wise.

Reply

January 11, 2013 6:24 PM

Skylab

Junior Member

Sorry. It's for VaultWiki Lite.

So I'm trying to do a new install but I'm getting this

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

					UPDATE session
					SET lastactivity = 1357946556, location = '/forum/vault/install/finalupgrade.php?step=5&amp;startat=10', badlocation = 0, useragent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.101 Safari/537.11 AlexaToolbar/alxg-3.1', inwiki = 'a:0:{}'
					WHERE sessionhash = '49e108eda470b557937878273b4596df';

MySQL Error   : Unknown column 'inwiki' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 11th 2013 @ 05:22:36 PM
Error Date    : Friday, January 11th 2013 @ 05:22:36 PM
Script        : http://travelblogsuccess.com/forum/vault/install/finalupgrade.php?step=5&startat=10
Referrer      : http://travelblogsuccess.com/forum/vault/install/finalupgrade.php?step=5
IP Address    : 50.29.130.221
Username      : Michael
Classname     : vB_Database
MySQL Version : 5.0.96-community

January 11, 2013 10:52 PM

pegasus

VaultWiki Team

VaultWiki Lite was not uninstalled correctly and thus cannot be installed correctly. What was the database error you had when you uninstalled?

Reply
January 11, 2013 11:17 PM
pegasus

VaultWiki Team
The original bug you reported is a bug in vBulletin, already noted here: https://www.vaultwiki.org/issues/2857/

It can be fixed by modifying includes/adminfunctions_template.php. Find:

Code:

xml_import_stylevar_definitions($parsed_xml['stylevardfns'], 'vbulletin', $master ? -1 : -2);

Replace with:

Code:

xml_import_stylevar_definitions($parsed_xml['stylevardfns'], $product, $master ? -1 : -2);

I don't know if they are aware of the bug or if they plan to fix it. Perhaps if more users report/upvote it, they will.

This bug does not exist in the non-Lite version of VaultWiki since it relies less on built-in vBulletin functions for installation.

Still I have updated the Lite depot with a custom version of the vB function to avoid this problem in the next Lite release.
Reply

January 13, 2013 4:20 PM

Skylab

Junior Member

Thanks for the fix.

Here's the error I get when trying to uninstall.

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

	SELECT *
	FROM vault_upgradelog;

MySQL Error   : Table 'tbs_forum.vault_upgradelog' doesn't exist
Error Number  : 1146
Request Date  : Sunday, January 13th 2013 @ 03:19:29 PM
Error Date    : Sunday, January 13th 2013 @ 03:19:30 PM
Script        : http://travelblogsuccess.com/forum/admincp/plugin.php?do=productkill
Referrer      : http://travelblogsuccess.com/forum/admincp/plugin.php?do=productdelete&productid=ces_nwsp_spec&s=
IP Address    : 50.29.130.221
Username      : Michael
Classname     : vB_Database
MySQL Version : 5.0.96-community

January 14, 2013 12:56 AM

pegasus

VaultWiki Team

That error only occurs if you already ran the uninstall script and are trying to uninstall again. You need to check your logs for the original error that halted your first uninstall attempt. Like I do every time someone reports uninstall problems, I have uninstalled a default installation of VaultWiki Lite, and again I have encountered no problems. It's possible you can encounter issues if:
1. You had an older version of VaultWiki Lite installed
2. Upload the new version because you wish to upgrade
3. Forget to run the upgrade script
4. See errors on your site due to #3
5. Attempt to uninstall VaultWiki Lite
6. The uninstall fails because you are using the uninstall file for a version that you don't currently have installed, because of #3
7. Database is corrupted and you are unable to uninstall or reinstall VaultWiki Lite

The only way to correct this problem is to open the vault/tools/uninstall.php file and look at the code for a list of changes it would make to your database. Using phpmyadmin or a similar server admin tool, manually make the changes. Only if ALL changes are made properly will you be able to successfully reinstall VaultWiki Lite (or VaultWiki, for that matter).

Reply
January 14, 2013 9:09 AM

Skylab

Junior Member

Would it be too much trouble to provide the exact line to run on phpmyadmin to drop any tables that involve VaultWiki?

1. I did not have another version of VaultWiki installed.
2,3,4,6: It was not an upgrade.
5. Attempt? Should it not be uninstalled?
7. Nope.

While I understand that your default installation of VaultWiki Lite works fine, not everyone has the same configuration as you do.

My steps were as follows:
1. Installed VaultWiki
2. StyleVar went missing.
3. Attempted to uninstall Vaultwiki but received database error.
4. Ran tools script provided by vBulletin

It could be that VaultWiki itself has little to do with why it failed to install and uninstall but it probably shouldn't be ignored either.

Thank you for your help.

Reply

January 14, 2013 11:19 AM

Skylab

Junior Member

What a disaster.
Can't even use Navigation Manager

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:44:{s:14 Super long list

MySQL Error   : Unknown column 'phrasegroup_vaultnamespace' in 'field list'
Error Number  : 1054
Request Date  : Monday, January 14th 2013 @ 10:16:23 AM
Error Date    : Monday, January 14th 2013 @ 10:16:23 AM
Script        : http://travelblogsuccess.com/forum/admincp/navigation.php?do=doedit
Referrer      : http://travelblogsuccess.com/forum/admincp/navigation.php?do=edit&navid=59
IP Address    : 50.29.130.221
Username      : Michael
Classname     : vB_Database
MySQL Version : 5.0.96-community

January 14, 2013 2:46 PM

pegasus

VaultWiki Team

It's possible the database error you originally encountered had to do with the stylevars being missing and not running the tools script first to restore that part of the database. Since you haven't been able to find the original database error, we can't be very helpful with respect to why it happened or how to prevent it from happening in the future.

However, the uninstall file is quite readable, but here is what you need to do translated into usable MySQL queries. Do each one individually, because it's very likely most of them will fail. If any one fails, it should be because it was already removed, so just move on to the next one:

Code:

DROP TABLE IF EXISTS vault_revision

DROP TABLE IF EXISTS vault_article

DROP TABLE IF EXISTS vault_namespace

DROP TABLE IF EXISTS vault_list

DROP TABLE IF EXISTS vault_upgradelog

ALTER TABLE usergroup DROP vault_permissions

ALTER TABLE language DROP phrasegroup_vaultarticles

ALTER TABLE language DROP phrasegroup_vaultadmin

ALTER TABLE language DROP phrasegroup_vaultstyle

ALTER TABLE language DROP phrasegroup_vaultnamespace

ALTER TABLE style DROP wiki_css

ALTER TABLE forum DROP vault_type

ALTER TABLE forum DROP vault_lastthread

ALTER TABLE forum DROP vault_lastedit

ALTER TABLE session DROP inwiki

DELETE FROM bbcode WHERE bbcodetag IN ('redirect', 'comment', 'h', 'footnote', 'reflist', 'toc', 'table', 'hr', 'wiki')

DELETE FROM adminmessage WHERE varname LIKE 'vault_changes_%'

DELETE FROM phrasetype WHERE fieldname IN ('vaultarticles', 'vaultadmin', 'vaultstyle', 'vaultnamespace')

January 30, 2013 7:24 PM

Skylab

Junior Member

I've removed everything from what you've suggested but I still can not uninstall the product. So I tried to reinstall VaultWiki but it's being recognized as an upgrade. When reinstalling, it gives me an error at Step 2

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

					UPDATE session
					SET lastactivity = 1359591769, location = '/forum/vault/install/finalupgrade.php?step=2', badlocation = 0, useragent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.56 Safari/537.17 AlexaToolbar/alxg-3.1', inwiki = 'a:0:{}'
					WHERE sessionhash = '11075d6bc6c42e4c51d2a94096dafc14';

MySQL Error   : Unknown column 'inwiki' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, January 30th 2013 @ 07:22:49 PM
Error Date    : Wednesday, January 30th 2013 @ 07:22:49 PM
Script        : http://travelblogsuccess.com/forum/vault/install/finalupgrade.php?step=2
Referrer      : http://travelblogsuccess.com/forum/vault/install/finalupgrade.php?step=1
IP Address    : 71.163.81.253
Username      : Michael
Classname     : vB_Database
MySQL Version : 5.0.96-community

January 31, 2013 3:04 AM

pegasus

VaultWiki Team

You have to make sure VaultWiki no longer appears in your Product Manager, or it will count as an upgrade. You can remove it manually by deleting the uninstall code from the Product Manager (you already removed that stuff manually per my previous instructions), and then clicking uninstall.

Reply

+ Reply

All times are GMT -4. The time now is 5:38 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: StyleVar on vBulletin Missing After Install

Issue Tools