• 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 Series
    • Bug
    • Revision DB Error editing a page

    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: Revision DB Error editing a page

    • Issue Tools
      • View Changes
    1. issueid=1731 June 20, 2010 8:45 PM
      mickknutson mickknutson is offline
      Regular Member
      Revision DB Error editing a page

      I just tried to edit an existing page, I get this error:

      Code:
      tabase error in vBulletin 4.0.4:
      
      Invalid SQL:
      INSERT INTO vault_revision
      	(forumid, threadid, dateline, iconid, pagetext, userid, ipaddress, title, reason, minor, section, attach, pending, htmlstate, prefixid, unzip, lastrevisionid)
      VALUES
      	(78, 36413, 1277080997, 4, 'jVRha+Q2EP0eyH8Y3C9tCXZbyn0oLGU33aTb7i0l3hI4IYJsj9fqypKxxrvno1/7vzuSnVz2CKUQiFfSPL1572nE7Xq3Xz9IsZKPaErXIpADalBkK3l9JfLNh/XiXdjerR9htczX8KiPOuyKLGyGQ9kMcn11fbWpuVp74L/RDT3UuvcEJ+013YAn1RMUI/SoKm0P4SKonTHuzL/+gQAgil4K3aoDSn8cjEn/6g5/f//Dd91HkU3LIuMjfHC7yffh/7dyovmjXJYldhRRmbH4RfvSKN0iIzLh9DPjzyUPeNJ4nko2oU/x58N2kTRE3U9Z5jujaDAqZWWyojZZIqMGd4qU0TTCVnN3X6/utt+IjAvlJMxGgrIViMfN7xv5cjYnRXxcl15kcedNQjtHoMAfx0qfsIcR6We4d3BB63w+p1Xvuk/OYqTmVY00ZltUvX0i95RP5Zm2FX5MfUOtSWSrjgg+WDyj+4nz5NGbZPYN2mhW1FPcI1GwTVsOSRBChh4uojCbcuEjnpwZSDubdvZ/e5nHrJw1NSBKRXhw/bhI7tFir7iZ+UNkz3sSNrZ2favCRTOh9AIxqgOqcANNSf5taLvQjjhzpBfJnpNitMVE/so2MaTIwoZ8S5i55AFL11c+kfNHtH1ZNhpP2KIl/x8QOeIUu8K54yLZBKu+IlUYfHL1U+ksBYBE7sMSuBpu5yXWjCui2l/KPr2gZ44rGUp6XQyEFzbdIRqoe4yP3aA6IXCKImFQ0/spHJFrw7UKOnbqBlwPBcYJoSwIsa40a+TlFPWyUfYw9aNKGpSB5wZSWNoRVlu9u4V86DrXE8e6ZAxkBKhcOcSLb4BpBoCRTTcGDkjQuopNJqz4ZvYWoRsKo33DpqWvO+WvVbCAcWYm/lW/LAq8GkuKA00DJ2EeSiHZ/PJ9h6VWJnrKODNMIkujyyM02LOE8xkJ4YmHG1g+zyqeG1bttSRNkLSPQGacKVUTZbGMAQxK7XjwvIxUKeN+7uJ7u5lUfbFvnsrAgJp1iFW3bNlgebKkaQj6fv3+j+1yv5a1cyyxyF4W/gU=', 1, '71.123.48.157', 'Index', '', 0, '', 0, 0, 'on_nl2br', '', 1, 1576);
      
      MySQL Error   : Unknown column 'htmlstate' in 'field list'
      Error Number  : 1054
      Request Date  : Sunday, June 20th 2010 @ 05:43:17 PM
      Error Date    : Sunday, June 20th 2010 @ 05:43:17 PM
      Script        : http://www.blincmagazine.com/forum/wiki/BASE_Wiki:Index?do=edit
      Referrer      : http://www.blincmagazine.com/forum/wiki/BASE_Wiki:Index?do=edit
      IP Address    : 71.123.48.157
      Username      : xxx
      Classname     : vB_Database
      MySQL Version : 5.1.48
    Issue Details
    Issue Number 1731
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 3.0.0
    Fixed Version 3.0.1
    Milestone VaultWiki 3.0.5
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. June 20, 2010 8:59 PM
      pegasus pegasus is offline
      VaultWiki Team
      If you upgraded from vBulletin 3.8 to vBulletin 4 AFTER upgrading from VaultWiki 2.5 to VaultWiki 3, then you need to run the VaultWiki upgrade script again to get the vBulletin 4 integrations.
      Reply Reply  
    2. June 21, 2010 5:38 AM
      mickknutson mickknutson is offline
      Regular Member
      the vb 4 upgrade was 1st. Should I still rerun the vault upgrade again anyways?
      Reply Reply  
    3. June 21, 2010 12:02 PM
      pegasus pegasus is offline
      VaultWiki Team
      Yes, go to upgrade.php and see if it redirects you to another upgrade step. You missed upgrade_4x300rc2.php (at least). I am looking into it now.
      Reply Reply  
    4. June 22, 2010 7:09 PM
      mickknutson mickknutson is offline
      Regular Member
      I re-ran the upgrade.php, but when I went back to edit, I got the same error.
      Reply Reply  
    5. June 22, 2010 11:05 PM
      pegasus pegasus is offline
      VaultWiki Team
      Can you please post the contents of your database table vault_upgradelog (there should be 3-4 short rows)?

      You can fix editing capability in the mean time by running the following query against your database:
      Code:
      ALTER TABLE vault_revision
      ADD htmlstate ENUM('off', 'on', 'on_nl2br') DEFAULT 'on_nl2br'
      Reply Reply  
    6. June 23, 2010 4:36 AM
      pegasus pegasus is offline
      VaultWiki Team
      Figured this out. The step was run but the query died silently because of a wrapper vB was adding to already wrapped code. This has been fixed in the current ZIP. Affected users can run the aforementioned script again, the query in the previous post, or wait until the next release to be patched.
      Reply Reply  
    7. June 23, 2010 5:57 AM
      mickknutson mickknutson is offline
      Regular Member
      Quote Originally Posted by pegasus View Post
      Can you please post the contents of your database table vault_upgradelog (there should be 3-4 short rows)?

      You can fix editing capability in the mean time by running the following query against your database:
      Code:
      ALTER TABLE vault_revision
      ADD htmlstate ENUM('off', 'on', 'on_nl2br') DEFAULT 'on_nl2br'
      Upgrade log:

      Code:
      3X	3.0.0
      4X	3.0.0 RC 2
      3P	3.0.0
      4P	3.0.0 Beta 3
      But the SQL you had me run worked. Tested and we are good!
      Thanks much!
      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 12: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
  • 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.