• 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
    • Wanted Category DB error

    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: Wanted Category DB error

    • Issue Tools
      • View Changes
    1. issueid=740 July 29, 2009 9:28 AM
      mickknutson mickknutson is offline
      Regular Member
      Wanted Category DB error

      I clicked on:

      http://www.blincmagazine.com/forum/w...ntedcategories

      and got:
      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      
      		SELECT COUNT(DISTINCT(title_lower)) AS rowcount
      		FROM vault_link AS link
      		LEFT JOIN vault_protect AS protect ON (link.title_lower = protect.title_lower AND link.namespace = protect.namespaceid AND protect.options = 4)
      		WHERE namespace = 6
      			AND link.targetid = 0
      			AND templateusage = 1
      			AND protectid IS NULL;
      
      MySQL Error   : Column 'title_lower' in field list is ambiguous
      Error Number  : 1052
      Request Date  : Wednesday, July 29th 2009 @ 06:27:24 AM
      Error Date    : Wednesday, July 29th 2009 @ 06:27:24 AM
      Script        : http://www.blincmagazine.com/forum/wiki/Special:Wantedcategories
      Referrer      : http://www.blincmagazine.com/forum/wiki/Special:Specialpages
      IP Address    : 198.140.4.205
      Username      : mknutson
      Classname     : vB_Database
      MySQL Version : 5.0.45
    Issue Details
    Issue Number 740
    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)


    Page 2 of 2 FirstFirst Previous 12


    1. August 18, 2009 6:08 AM
      Jella Jella is offline
      Regular Member
      Thanks for fixing this.

      I don't know what a TRUNCATE command or any command is and never run anything in the database, don't know how to... I don't think the database crashed, only the issues after the Wiki upgrade which seem to be all fixed now.

      I received the SPECIALS error emails with that problem...

      could this have caused it?
      Code:
      Invalid SQL:
      
                     SELECT COUNT(DISTINCT(title_lower)) AS rowcount
                     FROM vault_link AS link
                     LEFT JOIN vault_protect AS protect ON (link.title_lower = protect.title_lower AND link.namespace = protect.namespaceid AND protect.options = 4)
                     WHERE namespace = 6
                             AND link.targetid = 0
                             AND templateusage = 0
                             AND protect.protectid IS NULL;
      
      MySQL Error   : Column 'title_lower' in field list is ambiguous
      Error Number  : 1052
      Request Date  : Thursday, August 13th 2009 @ 07:24:08 PM
      Error Date    : Thursday, August 13th 2009 @ 07:24:09 PM
      Script        : http://tvlampforum.com/showwiki.php?lampwiki=Special:Wantedpages
      Referrer      : http://tvlampforum.com/showwiki.php?lampwiki=Special:Specialpages
      IP Address    : 98.229.127.230
      Username      : admin
      Classname     : vB_Database
      MySQL Version : 5.0.81-community
      Reply Reply  
    2. August 19, 2009 4:37 AM
      pegasus pegasus is offline
      VaultWiki Team
      This error would not have caused the type of data loss you incurred. I can't see any way this would happen on that scale. Hopefully, this was an isolated incident, perhaps relating to your recent vBulletin upgrade issues.

      Time will tell.
      Reply Reply  
    3. August 19, 2009 8:54 AM
      Jella Jella is offline
      Regular Member
      Thank you again. I will not update the Forbidden Jiki, I'd have a heart attack. There must be close to 1000 wikis' and books with 70 or more chapters... I can't handle any issues as you know.

      Is it safe (I mean my site won't crash) staying with 2.3 patch level 1 wiki. It operates fine.

      I will not be updating my sites to vbulletin 4 even though I will keep up my supscriptions... unless I have a database corrution that will force me to do it, I have too many hacks running that would need upgrading if in fact the coders upgrade them. I know the major ones will like vbexperience etc...
      Reply Reply  
    4. August 19, 2009 4:52 PM
      pegasus pegasus is offline
      VaultWiki Team
      It is safe to stay with 2.3. That said, we are no longer developing that branch, and you will miss out on any new features or bug fixes. If it works for you, and you can deal without the new features, stick with 2.3.

      Even if you didn't usually have issues upgrading, I would highly recommend doing frequent database backups. This way you're not stuck with lost data should you decide to finally upgrade and there is a problem.
      Reply Reply  
    Page 2 of 2 FirstFirst Previous 12
    + 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:52 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.