Issue: In line mode move thread error

Issue Tools
- View Changes

August 24, 2009 2:59 PM

tommythejoat tommythejoat is offline

Regular Member

In line mode move thread error

vBulletin says this is not their problem with bad sql since the string post.id does not exist

This morning we started getting lots of database errors from moderators trying to move posts. The error screen is:

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 (54035);

MySQL Error   : Unknown column 'post.id' in 'where clause'
Error Number  : 1054
Request Date  : Monday, August 24th 2009 @ 12:51:58 PM
Error Date    : Monday, August 24th 2009 @ 12:51:58 PM
Script        : http://mb.nawcc.org/inlinemod.php?do=domovethreads&threadids=54035
Referrer      : http://mb.nawcc.org/inlinemod.php?forumid=11
IP Address    : 66.189.87.170
Username      : TMcIntyre
Classname     : vB_Database
MySQL Version : 5.0.27-standard

The WHERE post.id is the broken bit. Is there any possibility that Vault Wiki is involved here? I made no changes except to upgrage to 3.8.4 and 2.5.1.

I can't find post.id in any vBulletin file.

Issue Details

Issue Number 797

Issue Type Bug

Project VaultWiki 3.x Series

Category Inline Moderation

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.5.1

Fixed Version 2.5.2

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 1

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 24, 2009 3:34 PM

tommythejoat

Regular Member

I cannot find the string post.id in any file on my system.

I suspect there is a bad edit expression somewhere that got triggered by post.postid and "corrected" it to post.id.

I have no idea how to go about finding this. Is the a standard regular expression that is used to find duplicate strings sequentially in text? If so, I could probably search for that.

I do not think this is a vBulletin problem since it would have blown up the world for them. It happens on every attempt to move a post on my message board.

Reply
August 24, 2009 4:28 PM
pegasus

VaultWiki Team
This is a result of code in 2.5.1 that isn't included in the package, which baffles me, since we spent almost a week on this.

The inlinemod_start plugin SHOULD read:

Code:

require_once(DIR . '/vault/special_plugins_inlinemod.php'); if ( !empty($_POST['title']) AND ( $_POST['do'] == 'domoveposts' OR $_POST['do'] == 'docopyposts' ) ) { special_inlinemod_movestart(); } $getforumids = ($_POST['do'] == 'domovethreads' OR $_POST['do'] == 'domergeposts'); if (!empty($threadids)) { special_inlinemod_start($threadids, 'thread', $getforumids); } else if (!empty($postids)) { special_inlinemod_start($postids, 'post'); } if ($getforumids) { special_inlinemod_protect(); }

This is the SECOND plugin reported that was not updated in the ZIP even though we did make changes to it. This is probably due to the plugin system we use on our servers, where the database is not automatically updated after a change is made (our plugins are stored in the file system). I have updated the instructions we use for compiling the ZIP, so we don't overlook this possibility in the future.
Reply
August 24, 2009 7:03 PM

tommythejoat

Regular Member

Thanks for the quick response. This one was a little painful since our moderators do not delete posts but move them to a quarantine area.

Reply

+ Reply

All times are GMT -4. The time now is 11:43 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: In line mode move thread error

Issue Tools