• 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
    • SQL-Error when opening a category

    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: SQL-Error when opening a category

    • Issue Tools
      • View Changes
    1. issueid=745 July 31, 2009 10:50 PM
      Storyteller Storyteller is offline
      Junior Member
      SQL-Error when opening a category

      I just updated my live-forum to 2.5.0 and categorys to 2.0.0 and now i get a database-error when trying to open a category:
      Code:
      Datenbankfehler in vBulletin 3.8.3:
      
      Invalid SQL:
      
      		SELECT COUNT(threadid) AS rowcount
      		FROM vb_3vault_category
      		WHERE title_lower = 'sonstiges';
      
      MySQL-Fehler  : Unknown column 'title_lower' in 'where clause'
      Fehler-Nr.    : 1054
      opening categorys from specialpages:
      Code:
      Datenbankfehler in vBulletin 3.8.3:
      
      Invalid SQL:
      
      		SELECT COUNT(category.threadid) AS rowcount
      		FROM vb_3vault_category AS category
      		LEFT JOIN vb_3thread AS thread ON (thread.threadid = category.categoryid)
      		WHERE thread.forumid IN (NULL,110)
      		GROUP BY category.title_lower;
      
      MySQL-Fehler  : Unknown column 'category.title_lower' in 'group statement'
      I download the zip-packages today.
    Issue Details
    Issue Number 745
    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. August 1, 2009 12:52 AM
      pegasus pegasus is offline
      VaultWiki Team
      I removed the error suppression from the package in hopes that vBulletin will display the conflict, so download the categories zip again. In AdminCP -> Plugins & Products -> Product Manager, find "CES VaultWiki Categories" and edit its version number to "1.9.9". Then upload the product-xml from the newly downloaded zip.
      Reply Reply  
    2. August 1, 2009 3:36 AM
      Storyteller Storyteller is offline
      Junior Member
      Now they are back and working so far
      Thanks!
      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 10:12 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.