• 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 WHILE SEARCHING

    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 WHILE SEARCHING

    • Issue Tools
      • View Changes
    1. issueid=1641 June 2, 2010 7:41 PM
      Claw Snuff Claw Snuff is offline
      VaultWiki Team
      DATABASE ERROR WHILE SEARCHING

      When searching the forums, I encountered the following database error.
      Code:
      Database error in vBulletin 4.0.3:
      
      Invalid SQL:
      
      				SELECT searchgroup.searchgroupid , searchgroup_text.title
      				FROM forum_searchgroup AS searchgroup
      			 INNER JOIN forum_thread AS thread ON (
      				searchgroup.contenttypeid = 2  AND searchgroup.groupid = thread.threadid)
       INNER JOIN forum_post AS post ON (
      				thread.threadid = post.threadid AND searchcore.primaryid = post.postid AND post.parentid = 0)
      JOIN forum_searchgroup_text AS searchgroup_text ON (searchgroup_text.searchgroupid = searchgroup.searchgroupid)
      
      WHERE MATCH(searchgroup_text.title) AGAINST ('apple') AND thread.forumid IN ('97','140','99','149','81','103','135','80','111','101','143','104','134','234') AND searchgroup.contenttypeid IN ('2') LIMIT 500;
      
      MySQL Error   : Unknown column 'searchcore.primaryid' in 'on clause'
      Error Number  : 1054
      Request Date  : Wednesday, June 2nd 2010 @ 05:39:01 PM
      Error Date    : Wednesday, June 2nd 2010 @ 05:39:02 PM
      Script        : http://www.vaultwiki.org/search.php?do=process
      Referrer      : http://www.vaultwiki.org/search.php?search_type=1
      IP Address    : 96.246.226.120
      Username      : Claw Snuff
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.1.46-log
      
      Stack Trace:
      
      #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1308
      #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 468
      #2 vB_Database->query_read_slave() called in [path]/packages/vbdbsearch/coresearchcontroller.php on line 701
      #3 vBDBSearch_CoreSearchController->get_query_results() called in [path]/packages/vbdbsearch/coresearchcontroller.php on line 123
      #4 vBDBSearch_CoreSearchController->get_results() called in [path]/vb/search/results.php on line 51
      #5 vB_Search_Results::create_from_criteria() called in [path]/search.php on line 350
      #6 require([path]/search.php) called in [path]/vbseo.php on line 1382
    Issue Details
    Issue Number 1641
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Searching
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 3.0.0 RC 3
    Fixed Version 3.0.0
    Milestone VaultWiki 3.0.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users Claw Snuff
    Tags (none)




    1. June 3, 2010 7:04 PM
      pegasus pegasus is offline
      VaultWiki Team
      Fixed for the next build. This only occurs when selecting 'Wiki Content Pages' as the content type for search and then selecting 'Search Titles Only'. The vBulletin search is still flawed on its own (which is why 'apple' throws a false negative, I believe), but this database error will be avoided.
      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 5:21 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.