Issue: Moving Wiki Threads - DB error

Issue Tools
- View Changes

November 17, 2009 9:39 AM

Hostboard

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)

November 17, 2009 3:45 PM

pegasus

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
This petition for a change to Awaiting Feedback was accepted
November 17, 2009 9:54 PM

Hostboard

Junior Member

I have wiki setup as a test in 1 forum only. The forum where this error occured does not have a wiki.
November 18, 2009 2:42 AM

pegasus

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
November 18, 2009 11:19 AM

Hostboard

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

This petition for a change to Confirmed was rejected

November 22, 2009 5:51 PM

Hostboard

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 :

November 23, 2009 9:23 AM

Hostboard

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
November 23, 2009 12:58 PM

pegasus

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

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

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Moving Wiki Threads - DB error

Issue Tools