• 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
    • Database error on new 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: Database error on new install

    • Issue Tools
      • View Changes
    1. issueid=925 October 31, 2009 4:56 PM
      Hostboard Hostboard is offline
      Junior Member
      Database error on new install

      Just upgraded one site and no problems. Purchase a new premium subscription for another site went to install and boom...

      Code:
      Database error in vBulletin 3.8.4:
      
      Invalid SQL:
      
      	ALTER TABLE mmvault_category
      	DROP INDEX title,
      	ADD INDEX categoryid (categoryid);
      
      MySQL Error   : Duplicate key name 'categoryid'
      Error Number  : 1061
      Request Date  : Saturday, October 31st 2009 @ 01:53:23 PM
      Error Date    : Saturday, October 31st 2009 @ 01:53:23 PM
      Script        : http://www.MyDomain.org/forums/admincp/plugin.php?do=productimport
      Referrer      : http://www.MyDomain.org/forums/admincp/plugin.php?do=productadd
      IP Address    : 75.60.109.195
      Username      : MyUSerID
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.1.33-community-log
    Issue Details
    Issue Number 925
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Categories
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 2.5.6
    Fixed Version 2.5.7
    Milestone VaultWiki 3.0.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. November 1, 2009 1:11 AM
      pegasus pegasus is offline
      VaultWiki Team
      Thanks. The installer is supposed to ignore the error if it occurs. You should be able to download the latest version again and re-import.
      Reply Reply  
    2. This petition for a change to Awaiting Feedback was accepted
      November 1, 2009 12:41 PM
      Hostboard Hostboard is offline
      Junior Member
      Nope downloaded: ces_spec_cat_2-0-3.zip at 12:39pm EST 11.01.09

      Uploaded all the files, imported the XML and boom it went again


      Code:
      Database error in vBulletin 3.8.4:
      
      Invalid SQL:
      
      	ALTER TABLE mmvault_category
      	ADD COLUMN title_lower VARCHAR(255) NOT NULL DEFAULT '',
      	DROP INDEX undupify,
      	ADD INDEX title_lower (title_lower);
      
      MySQL Error   : Can't DROP 'undupify'; check that column/key exists
      Error Number  : 1091
      Request Date  : Sunday, November 1st 2009 @ 09:38:17 AM
      Error Date    : Sunday, November 1st 2009 @ 09:38:17 AM
      Script        : http://www.MyDomain.org/forums/admincp/plugin.php?do=productimport
      Referrer      : http://www.MyDomain.org/forums/admincp/plugin.php?do=productadd
      IP Address    : 75.60.109.195
      Username      : MyID
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.1.33-community-log
       
    3. November 1, 2009 12:56 PM
      pegasus pegasus is offline
      VaultWiki Team
      Looks like there was hardly any error suppression on anything... so I've added it.

      Download again. All you should have to do is import the XML.
      Reply Reply  
    4. This petition for a change to Fixed was accepted
      November 1, 2009 1:15 PM
      Hostboard Hostboard is offline
      Junior Member
      That did the trick.

      Thank you!
       
    + 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 8: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.