• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Lite
    • Bug
    • StyleVar on vBulletin Missing After Install

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: StyleVar on vBulletin Missing After Install

    • Issue Tools
      • View Changes
    1. issueid=2920 January 11, 2013 12:51 PM
      Skylab Skylab is offline
      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)




    1. January 11, 2013 1:10 PM
      Skylab Skylab is offline
      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 Reply  
    2. January 11, 2013 1:25 PM
      pegasus pegasus is offline
      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 Reply  
    3. January 11, 2013 6:24 PM
      Skylab Skylab is offline
      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&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
      Reply Reply  
    4. January 11, 2013 10:52 PM
      pegasus pegasus is offline
      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 Reply  
    5. January 11, 2013 11:17 PM
      pegasus pegasus is offline
      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 Reply  
    6. January 13, 2013 4:20 PM
      Skylab Skylab is offline
      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
      Reply Reply  
    7. January 14, 2013 12:56 AM
      pegasus pegasus is offline
      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 Reply  
    8. January 14, 2013 9:09 AM
      Skylab Skylab is offline
      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 Reply  
    9. January 14, 2013 11:19 AM
      Skylab Skylab is offline
      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
      Reply Reply  
    10. January 14, 2013 2:46 PM
      pegasus pegasus is offline
      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')
      Reply Reply  
    11. January 30, 2013 7:24 PM
      Skylab Skylab is offline
      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
      Reply Reply  
    12. January 31, 2013 3:04 AM
      pegasus pegasus is offline
      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  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.