Issue: Fatal DB Error causing inability to move threads/forums

Issue Tools
- View Changes

August 27, 2009 12:15 AM

Badorties

New Member

Fatal DB Error causing inability to move threads/forums

After installing vaultwiki i am now unable to move threads from forum to forum, regardless of whether the thread/forum is a part of the wiki. if i disable vaultwiki it works. when attempting to move threads i receive the following error

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT postid, thread.threadid, firstpostid

FROM post AS post
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
WHERE post.id IN (70);

MySQL Error : Unknown column 'post.id' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 26th 2009 @ 08:35:25 PM
Error Date : Wednesday, August 26th 2009 @ 08:35:25 PM
Script : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
Referrer : http://majorcommand.com/boards/postings.php?t=75&pollid=
IP Address : 99.252.200.243
Username : Badorties
Classname : vB_Database_MySQLi
MySQL Version : 5.0.22

if it helps, i have vaultwiki as well as categories installed.

Issue Details

Issue Number 802

Issue Type Bug

Project VaultWiki 3.x Series

Category Inline Moderation

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.5.1

Fixed Version 2.5.2

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)

August 27, 2009 1:01 AM

pegasus

VaultWiki Team

Duplicate of: http://www.crackedeggstudios.com/issues/797/

Reply
August 27, 2009 2:18 AM

Badorties

New Member

noticeably different is the calling script, this one being postings.php, whereas 797 references inlinemod.php. not sure if the fix action is correct however, as i cant locate the inlinemod_start plugin you reference

Reply
August 27, 2009 7:39 AM
pegasus

VaultWiki Team
You're right. While the cause of the bug is the same, because it occurs on a different page the fix is going to be different. In AdminCP > Plugins & Products > Plugin Manager, locate the plugin for product "CES VaultWiki" at hook location "threadmanage_start", and click "Edit".

The correct code is:

Code:

$getforumids = ($_POST['do'] == 'domovethread'); require_once(DIR . '/vault/special_plugins_inlinemod.php'); special_inlinemod_start($threadinfo['threadid'], 'thread', $getforumids); if ($getforumids) { special_inlinemod_protect(); }
Reply
August 27, 2009 10:44 AM

tommythejoat

Regular Member

I just bumped into this one also. I came to report the bug, but found the fix and installed it.

It works fine, but are there any other move/copy option locations that are going to bite us?

Reply
August 27, 2009 3:55 PM

pegasus

VaultWiki Team

There were a number of plugins that were modified in 2.5.1 but that were never added to the package due to our server's sync issue described in the other thread. At this time, I'm not aware of any other locations that were changed that would now result in "fatal" errors.

Reply

August 27, 2009 4:03 PM

Badorties

New Member

this brought a new bug for me, the move actually works but throws another fatal error

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

		SELECT bookid, threadid
		FROM vault_book
		WHERE top_bookid IN (75);

MySQL Error   : Unknown column 'top_bookid' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, August 27th 2009 @ 01:01:26 PM
Error Date    : Thursday, August 27th 2009 @ 01:01:26 PM
Script        : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
Referrer      : http://majorcommand.com/boards/postings.php?t=75&pollid=
IP Address    : 67.172.167.177
Username      : na641
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.22

August 27, 2009 4:18 PM
pegasus

VaultWiki Team
I have checked and this column is added by both the install script and the upgrade script, so this seems almost impossible to me (unless the upgrade script didn't successfully run step 1 from 2.5.0 to 2.5.1).

You can add this field manually by running the following database query:

Code:

ALTER TABLE vault_book ADD COLUMN top_bookid INT(10) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX top_bookid (top_bookid)
Reply

+ Reply

All times are GMT -4. The time now is 9:29 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: Fatal DB Error causing inability to move threads/forums

Issue Tools