Issue: Conflict with project tools

Issue Tools
- View Changes

November 6, 2010 10:19 PM

SSSlippy

Junior Member

Conflict with project tools

When deleting a project from project tools I get the following error. This is not a show stopper as the project still uninstalls but still an error.

PHP Code:

Database error in vBulletin 4.0.8: Invalid SQL: DELETE vault_link FROM vault_link LEFT JOIN issuenote AS note ON (note.issuenoteid = vault_link.postid) WHERE vault_link.type = 3 AND issuenoteid IS NULL; MySQL Error : Table 'immortal_forum.issuenote' doesn't exist Error Number : 1146 Request Date : Saturday, November 6th 2010 @ 10:17:08 PM Error Date : Saturday, November 6th 2010 @ 10:17:08 PM Script : http://immortal-guild.net/admincp/project.php?do=projectkill Referrer : http://immortal-guild.net/admincp/project.php?do=projectdelete&projectid=2 IP Address : 68.194.203.239 Username : SSSlippy Classname : vB_Database_MySQLi MySQL Version : 5.1.49

Issue Details

Issue Number 2059

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 3.0.4

Fixed Version 3.0.6

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 8, 2010 1:59 PM

pegasus

VaultWiki Team

In the Plugin Manager find the VaultWiki plugin called "Project Data - Delete Cached Links". Edit the plugin, and replace its PHP code with this:

Code:

if ($this->registry->options['vault_caching'])
{
	global $vault;

	$vault->fetch_instance('contenttype');

	$this->dbobject->query_write("
		DELETE " . ($include_prefix ? TABLE_PREFIX . "vault_" : "") . "link
		FROM " . TABLE_PREFIX . "vault_link AS link
		LEFT JOIN " . TABLE_PREFIX . "pt_issuenote AS note ON (note.issuenoteid = link.postid)
		WHERE link.type = " . intval($vault->misc['contenttypes']['pt']) . "
			AND issuenoteid IS NULL
	");
}

+ Reply

All times are GMT -4. The time now is 1:11 PM.

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: Conflict with project tools

Issue Tools