• 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
    • Moving Wiki Threads - 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: Moving Wiki Threads - DB error

    • Issue Tools
      • View Changes
    1. issueid=948 November 17, 2009 9:39 AM
      Hostboard Hostboard is offline
      Junior Member
      Moving Wiki Threads - DB error

      Not sure if this is do to the Wiki as I am basing it from the error DELETE FROM vault_revision as a key to what/where caused this.

      Code:
      Database error in vBulletin 3.8.3:
      
      Invalid SQL:
      
              DELETE FROM vault_revision
              WHERE threadid IN ();
      
      MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
      Error Number  : 1064
      Request Date  : Tuesday, November 17th 2009 @ 05:29:38 AM
      Error Date    : Tuesday, November 17th 2009 @ 05:29:39 AM
      Script        : http://www.MyDomain.com/forums/postings.php?do=domovethread&t=190690
      Referrer      : http://www.MyDomain.com/forums/postings.php?t=190690&pollid=
      IP Address    : 208.15.238.3
      Username      : Counts
      Classname    : vB_Database_MySQLi
      MySQL Version :
    Issue Details
    Issue Number 948
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Inline Moderation
    Status Fixed
    Priority 5 - Minor Bugs / Small Tweaks
    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 17, 2009 3:45 PM
      pegasus pegasus is offline
      VaultWiki Team
      I am unable to reproduce this here. For reference, the page action that threw the error is only possible by moving a thread from a non-wiki forum into a wiki forum via Thread Tools, and this tested fine for me. Looking at the code, I also can see no logical reason for the threadid to be empty.

      Perhaps this is a conflict, an isolated issue related to table locking, or a vBulletin issue that was fixed in 3.8.4.
      Reply Reply  
    2. This petition for a change to Awaiting Feedback was accepted
      November 17, 2009 9:54 PM
      Hostboard Hostboard is offline
      Junior Member
      I have wiki setup as a test in 1 forum only. The forum where this error occured does not have a wiki.
       
    3. November 18, 2009 2:42 AM
      pegasus pegasus is offline
      VaultWiki Team
      This branch of the Thread Tools code has been rewritten for the next build, but I don't know if it will be sufficient to stop this error.

      Can you consistently re-encounter this error? Please list the exact steps needed to do so.
      Reply Reply  
    4. November 18, 2009 11:19 AM
      Hostboard Hostboard is offline
      Junior Member
      This was done by a user and not by myself. The cut and past was from the email notice. I'll try to contact the member and see if they remember what they did.
      Reply Reply  
    5. This petition for a change to Confirmed was rejected
      November 22, 2009 5:51 PM
      Hostboard Hostboard is offline
      Junior Member
      Got is again PM'd user trying to get steps that led up to it.

      Code:
      Database error in vBulletin 3.8.3:
      
      Invalid SQL:
      
              DELETE FROM vault_revision
              WHERE threadid IN ();
      
      MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
      Error Number  : 1064
      Request Date  : Sunday, November 22nd 2009 @ 02:41:03 PM
      Error Date    : Sunday, November 22nd 2009 @ 02:41:03 PM
      Script        : http://www.MyDomain.com/forums/postings.php?do=domovethread&t=190794
      Referrer      : http://www.MyDomain.com/forums/postings.php?t=190794&pollid=
      IP Address    : 65.xxx.xx.86
      Username      : R0cketer
      Classname    : vB_Database_MySQLi
      MySQL Version :
       
    6. November 23, 2009 9:23 AM
      Hostboard Hostboard is offline
      Junior Member
      Ok here is what the user stats he was doing.

      I was trying to move the post on the main board (This would be his specific forum as there is no "main board" on our site) that someone had been about a scanner. I clicked the edit thread, move thread and selected non sports and it gave the error. I tried again and it said couldnt move to same board, so it had moved it, just didn't think it had. I'm not at home so was trying to do it quick so my normal attention wasn't up to snuff.

      I have 2 Wiki's enabled for testing purposes in 2 other forums and not in theirs. The basic idea of how my forums are laid out

      Top Level
      -Catagory1
      --Forum1
      --Forum2
      -Catagory2
      --Forum1
      --Forum2

      There are hundreds and hundreds of catagories and forums

      The Wiki is in the Administrative catagory and is linked within 2 forums there in. The error is being reported outside within another catagory structure.
      Reply Reply  
    7. November 23, 2009 12:58 PM
      pegasus pegasus is offline
      VaultWiki Team
      I'm going to mark this as fixed for the next build. While I can't understand how the user is bypassing the empty() check which occurs around the query, it shouldn't be occurring outside any wiki forums anyway.
      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 1:44 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.