• 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
    • Article in multiple categories

    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: Article in multiple categories

    • Issue Tools
      • View Changes
    1. issueid=734 July 29, 2009 3:32 AM
      tscargo tscargo is offline
      Junior Member
      Article in multiple categories

      I tried to put an article in multiple categories.
      They are all shown on the article page, but only the last category page contains a link to the article. I cannot imagine one can only add a page into one category.

      I am using version 2.00 of the categories plugin. I cannot select that in the menu below.
    Issue Details
    Issue Number 734
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Categories
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 2.5.0
    Fixed Version 2.5.1
    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. July 29, 2009 5:57 PM
      pegasus pegasus is offline
      VaultWiki Team
      In vault/extensions/category/category_functions_ext.php, find:
      Code:
      		WHERE categoryid = " . intval($threadinfo['threadid']) . "
      Replace with:
      Code:
      		WHERE title_lower = '" . $db->escape_string(strtolower($threadinfo['encshort'])) . "'
      If needed (depending when your download was), find:
      Code:
      		WHERE category.title_lower = '" . $db->escape_string($threadinfo['encshort']) . "'
      Replace with:
      Code:
      		WHERE category.title_lower = '" . $db->escape_string(strtolower($threadinfo['encshort'])) . "'
      Reply Reply  
    2. July 29, 2009 6:36 PM
      tscargo tscargo is offline
      Junior Member
      This does not make any difference. Had to replace both instances....
      Reply Reply  
    3. July 29, 2009 6:56 PM
      pegasus pegasus is offline
      VaultWiki Team
      There is currently a unique index in the database that interferes with new categories. Run the following query on your database.
      Code:
      ALTER TABLE vault_category
      DROP INDEX undupify,
      ADD INDEX categoryid (categoryid)
      Reply Reply  
    4. July 29, 2009 7:01 PM
      tscargo tscargo is offline
      Junior Member
      Get an error:

      Code:
      Error
      SQL query:
      
      ALTER TABLE vault_category DROP INDEX undupify,
      ADD INDEX threadid( threadid ) ,
      ADD INDEX categoryid( categoryid )
      
      MySQL said: 
      
      #1061 - Duplicate key name 'threadid'
      Reply Reply  
    5. July 29, 2009 7:09 PM
      tscargo tscargo is offline
      Junior Member
      I removed all categories from all articles and added them again. Now the category-links work.
      Reply Reply  
    6. July 29, 2009 7:51 PM
      pegasus pegasus is offline
      VaultWiki Team
      Okay, since the threadid index was already there, you can remove that line from the query as I have edited in my post above.
      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 9:13 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.